On Mon, 11 Jul 2011, Ludo Brands wrote:
Hmmm... I seem to recall prepare and bind parameters in
fcl-db/mySQL component source?. Are you sure about this? I
really, really, really need double precision data to work. I
know i've used binary binds with Int64 arrays and things well
beyond 8 bytes binary. _______________________________________________
I see that the functions and structures are defined in mysql.inc but they
aren't used anywhere. Parameter values are substituted in the sql string
that is sent to the db and TConnectionName.PrepareStatement doesn't send
anything to the db.
The Oracle component fe. uses bindings.
So does Firebird, and I think postgres, but I'm not sure about the latter.
The reason is that when sqldb was created, MySQL (4.0 or 4.1) didn't support
parameters yet. Support for this would mean that the mysql connection component
needs to be rewritten for MySQL 5.0 and higher.
Michael.
_______________________________________________
fpc-devel maillist - [email protected]
http://lists.freepascal.org/mailman/listinfo/fpc-devel