General information
Category:
Databases,Tables, Views, Indexing and SQL syntax
Title:
View Returning no Records?
The following is a remote view of VFP data. I have a record of cCustNo = 'ABBA' and 'ABBB'. If I use 'AB' as my ?CustNoWanted field, I get no records returned. If I use 'ABBA' then I get the first one only. I want both. Set exact is off and set near is on and set ansi is off. Maybe it's the hour, but I need help....
Create SQL View CustBrowseCustNo ;
;
connection elS-Adm shared as;
select ;
cCustNo , ;
cCustType , ;
cNameLas , ;
cPhone1 , ;
.f. as lSel;
from ;
Customers ;
where ;
cCustNo = ?cCustNoWanted ;
order by ;
cCustno
Next
Reply
View the map of this thread
View the map of this thread starting from this message only
View all messages of this thread
View all messages of this thread starting from this message only