>I am trying to update a coloum in Firebird via the following SQL command
>
>SQLCommand = vbNullString
>SQLCommand = SQLCommand & "UPDATE ProductTable "
>SQLCommand = SQLCommand & "SET "
>SQLCommand = SQLCommand & "CURRENTLEVELS = CURRENTLEVELS - '" & Format(Readin(3), "#####0") & "' "
>
>SQLCommand = SQLCommand & "WHERE "
>SQLCommand = SQLCommand & "BARCODENUMBER='" & Readin(2) & "' and "
>SQLCommand = SQLCommand & "STOCKCONTROLYN='1';"
>
>ReadIn(3) is a value that comes from the data file
>
>My problem is this The above SQL command works on MySQL, MSSQL, PostgreSQL But it will not work on
>Firebird
>
>My application that is doing the processing crashes when it run agenst Firebird
>
>So what is the Firebird version of this?
>
>basically I want to update the CURRENTLEVELS orginal value but take away the
>Readin(3) value

Hi Andy!

Basically, your SQL call is something like:

UPDATE ProductTable
SET CurrentLevels = CurrentLevels - '<value>'
WHERE BarcodeNumber = '<AnotherValue>'
AND StockControlYN = '1'

The problem I see here, is that <value> seems to be a string - there should not be ' around the value if it is a number. Firebird does not support deducting from a string, at least not this way (there may be UDFs or similar that can do it). If BarcodeNumber and StockControl are CHAR or VARCHAR, then it is of course correct to use ' around them.

HTH,
Set