Tony,

I think, if you want to use default values with a TIBOQuery, without much hassle, then you could use the DefaultValues property which is a StringList. Something in the line of:

IBOQuery.DefaultValues.Add('DATE_CREATED=NOW');
IBOQuery.DefaultValues.Add('DEFAULT_USER=guest');

You can even do this at design time by right-clickin on the TIBOQuery and choosing Edit Query -> Field Properties

Works for me. Hope it works for you too.

James N Hitz


[Non-text portions of this message have been removed]