Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Help about Where Clause
Message
General information
Forum:
Visual FoxPro
Category:
Databases,Tables, Views, Indexing and SQL syntax
Environment versions
Visual FoxPro:
VFP 9
OS:
Windows XP SP2
Network:
Windows XP
Database:
MS SQL Server
Miscellaneous
Thread ID:
01012198
Message ID:
01014328
Views:
19
Hi Sergey,

I have understand better my problem learning the manual of VFX, that is a good Framework but with a poor documentation.

This is the scenario:
1) My app use the Cursor Adapter for the remote Sql database;
2) In a Form I have some Fields, that are created with a PickList Class. The maintenance of this PickList is based on a Picklist Builder.
3) In this Builder I can enter a Select command in order to validate the txtField.
4) The manual suggest a select syntax, example like this:

select customer_id from r_customer where customer_id = trim(this.txtField.Value)


5) In my previous app I have used a DBC and the field is a normal textbox; In the Valid event I have enter a condition code, example like this:
DO CASE
CASE table1.Type == 'A' AND (ThisForm.chkbox1.Value OR ThisForm.chkbox2.IvaSospUn.Value) AND table2.Type != '2'
=messagebox (ECL_MSG1,0+16,_screen.caption)
RETURN .F.
CASE table1.Type $ '12' AND ThisForm.chkbox2.Value AND table2.Type != '2'
=messagebox (ECL_MSG2,0+16,_screen.caption)
RETURN .F.
ENDCASE


My answer is this:
"Supposing I have replaced table1 with cursor1 and table2 with cursor2, is possible to create a select that respect the clause at point 5)?"

I hope to have explained better my question.

Best Regards
Nino
Previous
Next
Reply
Map
View

Click here to load this message in the networking platform