Join, UpdateSQL, and params with unknown fields
Posted on 2000-03-03
I posted a similar question previously here: Using Delphi 4, Woll2Woll components, Oracle 8 db. I want to be able to edit a query with a join. I understand that I can do this with a TUpdateSQL, one for each table in the query. The problem is it seems I have to reference field names and params in TUpdateSQL InsertSQL, deleteSQL, modifySQL statements, but I want the ability to add fields to the db in the future, so referencing fields at design time will not work. Any help with examples of syntax greatly appreciated.