Failure to edit or delete records using IBX
Posted on 2006-06-04
This should be an easy question to answer. I have a ready-made interbase (v6) database I want to manipulate using Delphi (v6) and IBX components. I can insert records without a problem, but cannot edit or delete records.
I have a TIBDatabase, IBTransaction, IBDataset, and a DataSource hooked up together with the Dataset SelectSQL = ‘Select * from mytable’ and all the other SQL strings autogenerated.
I can insert using:
(fill fields in here)
No problem. But, when I try to edit by:
(Modify fields in here)
Nothing appears to happen. Similarly with delete.
I’ve tried using cachedupdates and even writing the ModifySQL statement to SelectSQL and using MyDataset.ExecSQL without success. Can somebody tell me what I’m doing wrong?