Plateforme Level Extreme
Abonnement
Profil corporatif
Produits & Services
Support
Légal
English
Problem with filter string
Message
De
18/12/2006 12:56:42
Reza Meamar
Homa Programming Group
Shiraz, Iran
 
 
À
18/12/2006 09:14:37
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:
01178621
Vues:
16
>>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
>
>If thisform.y_gcode is not fixed then you may really get unpredictable results.
>Btw, are you sure that you don't confuse Controlsource and Rowsource in your code. Also, using SET FILTER is a bad practice; if possible, it should be avoided.

I dont know what this is mean "thisform.y_gcode is not fixed ".
I make a property in EDIT PROPERTY/METHOD and set its initial value to 0.
Hesab01 is my DBF and KName is one of its field. i think it is correct.
what is your suggestion for SET FILTER ?
Thanks for your reply
Précédent
Suivant
Répondre
Fil
Voir

Click here to load this message in the networking platform