Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations Chriss Miller on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Question about DAO ... 1

Status
Not open for further replies.

HadiRezaee

Technical User
Joined
Mar 9, 2001
Messages
165
Location
IR
Hi all,
I want to know, how can i run SQL statment in CDaoRecordset ???
 
Record set do nothing. You can do in only from CDaoQueryDef. John Fill
1c.bmp


ivfmd@mail.md
 
Thanks for your reply.
For adding date and time to DATE field in access database, i got example that wrote by SQL:
INSERT INTO [MYTABLE] ([MYDATE]) VALUES (#06/14/2001 2:18:21 PM#);

Now, i want to know, i have any other way to adding date and time to date field ??? (i mean using of CDaoRecordset ?).
 
you can try CDaoFieldExchange John Fill
1c.bmp


ivfmd@mail.md
 
hmmm, ok. can you write example about using CDaoQueryDef and CDaoFieldExchange ???
 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top