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
> exec sp_InsertVehicleData;1 '2009/01/17
> 15:48:12',1,'0358104000636686','0F611B8C',17,$53.5161,$-2.2367,0
> ,$15475.
> 5996,$0.,$0.,0,0,'S',0,0,0,0,0,0,0,0,'',$-2.2367,$53.5161,$6
> 5535.000
> 0,0x010358104000636686FF447800344015FF2A0F611B8C11EAC5738C791056
> 42C0260F
> C8B90
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.
5996,$0.,$0.,
> 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 pro
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 de