FiveTech Support Forums

Hi All

I am interfacing my software with QuickBooks - in my SQL insert statements I do the following

do while cInvcNo == oInvItms:invcno .and. ! oInvItms:eof()
aadd(aInvItems,{cClient,cInvcNo,nQty,nAmount})
oInvItms:skip()
enddo

for I := 1 to len(aInvData)
cSql :=''
cSql+= "INSERT INTO InvoiceLine (ClientName,InvoiceNumber,LineQuantity,LineAmount) VALUES ('" + aInvItems[I,1] + "','" + aInvItems[I,2] + "', // how to insert numeric values



Cheers

Colin

Colin,

here it is a sample:



EMG

Hi Enrico

Thank you very much !!!!!

Cheers

Colin

colin

try

INSERT INTO MyTable ( MyNumericField1,MyNumericField2 ) VALUES ( " + STR( nMyVal1 ) + "," + STR( nMyVal2 ) + " )"

regards
paco

Colin:

In SQL, everything is stored as string, example for Date fields you should use DTOS(YourDate).

Regards