Numeric Data in SQL insert

[Colin Haig]

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

[Enrico Maria Giordano]

Colin,

here it is a sample:

Code: Select all  Expand view

cSql = "INSERT INTO MyTable ( MyNumericField ) VALUES ( " + LTRIM( STR( nMyValue ) ) + " )"

EMG

[Colin Haig]

Hi Enrico

Thank you very much !!!!!

Cheers

Colin

[Francisco Horta]

colin

try

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

regards
paco

[Armando]

Colin:

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

Regards