Which component to use MySql database?

[zzzato]

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.

[Lacak2]

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]

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.