Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
View updates
Message
General information
Forum:
Visual FoxPro
Category:
Coding, syntax & commands
Title:
Miscellaneous
Thread ID:
00169084
Message ID:
00169285
Views:
16
Mark,

The view isn't based on a view, is it? If so you need to TABLEUPDATE() the view it's based on after you update vTest.

>Here's my original code...
>
>lcStatus = "Customer"
>SELECT vTest
>INSERT INTO vTest (firstname,lastname,status) ;
>VALUES ("Joe","Smith","Customer")
>= TABLEUPDATE()
>= REQUERY('vTest')
>BROWSE
>
>Yes, the where clause has test.status = ?lcStatus, which you can see I set to "Customer" and the values of the INSERT INTO is also "Customer".
Previous
Next
Reply
Map
View

Click here to load this message in the networking platform