Sorry for the OT guys, but I'm not getting any response on
forums.codegear.com, and since you guys know your stuff, I'm hoping for
some tips.
I am using an ADO stored proc to call a stored proc on a MSSQL server.
One of the parameters in the stored proc on the server is a
Decimal(28,20) but
I am using an ADO stored proc to call a stored proc on a MSSQL
server.
One of the parameters in the stored proc on the server is a
Decimal(28,20) but delphi detects this in the parameters list and
sets it to ftBCD, precision 28, scale of 20.
It sounds like you are using the stored
Angus,
Thanks for the response.
Yes I'm using the stored proc component. No data aware controls.
So, you solution would be something like creating a string:
exec sp_InsertVehicleData;1 '2009/01/17
15:48:12',1,'0358104000636686','0F611B8C',17,$53.5161,$-2.2367,0,$15475.
Angus,
Fantastic answer. Thanks for going the extra distance to explain it.
It's appreciated.
Yep to the application :)
Regards,
Andy
Angus Robertson - Magenta Systems Ltd wrote:
exec sp_InsertVehicleData;1 '2009/01/17
15:48:12',1,'0358104000636686','0F611B8C',17,$53.5161,$-2.2367,0
