Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
No update tables are specified error on local view
Message
General information
Forum:
Visual FoxPro
Category:
Databases,Tables, Views, Indexing and SQL syntax
Miscellaneous
Thread ID:
00190028
Message ID:
00190421
Views:
14
This was the error that I was having. I was pathing the free table.

What i did was to create an easy view in the view designer and look at in eview. Thats where I saw the problem.

Thanks for the EView!

__Stephen Russell

>Is the table part of the DBC? When you issue the DBGetProp('lv_cust','view','tables') the return value should be something like mydbname!arcust01 if the table is part of the DBC. If it is a free table, when I issue the DBGetProp, I only get the table name returned without the path. You may try issuing the DBSetProp without specifying the path to the table.
>
>I would also look at the code EVIEW generates to do any tweaking, delete the view from the DB, then run the code to start from scratch.
>
>>Thanks for the file name. It gaged on the table name missing from the update fields information. I gave it all to the dbc via a dbsetprop() and the eviews was now able to save the view information.
>>
>>Unfortuantaly VFP still gives the same error on the tableupdate() ?
>>
>>__Stephen Russell
>>
>>>>I cannot rely on the view designer for my local views. I code them and they are now getting this message:
>>>>
>>>>No update tables are specified. Use the Tables property of the cursor.
>>>>
>>>>I then issue a DBGETPROP('lv_cust','view','tables') and is states that "f:\pro30\ardata\arcust01" is the table to be used. This is the table I what to use.
>>>>
>>>>I get my settings from gendbc. I then change the .f. in update to .t. as well as define which field is the primary key.
>>>
>>>To help you set the key and updatable fields and generate the code, etc., you might try Erik Moore's EVIEW app found in the file section here.
Previous
Reply
Map
View

Click here to load this message in the networking platform