Hi all



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



Andy



[Non-text portions of this message have been removed]