Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Using LSQLPT Cursors
Message
From
15/02/2006 16:30:32
 
 
To
15/02/2006 16:00:50
General information
Forum:
Visual FoxPro
Category:
CodeMine
Miscellaneous
Thread ID:
01096583
Message ID:
01096589
Views:
14
>Has anyone made use of this .ctype cursor?

LSQLPT is the type.

>I notice that the builder doesn't ask for an .csource property, but it still needs one.

That is your local SQL query.

>Also, I'm having dificulty getting the .cWhere and Requery to work.

Just specify your normal WHERE filter of the SQL select statement but don't specify the WHERE clause itself. So, if you want to say :-
SELECT * FROM Employees WHERE nEmpId = ?pnEmpId

cSource = "SELECT * FROM Employees"
cWhere = "nEmpId = ?pnEmpId"
Just type the values I have specified above (replace with your own) in the cSource and cWhere boxes in the builder or in the property sheet. Obviously, if you type them in the builder/property sheet, you don't need the quotation marks.

HTH
-=Gary
Previous
Next
Reply
Map
View

Click here to load this message in the networking platform