Plateforme Level Extreme
Abonnement
Profil corporatif
Produits & Services
Support
Légal
English
SQL Tableupdate with remote view not working
Message
Information générale
Forum:
Visual FoxPro
Catégorie:
Client/serveur
Divers
Thread ID:
00592857
Message ID:
00592900
Vues:
18
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
Précédent
Suivant
Répondre
Fil
Voir

Click here to load this message in the networking platform