Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.misc -> Re: Newbie Help w/Date Value and passing to VB5

Re: Newbie Help w/Date Value and passing to VB5

From: mark tomlinson <marktoml_at_gdi.net>
Date: 1998/04/29
Message-ID: <354969e5.421659484@newshost.us.oracle.com>#1/1

Here is a DAO sample of dates...

Dim odb As Database
Dim ody As Recordset

Set odb =
OpenDatabase(ODBC, False, False,ODBC;DSN=ORA32;UID=SCOTT;PWD=TIGER") Set ody = odb.OpenRecordset("SCOTT.EMP", dbOpenDynaset) ody.FindFirst "Hiredate = #03-DEC-81#"

Do Until ody.NoMatch
 Combo1.AddItem ody.Fields("ENAME")
ody.FindNext "Hiredate = #03-DEC-81#"
Loop Received on Wed Apr 29 1998 - 00:00:00 CDT

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US