Plateforme Level Extreme
Abonnement
Profil corporatif
Produits & Services
Support
Légal
English
How to use SQL in Grid ?
Message
De
06/10/1998 23:30:32
 
 
À
06/10/1998 05:57:41
Cetin Basoz
Engineerica Inc.
Izmir, Turquie
Information générale
Forum:
Visual FoxPro
Catégorie:
Gestionnaire d'écran & Écrans
Divers
Thread ID:
00143788
Message ID:
00144445
Vues:
22
>>>Suppose you have 3 textboxes (you have one) as txt1, txt2, txt3 referring to fields fld1, fld2, fld3 in your SQL :
Grid.init
>>>with this
>>>  .recordsourcetype = 4 && SQL
>>>  .recordsource = "select * from mytable "+;
>>>     "where fld1 = trim(thisform.txt1.value) " +;
>>>     "and fld2 = trim(thisform.txt2.value) " +;
>>>     "and fld3 = trim(thisform.txt3.value) " +;
>>>     "into cursor grdCursor"
>>>endwith
>>>
>>>* Lostfocus of textboxes
>>>thisform.mygrid.refresh
Cetin
>>
>>
Thanks again for your suggestion. I have tired your code but nothing happen in my Grid. I don't know why ? When I run form, my grid was empty. And after I put condition in txt1.value, my grid also empty. Any more suggestion. Thanks
From Nophua.
Précédent
Suivant
Répondre
Fil
Voir

Click here to load this message in the networking platform