Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
SELECT with 4 conditions
Message
From
23/09/2005 06:27:55
 
 
To
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:
01052319
Views:
6
>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 )

Have you tried binding the value of the combo to a form property?
Then, in the interactive change of the combo:
This.value  = this.List( This.ListIndex)
Thisform.cn = This.value
And use thiform.cn in your select. Thus, as you change the combo selection, you've always got an up-to-date value for the SQL.

HTH

Terry
- Whoever said that women are the weaker sex never tried to wrest the bedclothes off one in the middle of the night
- Worry is the interest you pay, in advance, for a loan that you may never need to take out.
Previous
Next
Reply
Map
View

Click here to load this message in the networking platform