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]
