[prev in list] [next in list] [prev in thread] [next in thread] 

List:       mysql-win32
Subject:    RE: DAO with mysql 5.0
From:       <jbonnett () sola ! com ! au>
Date:       2005-11-16 22:24:30
Message-ID: CDD2448EDE5CAE4499CA5828A4CAF788B9CA01 () pine ! ap ! sola ! com
[Download RAW message or body]

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@yahoo.com] 
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


-- 
MySQL Windows Mailing List
For list archives: http://lists.mysql.com/win32
To unsubscribe:    http://lists.mysql.com/win32?unsub=mysql-win32@progressive-comp.com


[prev in list] [next in list] [prev in thread] [next in thread]