Can't find the information you are looking for here? Then leave a message over on our WinBatch Tech Support Forum.
Keywords: DAO Filter records ,MDB
And make sure that version 3.5 (35 above) is installed. Open up the registry editor on the PC and do a search for:
DAO.DBEngine
If it's installed it will show up as: DAO.DBEngine.35
dao=ObjectOpen("DAO.DBEngine.35") ws=dao.CreateWorkspace("JetWorkspace","admin","") user_db=ws.OpenDatabase("Users.mdb") user_rs=user_db.OpenRecordset("select * from usernames")
This code will filter records where censored = 0 AND id >= 1024.
user_rs.filter="censored = 0" user_rs=user_rs.OpenRecordset user_rs.filter="id >= 1024" user_rs=user_rs.OpenRecordset
This code will filter records where censored = 0 OR id >= 1024.
user_rs.filter="censored = 0 OR id >= 1024" user_rs=user_rs.OpenRecordset
This code will sort by id DESC.
user_rs.sort="id DESC" user_rs=user_rs.OpenRecordset
Article ID: W15599
File Created: 2003:05:13:11:29:10
Last Updated: 2003:05:13:11:29:10