Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
About SQL syntax and compiling (URGENT)
Message
 
 
To
All
General information
Forum:
Visual FoxPro
Category:
Databases,Tables, Views, Indexing and SQL syntax
Title:
About SQL syntax and compiling (URGENT)
Miscellaneous
Thread ID:
00466414
Message ID:
00466414
Views:
43
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
Next
Reply
Map
View

Click here to load this message in the networking platform