Problem with SQLite

[madmatrix]

Hi all,

I just started learning Autoit and want to insert some values into my current SQLite table. Here is my SQLite command:

_SQLite_Exec(-1, "INSERT INTO Inventory(ItemNum,InventoryNum,OrderNum,SKU,Product,OrderDate,Quant,Price,ShippingCost,Tax,Discount) VALUES ($sItemNum,$sInventoryNum,$sOrderNum,$aSKU[$j],$aProduct[$j],$sOrderDate,$aQuant[$j],$aPrice[$j],$dShippingCost/(UBound($sResults)-1),$dTax/(UBound($sResults)-1),$dDiscount);")

Autoit says error reading [j] that I uses as index in the loop. Don't know why this variable can't be evaluated in SQLite command.

Any Idea?

Thanks.

Lou

[PsaltyDS]

Hi all,

I just started learning Autoit and want to insert some values into my current SQLite table. Here is my SQLite command:

_SQLite_Exec(-1, "INSERT INTO Inventory(ItemNum,InventoryNum,OrderNum,SKU,Product,OrderDate,Quant,Price,ShippingCost,Tax,Discount) VALUES ($sItemNum,$sInventoryNum,$sOrderNum,$aSKU[$j],$aProduct[$j],$sOrderDate,$aQuant[$j],$aPrice[$j],$dShippingCost/(UBound($sResults)-1),$dTax/(UBound($sResults)-1),$dDiscount);")

Autoit says error reading [j] that I uses as index in the loop. Don't know why this variable can't be evaluated in SQLite command.

Any Idea?

Thanks.

Lou

You have the variable references inside the quotes, making them plain strings. It should be more like this:

$sQuery = "INSERT INTO Inventory(" & _
                "ItemNum,InventoryNum,OrderNum,SKU,Product,OrderDate,Quant,Price,ShippingCost,Tax,Discount) " & _
                "VALUES (" & $sItemNum & "," & $sInventoryNum & "," & $sOrderNum & "," & $aSKU[$j] & "," & _
                $aProduct[$j] & "," & $sOrderDate & "," & $aQuant[$j] & "," & $aPrice[$j] & "," & _
                $dShippingCost/(UBound($sResults)-1) & "," & $dTax/(UBound($sResults)-1),$dDiscount) & ";"
        _SQLite_Exec(-1, $sQuery)

Edited August 4, 2008 by PsaltyDS