Can't find the information you are looking for here? Then leave a message over on our WinBatch Tech Support Forum.
Keywords: ADO Jet Order By OrderBy Clause SELECT * FROM Query MicroSoft.Jet.OLEDB.4.0 MicroSoft.Jet OLEDB GetString
query = 'SELECT * FROM Customers ORDER BY [Last Name]' strMDB = 'D:\Temp\Data\Customers.mdb' If ! FileExist(strMDB) Then Exit oConn = "Provider=MicroSoft.Jet.OLEDB.4.0; Data Source=":strMDB oRS = CreateObject("ADODB.Recordset") oRS.CursorLocation=3 oRS.Open(query,oConn,0,1,1) ; forward-only cursor ;The GetString method returns the specified Recordset as a string. data = oRS.Getstring Pause('Results', data) oRS.Close() oRS=0 Exit
Article ID: W18033
Filename: ADO Jet Order By Clause.txt
File Created: 2011:07:14:10:37:28
Last Updated: 2011:07:14:10:37:28