[INFO] creation date OF RECORD. NOW().

[Ruslan Zasukhin]

On 21/3/07 11:09 AM, "Kim Kohen" <kim at webguide.com.au> wrote:

Hi Kim,

>> 1) So you want create a record and one its field should have NOW
>> value.
>> Why not simply as:
>> 
>>     INSERT INTO T1( f1, f2, f3) VALUES ( NOW(), x, y )
> €€€€
> yes, I knew it can be coded around, it just seemed like it should
> work.  Would it make more sense to generate an error in the field
> rather than garbage data?  Or trap for a function rather than a
> constant in VStudio?

Problems is that your "now()" is stored as string,
Then interpreted as date => garbage.

Yes something should be improved.


>> 2) We have check and remember that DEFAULT VALUE of field can be
>> only a
>> constant by SQL92. You cannot specify here NOW() or other formula.
> €€€€
> But wouldn't it be cool if you could:)

Hard to say. If you want add request

>> 3) in upcoming Valentina 3.0 the case (1) can be simplified by
>> usage of
>> trigger.
> €€€€
> every time I read about triggers and stored procedures I think of new
> ways to use them. Seems like a really neat way to set ObjectPtrs
> during inserts.  I seem to recall mention of 3.x betas in a few
> weeks. Is that right?

Yes. We want finish last issues in Stored Procedures, then we will start
make betas of 3.0


-- 
Best regards,

Ruslan Zasukhin
VP Engineering and New Technology
Paradigma Software, Inc

Valentina - Joining Worlds of Information
http://www.paradigmasoft.com

[I feel the need: the need for speed]