Whats happening:
Error#: 40002
Error Item: 01000: [Microsoft...][ODBC...][SQL...]The Statement has
been terminated. > GETID 'INSERT INTO Table(Column1, Column2, Column 3,
Column4, Column5, Column6) VALUES
("","Value1","Value2","Value3","Value4","Value5 ")'
Error Message: 01000: Microsoft...][ODBC...][SQL...]The statement has
been terminated.
Active Form: frmForm
Form Name:
---
GETID Stored Procedure:
---
CREATE PROCEDURE GETID @strsql text AS
PRINT cast(@strsql as varchar(4000))
EXEC(" "
+@strsql + " select @@identity as id")
GO
---
Anyone know what could be causing it? The database has changed - the
frontend code hasn't, so it has to be a database problem. What
happened was a few tables became incorrect so we restored them from a
backup. Everything else seems to work, apart from adding a new record
to this table.
You can edit current records etc..just not add.
Thanks in advance,