> exec sp_InsertVehicleData;1 '2009/01/17 > 15:48:12',1,'0358104000636686','00000F611B8C',17,$53.5161,$-2.2367,0 > ,$15475. > 5996,$0.0000,$0.0000,0,0,'S',0,0,0,0,0,0,0,0,'',$-2.2367,$53.5161,$6 > 5535.000 > 0,0x010358104000636686FF447800344015FF2A00000F611B8C11EAC5738C791056 > 42C0260F > C00008B90400000000C0260FC07910564200FF7F47900105,60,1,'447800344015'
So you're collecting moving vehicle GPS data from a UK mobile telephone modem for a map, seen it all before <g> > So, you solution would be something like creating a string: Essentially yes, except ADO adds sp_ and ;1 so just use the stored procedure name: exec InsertVehicleData xxx And you've got a wide range of data types in your parameter list there, which you need to ensure match the data types in the stored procedure, those hex strings look strange, but then I don't store binary stuff. You're original error could be in those strings. You might be better passing strange numbers as VARCHAR and converting them to numerics in the stored procedure itself, assuming you can mess with it. Getting back on topic with ICS, this is how I build the parameter to save my FTP server statistics in SQL: cmd := 'EXEC ftp_events_updx1 ' + IntToStr (FtpServers [servnr].StartId) + paramSep + QuotedStr (EventState) + paramSep + QuotedStr (Comment) + paramSep + '0' + paramSep + // endpos IntToStr (FtpServers [servnr].TotalXmit) + paramSep + IntToStr (FtpServers [servnr].TotalRecv) + paramSep + IntToStr (secs) + paramSep + // duration secs IntToStr (FtpServers [servnr].MaxSpeedXmit) + paramSep + IntToStr (FtpServers [servnr].MaxSpeedRecv) ; ExecSqlFtpCmd (cmd) ; and this is the core of the function to call SQL and get a resultset, which just contains two fields with an error code and description in this case, but could be a million records. DataSetFtpUpd.Recordset := ADOConn.Execute (cmd) ; if DataSetFtpUpd.RecordCount = 1 then begin dbretcode := DataSetFtpUpd.Fields.DisplayText ; result := AscToInt (DataSetFtpUpd.Fields.DisplayText) ; end ; Angus -- To unsubscribe or change your settings for TWSocket mailing list please goto http://lists.elists.org/cgi-bin/mailman/listinfo/twsocket Visit our website at http://www.overbyte.be