Message
From
29/09/2006 11:45:56
To
Todo
General information
Fórum:
Visual FoxPro
Category:
Programação, sintaxe e comandos
Título:
Query an SQL Server Table Problem
Environment versions
Visual FoxPro:
VFP 9 SP1
OS:
Windows XP
Database:
MS SQL Server
Miscellaneous
ID da thread:
01158161
ID da mensagem:
01158161
Views:
73
I am trying to query a sql server table using the following:
sqlexec(lnconnection,"Select * from invoices where invoices.ccustnum Like ?p_custnumparameter and invoices.ddatetimefield Like ?p_datetimeparameter","v_myresult")
if I enter a date it returns the proper results, if I enter % (wildcard) I get no results
I need to get all records for a customer regardless of date not only records for a specific date
sqlexec(lnconnection,"Select * from invoices where invoices.ccustnum Like ?p_custnumparameter and invoices.ddatetimefield Like ?p_datetimeparameter","v_myresult")
if I enter a date it returns the proper results, if I enter % (wildcard) I get no results
I need to get all records for a customer regardless of date not only records for a specific date
For God so loved the world that he gave his one and only Son, that whoever believes in him shall not perish but have eternal life. John 3:16