Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Cursor Adapter SELECTCMD
Message
From
31/03/2006 14:05:25
 
 
To
31/03/2006 11:03:38
Mike Yearwood
Toronto, Ontario, Canada
General information
Forum:
Visual FoxPro
Category:
Databases,Tables, Views, Indexing and SQL syntax
Environment versions
Visual FoxPro:
VFP 9 SP1
OS:
Windows XP SP2
Network:
Windows 2000 Server
Database:
MS SQL Server
Miscellaneous
Thread ID:
01109509
Message ID:
01109618
Views:
28
Yes, CursorFill(.t.,.t.) would work and so would this, however I don't have access to the cursor adapter directly. I will be using REQUERY() on the resulting cursor since my cursor adapters will be placed in a data environment. So, I really can't do "CURSORFILL(.t.,.t.)" or change the SELECTCMD. I will have to come up with something. If I my view parameter to .null. and then requery the table

What I don't understand is that in the Query Analyzer I can do both "select * from members where members_pk = null" or "select * from members where members_pk is null". Both return the correct results.

I am going to try stright ADO, with out using a cursor adapter to see if this still happens.

If you can think of anything that might help me here, it would be greatly appreciated.

Thanks
Previous
Reply
Map
View

Click here to load this message in the networking platform