Hi folks,

Using Delphi 5.0, IBO 3.6D and the following TIB_Query:

SELECT OTTYPE.OTTID
, OTTYPE.NAME
, OTTYPE.WATER
, OTTYPE.DEFAULTSUMMARY
, SUMMARYCAT.NAME as CatName
FROM OTTYPE
LEFT OUTER JOIN SUMMARYCAT on OTTYPE.DEFAULTSUMMARY = SUMMARYCAT.SCID

I want to update the OTTYPE table (either insert or edit a current record).
I decided to use the UpDateSQL fields of the query and generated the SQL
code, but could not figure out the to use the Query. I tried (among others)
the following

...
with q do
begin
Insert;
FieldByName(':OTTID').asInteger := RID; // obtained rid from a generator
FieldByName(':NAME').asString := 'Name';
FieldByName(':WATER').asString := 'T';
FieldByName(':DEFAULTSUMMARY').asInteger := 99;
Post;
end;

This did not work, but what would have?

THIA
Marv