Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
CursorAdapter and WHERE
Message
From
21/02/2008 12:11:57
 
 
To
21/02/2008 11:58:41
General information
Forum:
Visual FoxPro
Category:
Classes - VCX
Miscellaneous
Thread ID:
01294821
Message ID:
01294827
Views:
31
>Hi All --
>
>I have attempted to use a SQL statement such as:
>
>
>SELECT * FROM tab_sample_log_product WHERE slp_project_id = '931' AND slp_product_id = 'A0140AA'
>
>
>A call to lo_slp.CursorFill() with this SQL command in the SelectCmd property fails to filter the result set based on the WHERE clause. I have taken to doing a CursorDetach and then issuing the command through SQLEXEC() and then doing a CursorAttach to put it back.
>
>Any clues on what I am doing wrong? I think there ought to be a way to have WHERE clause filtering on the CursorAdapter and I am just not seeing it. I have looked through the help documentation extensively for clues, but have found none.
>
>Thanks,
>Larry Rix
>Applications Developer
>AQS
>Atlanta, GA

No way.
What lo_slp.CursorFill() returns?
What is the Database you use as BackEnd?
What is your connection, ODBC Native or ADO?
Against Stupidity the Gods themselves Contend in Vain - Johann Christoph Friedrich von Schiller
The only thing normal about database guys is their tables.
Previous
Next
Reply
Map
View

Click here to load this message in the networking platform