After running the following query in Visual Basic program
and opening the recordset I am getting an "Error in row"
message. I am sure it's the "credt_mem" variable that is
causing the error. Does any one know how to fraise the
query for the boolean expressions?
I have also tried:
credt_mem = "YES" instead of boolean expression, the same...
==========================================================
cmpny = "ALPC" 'company in Vantage
inv_Date = Format(Date, "mm/dd/yyyy") 'today's date
Dim credt_mem As Boolean 'declare a boolean
credt_mem = False 'credit memo true
"SELECT " & _
"InvcHead.InvoiceNum, InvcHead.PONum " & _
"FROM pub.InvcHead " & _
"WHERE InvcHead.Company = '" & cmpny & "'" & _
" AND InvcHead.InvoiceDate >= '" & inv_Date & "'" & _
" AND InvcHead.CreditMemo = '" & credt_mem & "'" & _
"ORDER BY InvcHead.InvoiceNum"
Mike Tonoyan / MIS Manager
All American Products Co.
1135 Aviation Place
San Fernando, CA 91340-1460
U. S. A.
Tel.: 818-361-0059, Ext,: 246
Fax: 818-898-2236
E-mail: miket@...
Web: www.allamericanproducts.com
and opening the recordset I am getting an "Error in row"
message. I am sure it's the "credt_mem" variable that is
causing the error. Does any one know how to fraise the
query for the boolean expressions?
I have also tried:
credt_mem = "YES" instead of boolean expression, the same...
==========================================================
cmpny = "ALPC" 'company in Vantage
inv_Date = Format(Date, "mm/dd/yyyy") 'today's date
Dim credt_mem As Boolean 'declare a boolean
credt_mem = False 'credit memo true
"SELECT " & _
"InvcHead.InvoiceNum, InvcHead.PONum " & _
"FROM pub.InvcHead " & _
"WHERE InvcHead.Company = '" & cmpny & "'" & _
" AND InvcHead.InvoiceDate >= '" & inv_Date & "'" & _
" AND InvcHead.CreditMemo = '" & credt_mem & "'" & _
"ORDER BY InvcHead.InvoiceNum"
Mike Tonoyan / MIS Manager
All American Products Co.
1135 Aviation Place
San Fernando, CA 91340-1460
U. S. A.
Tel.: 818-361-0059, Ext,: 246
Fax: 818-898-2236
E-mail: miket@...
Web: www.allamericanproducts.com