Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Insert into a remote view doesn't work
Message
From
19/12/2003 16:26:29
 
 
To
19/12/2003 14:15:25
General information
Forum:
Visual FoxPro
Category:
Databases,Tables, Views, Indexing and SQL syntax
Miscellaneous
Thread ID:
00860702
Message ID:
00860848
Views:
29
>Yes, the view's fields are updatebable already. Actually, I've now discovered if I close VFP and reopen VFP, the insert shows in SQL. Why would that be?

Do you have a join in this view? If so, the second table is probably listed in the 'tables' property.

Do this...at the command line

USE YourView
? CursorGetProp('Tables')

My guess, more than one is listed. Choose the name of the one you are trying to update and then do:

CursorSetProp('Tables','Tabletoupdate')
USE

Now, see if it works better.

BOb
Previous
Next
Reply
Map
View

Click here to load this message in the networking platform