Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Remote view Access2003 table Resrvd Wrd used field name
Message
General information
Forum:
Visual FoxPro
Category:
Databases,Tables, Views, Indexing and SQL syntax
Environment versions
Visual FoxPro:
VFP 8 SP1
OS:
Windows XP SP2
Network:
Windows NT
Database:
Jet/Access Engine
Miscellaneous
Thread ID:
01055294
Message ID:
01055305
Views:
9
This message has been marked as the solution to the initial question of the thread.
Hi Harwey

You can use [] for encapsulating field name:

SELECT [table_name].[Field_Name] ...

Note: If your any object have name with characters ch (c and h), your applications can have problems on OS CS/SK, because these two characters are one character.

MartinJ

>Hi All,
>
>I have bled for about 3 hours today on this one. I have a remote view into an Access2003 Database. The table that I am accessing has 2 fields that are reserved key words in VFP. The fields are id and number. I cannot rename the fields in Access because another program is accessing the table.
>
>I can view the records in the Remote view but I can't update them because of the field name issue.
>
>Is there a work-around to update the table through the remote view?
>
>Thank you,
"Navision is evil that needs to be erazed... to the ground"

Jabber: gorila@dione.zcu.cz
Jabber? Jabbim
Previous
Next
Reply
Map
View

Click here to load this message in the networking platform