Prevent automatic generation of SQL statement
Posted: Sat 22 Nov 2008 19:58
I have a FB table which I want to allow insertion and modification of records but deny record deletion.
If I construct a Select statement in a IBDAC table component and leave the update SQL's unchanged the Insert, Update, Refresh, Delete SQL statements will be generated automatically - which is fine except I don't want the DELETE statement to be generated.
How do I prevent the automatic generation of a particular SQL statement (in this case the DELETE). I know that I can write my own DELETESQL statement which will be used - but I don't want a delete statement at all.
Peter
If I construct a Select statement in a IBDAC table component and leave the update SQL's unchanged the Insert, Update, Refresh, Delete SQL statements will be generated automatically - which is fine except I don't want the DELETE statement to be generated.
How do I prevent the automatic generation of a particular SQL statement (in this case the DELETE). I know that I can write my own DELETESQL statement which will be used - but I don't want a delete statement at all.
Peter