Mobility Site - View Single Post

exbox · 11-21-03, 02:37 PM

Can someone tell me why this recordset won't open:
Rs.Source = "SELECT InvoiceNo, CustCode, CusName FROM Invoices WHERE Void = 0 ORDER BY InvoiceNo ASC"
Rs.CursorType = adOpenForwardOnly
Rs.ActiveConnection = oConnection
Rs.Open

AND this one will:
Rs.Source = "SELECT InvoiceNo, CustCode, CusName FROM Invoices ORDER BY InvoiceNo ASC"
Rs.CursorType = adOpenForwardOnly
Rs.ActiveConnection = oConnection
Rs.Open

The difference is the Where clause VOID = 0
Void is a Yes/No field.

11-21-03, 02:37 PM	#13 (permalink)
exbox Aximsite Prospect Join Date: Nov 2003 Posts: 3 Thanked 0 Times in 0 Posts	Can someone tell me why this recordset won't open: Rs.Source = "SELECT InvoiceNo, CustCode, CusName FROM Invoices WHERE Void = 0 ORDER BY InvoiceNo ASC" Rs.CursorType = adOpenForwardOnly Rs.ActiveConnection = oConnection Rs.Open AND this one will: Rs.Source = "SELECT InvoiceNo, CustCode, CusName FROM Invoices ORDER BY InvoiceNo ASC" Rs.CursorType = adOpenForwardOnly Rs.ActiveConnection = oConnection Rs.Open The difference is the Where clause VOID = 0 Void is a Yes/No field.