Page 1 of 1

Migrating dbExpress project to ODAC, what about params?

Posted: Wed 02 Nov 2011 09:02
by marilyn.works
I am migrating existing project under delphi XE that uses dExpess.
Parameters that are passed to queries now are ftFMTBCD, but in ODAC the type is empty (TOraQuery replace TsqlDataSet). In DFM the type of the parameter is still set - ftFMTBCD, it actualy works. My question is
is it good to stay as it is or shoud be replaced by other type, Integer is not option, neither float.
This is done on server side, we have multi-toer application, on client side I`va chaneged nothing and prefer to stay so.

Thanks for any help!

Posted: Wed 02 Nov 2011 12:38
by AlexP
Hello,

If parameter type is not set, ODAC defines its type automatically. It's not necessary to define parameter types explicitly if simple types are used as parameters. If you are using Objects, Cursors, etc, as parameters, you should specify their types explicitly.