Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Making a SQL Pass-through updatable.
Message
General information
Forum:
Visual FoxPro
Category:
Client/server
Miscellaneous
Thread ID:
00434375
Message ID:
00434380
Views:
16
? SQLEXEC(1, [SELECT Vdr_No, vdr_add3 FROM VNDR WHERE Vdr_No = 9141], [MyCur])

This opens a local cursor, not an updateable remote view.

? CURSORSETPROP('SendUpdates',.T. ,'mycur')

Contains true (.T.) if a SQL update query is sent to update tables when an update is made using the view <-----

? CURSORSETPROP('Tables', 'KPOPS.VNDR')
? CURSORSETPROP('UpdateNameList','vdr_add3', 'MyCur')
? CURSORSETPROP('KeyFieldList','vdr_no', 'MyCur')
? CURSORSETPROP('UpdatableFieldList', 'vdr_add3, vdr_add3', 'MyCur')

The rest of these, I believe, only apply to a view.
Eric Kleeman - EDS Consulting Services
MCP Visual FoxPro
MCSD C#.NET
Hua Hin Thailand
Los Angeles California
Previous
Next
Reply
Map
View

Click here to load this message in the networking platform