Plateforme Level Extreme
Abonnement
Profil corporatif
Produits & Services
Support
Légal
English
About SQL syntax and compiling (URGENT)
Message
 
À
Tous
Information générale
Forum:
Visual FoxPro
Catégorie:
Base de données, Tables, Vues, Index et syntaxe SQL
Titre:
About SQL syntax and compiling (URGENT)
Divers
Thread ID:
00466414
Message ID:
00466414
Vues:
42
Dear sirs,

I have two problem like this

1- for example I have 5-6 criteria on the form and all of criteria comes with combobox and combobox contains related records their dbf's (combo1=scholltype,combo2=city,combo3=sex etc...) when I want to select from combo1 for 'highscholl',from combo2 'texas', for combo3 ALL (both of two sexuality) how should I write the SQL syntax ( e.g "select * from mydata where mydata.scholltype=thisform.combo1.value;
and mydata.city=thisform.combo2.value;
and mydata.sex=thisform.combo3.value; && how ??? (value must be male+female)
into cursor myresult nofilter


2-when I compiled my myapp.exe and when I run it it comes half screen not full screen thats way I clicking for enlarge the program to see all how can setup my setup options

Thanks for the help from this time,

Kosta ANDONYADIS
Suivant
Répondre
Fil
Voir

Click here to load this message in the networking platform