Subject:
From:
Date: 80040E57 - dump the edit sql response
Ron ()
7/6/01 1:05:52 PM


When I did the dump sql I get the following response
Edit SQL=UPDATE [lds genotypes] SET MPI = , Genotype = 'test' WHERE MPI = 123456


Error # (Edit_Execute_SQL) = 80040E14(-2147217900)
Description = [Microsoft][ODBC SQL Server Driver][SQL Server]Line 1: Incorrect syntax near ','.
Source = Microsoft OLE DB Provider for ODBC Drivers
SQL State = 37000
Native Error = 170

It seems that it is not remembering mpi which is set to read only field.

Thanks for your response.
Ron.