Subject | Entering Litterals, Expressions directly into TIBOQuery Update SQL |
---|---|
Author | Tony Masefield |
Post date | 2006-06-23T06:07:26Z |
Hi All,
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?
Rgds,
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?
Rgds,