Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
SQL Views
Message
From
02/07/2003 14:37:19
 
 
General information
Forum:
Visual FoxPro
Category:
Databases,Tables, Views, Indexing and SQL syntax
Title:
Miscellaneous
Thread ID:
00805855
Message ID:
00806248
Views:
23
>Hi Bill,

>> Specifically we are getting a message "No update tables are specified. Use the Tables property of the cursor (Error 1491)"

To make a cursor updatagble you only need the following properties to be set:
CURSORSETPROP( "TABLES", "dbo.UM", "um" )
CURSORSETPROP( "KEYFIELDLIST", "???", "um" )
CURSORSETPROP( "UPDATABLEFIELDLIST", "um, desc, nodecimals", "um" )
CURSORSETPROP( "UPDATENAMELIST", "um dbo.um.um,...", "um" )
CURSORSETPROP( "SENDUPDATES", .T., "um" )
>Do you have any thoughts on the cursorsetprop values? Should we be looking at using cursor adapters?

CursorAdapters are basically wrappers around remote views - they use the same basic technology and internals so they are prone to many of the same issues - though they are more flexible, and certainly more easily modifiable.

However, I prefer to use data-driven cursors - [plugbook='on'] as outlined in Chapter 13 of "MegaFox: 1002 You Wanted to Know About Extending VFP" [plugbook = 'off']
----
Regards
Andy Kramek
Previous
Reply
Map
View

Click here to load this message in the networking platform