IBConnection - No fields for inclusion in where statement found
Original Reporter info from Mantis: valdir.marcos @valdir.marcos
-
Reporter name: Valdir Marcos
Original Reporter info from Mantis: valdir.marcos @valdir.marcos
- Reporter name: Valdir Marcos
Description:
I have attached a small sample project.
IBConnection doesn't seem to be parsing DML commands from a simple table with primary key.
SQLQuery3.ParseSQL := True;
Steps to reproduce:
Run the program;
Click on "TStringField" button. It will open Form3;
Click on "Open for Edit" button. It will load information;
Change information about "Observation" field;
Click on "Save" button. It will show extra information about transactions;
Then, comes the message:
----------------------
[Debugger Exception Notification]
Project project1 raised exception class 'EDatabaseError' with message:
IBConnection1 : No update query specified and failed to generate one. (No fields for inclusion in where statement found)
At address 57F999
[Ignore this exception type]
[Break] [Continue]
----------------------
Additional information:
Firebird 2.5.8
Create Table TableText
(
ID Integer Not Null Primary Key,
Observacao VarChar(1000) Collate Unicode_CI_AI
);
Commit;
Insert Into TableText(ID, Observacao) Values(1, 'aaaaaaa');
Commit;
Select * From TableText;
Mantis conversion info:
- Mantis ID: 34697
- OS: Windows
- OS Build: 7 and 10
- Build: 59712M
- Platform: 32bit
- Version: 2.0RC2
- Fixed in version: 3.3.1
- Fixed in revision: 1525 (#8ba6c255).
- Target version: 3.2.0