Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
SELECT with 4 conditions
Message
From
23/09/2005 01:40:07
 
General information
Forum:
Visual FoxPro
Category:
Databases,Tables, Views, Indexing and SQL syntax
Environment versions
Visual FoxPro:
VFP 6 SP5
OS:
Windows 2000 SP4
Network:
Windows 2000 Pro
Database:
Visual FoxPro
Miscellaneous
Thread ID:
01052132
Message ID:
01052291
Views:
7
Yes, reuery() for listbox is after SELECT.
( SELECTs ... are in DO CASE loop - and look like this:


case thisform.C1.value==.T. .and. thisform.C2.value==.T. .and.thisform.C3.value == .F. .and. thisform.C4.value== .T.
*
SELECT NAZIV from OBJEKT WHERE alltrim(POGON) == thisform._C1 .and. ;
TIP == thisform._C2 .and. ;
GRUPA == thisform._C4 ;
order by NAZIV into ARRAY THISFORM.IZABERI

( thisfrom._Cn keeps last value from combobox )
Previous
Next
Reply
Map
View

Click here to load this message in the networking platform