Tony Masefield wrote:

> I *discovered* that I can enter litterals, such as dates (NOW - for
> current timestamp) or expressions (such as the primary key of the
> master table in a detail table query) in a TIBOQuery UPdateSQL Insert
> rather than using a domain with NOW default, or using *OnUpdateRecord*
> respectively.
> I'm relatively new to SQL and CS so just wondering if there are any
> problems I didn't anticipate doing it this way (which may manifest
> themselves further down the line) rather than the *traditional* way (as
> per the example documents I have) of using domain defaults and
> OnUpdateRecord?

Tony - think of the SQL as another language - which it is.
All IBO is doing - and doing very well - is building queries in SQL in a
manor that hides some of the complexity of Firebird SQL. Any SQL that
you write yourself can include ANYTHING that is valid SQL, and
components such as DSQL will run that SQL code. Once you start playing
with things like UpdateSQL you really need to understand how that works
in conjunction with IBO's own processing of the TIBOQuery SQL.

Personally I have never had to change the way IBO handles a query
itself, IBO does that for me without any problem. You will only need to
'help' IBO when you start producing complex or non-standard SQL -
something you are unlikely to do if you are just starting ;)

--
Lester Caine - G8HFL
-----------------------------
L.S.Caine Electronic Services - http://home.lsces.co.uk
Model Engineers Digital Workshop -
http://home.lsces.co.uk/ModelEngineersDigitalWorkshop/
Treasurer - Firebird Foundation Inc. - http://www.firebirdsql.org/index.php