List:MySQL on Win32« Previous MessageNext Message »
From:<jbonnett Date:November 16 2005 10:12pm
Subject:RE: DAO with mysql 5.0
View as plain text  
I think you can just write

    Set recsetEmployees =
dbEmployees.OpenRecordset("Select * from employees where age > 30",
dbOpenDynaset)

It looks like you are using a data control. I find them more trouble
than they are worth, except for very simple database access. They are
good for beginners and allow you to get something going quickly but you
soon grow out of them when you try to do anything more complicated.

John B.

-----Original Message-----
From: Mark Mchugh [mailto:mark_mch@stripped] 
Sent: Wednesday, 16 November 2005 2:17 AM
To: mysql list
Subject: DAO with mysql 5.0

Hi,
I am using the following code

  Set dbEmployees = OpenDatabase("", dbDriverComplete,
False,
"ODBC;DSN=myEmployees;UID=root;PWD=;Database=Employees")

     
         
    Set Data1.Recordset = recsetEmployees 


is there anyway to have a DAO recordset that i can
define the sql? 

i.e. "Select * from employees where age > 30"


thanks

Mark


		
__________________________________ 
Yahoo! FareChase: Search multiple travel sites in one click.
http://farechase.yahoo.com

Thread
DAO with mysql 5.0Mark Mchugh15 Nov
  • Re: DAO with mysql 5.0SGreen15 Nov
RE: DAO with mysql 5.0jbonnett16 Nov