Plateforme Level Extreme
Abonnement
Profil corporatif
Produits & Services
Support
Légal
English
Problem with filter string
Message
 
À
18/12/2006 09:07:30
Reza Meamar
Homa Programming Group
Shiraz, Iran
Information générale
Forum:
Visual FoxPro
Catégorie:
Codage, syntaxe et commandes
Versions des environnements
Visual FoxPro:
VFP 7 SP1
OS:
Windows XP SP1
Database:
Visual FoxPro
Divers
Thread ID:
01178534
Message ID:
01178629
Vues:
17
Did you try (note the alltrim and str functions added);
     Select Hesab01
     SET FILTER TO GCode = ALLTRIM(STR(thisform.y_GCode)) .AND. !EMPTY(KCode) .AND. EMPTY(MCode)
     thisform.list2.ControlSource = "Hesab01"
     thisform.list2.RowSource = "KName"
>Hi all
>I have a problem with filter command. when i use from below command in my form
>
>
>     Select Hesab01
>     SET FILTER TO GCode = thisform.y_GCode .AND. !EMPTY(KCode) .AND. EMPTY(MCode)
>     thisform.list2.ControlSource = "Hesab01"
>     thisform.list2.RowSource = "KName"
>
>
>i get not correct filtered records, but if i change it as below
>
>
>     Select Hesab01
>     filterStr = "SET FILTER TO GCode = " + ALLTRIM(STR(thisform.y_GCode)) + ;
>     " .AND. !EMPTY(KCode) .AND. EMPTY(MCode)"
>     &FilterStr
>
>     thisform.list2.ControlSource = "Hesab01"
>     thisform.list2.RowSource = "KName"
>
>
>my list2 filled with right records. i know it is because of GCode = thisform.y_GCode , but why it is wrong?
>thanks for your help
Précédent
Suivant
Répondre
Fil
Voir

Click here to load this message in the networking platform