Recent

Author Topic: Which component to use MySql database?  (Read 2717 times)

zzzato

  • New Member
  • *
  • Posts: 22
  • A delphi developer who is moving to debian
Which component to use MySql database?
« on: May 07, 2013, 09:32:07 am »
Hi, All.

I would to write something in lzarus to to use Mysql 5.1 same database .

Some mont ago I tried zeos with Oracle (8,9,10, 11g 32/64 bit).
And I had issue about stored procedure.
So, i want to explain what I need to do:

1) execute standard sql statement with strict join and outer join.
Some table has blob (text) field and decimal fields.

2) call stored procedure with IN, OUT and INOUT parameters.
Ad this moment,  parameters are int, smallint, varchar and text.

I need to do these operations inside a thread, and I can have max 30 threads runnings.


Thanks for any suggestion!

Best.

A.
"Anything that can go wrong will go wrong"

Lacak2

  • Guest
Re: Which component to use MySql database?
« Reply #1 on: May 08, 2013, 08:00:18 am »
Ad 1) it is common thing, so IMO any db components will do it (Zeos or sqlDB)

Ad 2) this is bit complicated (I do not know how zeos handle it, but in case of sqlDB) you must use this technique f.e. (from MySQL docs, where 1st param is OUT and 2nd is INOUT):
  SET @increment = 10
  CALL p(@version, @increment)
  SELECT @version, @increment

zzzato

  • New Member
  • *
  • Posts: 22
  • A delphi developer who is moving to debian
Re: Which component to use MySql database?
« Reply #2 on: May 08, 2013, 11:11:57 am »
Ad 1) it is common thing, so IMO any db components will do it (Zeos or sqlDB)

Ad 2) this is bit complicated (I do not know how zeos handle it, but in case of sqlDB) you must use this technique f.e. (from MySQL docs, where 1st param is OUT and 2nd is INOUT):
  SET @increment = 10
  CALL p(@version, @increment)
  SELECT @version, @increment

Ok. Thanks.
"Anything that can go wrong will go wrong"

 

TinyPortal © 2005-2018