Plateforme Level Extreme
Abonnement
Profil corporatif
Produits & Services
Support
Légal
English
SELECT with 4 conditions
Message
De
23/09/2005 06:27:55
 
 
À
23/09/2005 01:40:07
Information générale
Forum:
Visual FoxPro
Catégorie:
Base de données, Tables, Vues, Index et syntaxe SQL
Versions des environnements
Visual FoxPro:
VFP 6 SP5
OS:
Windows 2000 SP4
Network:
Windows 2000 Pro
Database:
Visual FoxPro
Divers
Thread ID:
01052132
Message ID:
01052319
Vues:
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 )

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.
Précédent
Suivant
Répondre
Fil
Voir

Click here to load this message in the networking platform