ADODC recordsource property prob

[gust1480]

Can somebody please tell me how to query my ORACLE tables by selecting the current date on the table and placing the script to the recordsource property of my ADODC..recordsource doesn't recognize a function like sysdate....was trying this script...
select * from orders where date = sysdate
but it doesn't work. pls help.

 

[johnwm]

The Date() function in VB will produce the current system date

___________________________________________________________
If you want the best response to a question, please check out FAQ222-2244 first.
'If we're supposed to work in Hex, why have we only got A fingers?'
Drive a Steam Roller
Steam Engine Prints

 

[PZOL]

You probably want the records for the current day, but SYSDATE yields the complete timestamp, with granularity of seconds.

Supposing that your 'date' field also contains timestamp values (BTW is it really named 'date'? This seems to be a reserved datatype keyword) you can change your query as follows:

select * from orders where TRUNC(date) = TRUNC(sysdate)