Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
SQL Tableupdate with remote view not working
Message
General information
Forum:
Visual FoxPro
Category:
Client/server
Miscellaneous
Thread ID:
00592857
Message ID:
00592900
Views:
19
It says "No update tables are specified. Use the Tables property of the cursor." But as I'm sure you've noticed by the code below, I do have
>>>>=CURSORSETPROP('Tables','fromts2')
in there.

Eeps.

JR

>>SQL 2000, VFP6:
>>
>>Distilled, the code is:
>>
>>SET MULTILOCKS ON
>>use mycontainer!fromts2
>>=CURSORSETPROP('Buffering',5,'fromts2')
>>=CURSORSETPROP('Tables','fromts2')
>>append blank
>>replace myNumField with 1
>>replace myCharField with "Text"
>>?TABLEUPDATE(.T.)
>>
>>The TABLEUPDATE returns a false.
>>
>>The view has a primary key (ID), and all the fields are updatable. the SQL WHERE clause includes Key and modified fields, and the "Update using" box is set to SQL UPDATE.
>>
>>Why isn't it updating the SQL file?
>>
>>TIA,
>>Joy
>>
>>PS--I'm on-site today. Any quick help would be greatly appreciated!
>
>Joy,
>Make a call to AError() to see what the reason was. It could be as simple as a key word being used in a field name or it could be much more complex than that (e.g. trigger failure).
CLARC Services, Inc.
3500 Tamiami Trail
Port Charlotte, FL 33952
www.clarc.com
(941) 743-0108
(800) 246-5488
Previous
Next
Reply
Map
View

Click here to load this message in the networking platform