Re: [twsocket] OT Delphi ADO question

2009-04-01 Thread Info2004
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

Re: [twsocket] OT Delphi ADO question

2009-04-01 Thread Angus Robertson - Magenta Systems Ltd
> 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

Re: [twsocket] OT Delphi ADO question

2009-04-01 Thread Info2004
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.,

Re: [twsocket] OT Delphi ADO question

2009-04-01 Thread Angus Robertson - Magenta Systems Ltd
> 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

[twsocket] OT Delphi ADO question

2009-04-01 Thread Info2004
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