da-soft - Data Access Technologies

Additional

dbCAP

AnyDAC

ThinDAC

NCOCI8

Topic: SYSDATE in DefaultExpression lies

Forum List » NCOCI8 » General English

Mur
User

Platinum Boarder

Posts: 116

Karma: 0

SYSDATE in DefaultExpression lies

Posted: 2001/02/13 03:50

TField.DefaultExpression = 'SYSDATE' returns local date, and no time.
I expected value of 'select sysdate from dual' (Oracle server date and time)
Is this issue in NCOCI todo list?

Diman

Admin

Posts: 1509

Karma: 20

RE: SYSDATE in DefaultExpression lies

Posted: 2001/02/13 04:41

Hello !

1. Yes, it should return DATE+TIME. So it is a bug ...

2. >> I expected value of 'select sysdate from dual'
No. All expressions in NCOCI8 are evaluating locally on client and not on server.

Mur
User

Platinum Boarder

Posts: 116

Karma: 0

RE: SYSDATE in DefaultExpression lies

Posted: 2001/02/14 03:15

NextVal('SequenceName') is evalueted on server and that's very handy feature. What's different with Systime?

Diman

Admin

Posts: 1509

Karma: 20

RE: SYSDATE in DefaultExpression lies

Posted: 2001/02/14 09:19

Hi !

Difference is:
- sequences i cant emulate
- sysdate - may try to do that.
And also some history ...

)

Honestly - yes, not a strong rule, but adopted to 95% of needs.

I will suggest to you. You can register your own expression function, or change implementation of existing one. First is better - you see why. So, you can make your own SYSDATE2, that will do:

select sysdate from dual

Regards,
Dmitry

Forum List » NCOCI8 » General English