Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
CA connecting to table with space in name
Message
General information
Forum:
Visual FoxPro
Category:
Coding, syntax & commands
Environment versions
Visual FoxPro:
VFP 9 SP2
OS:
Windows 7
Miscellaneous
Thread ID:
01485210
Message ID:
01485220
Views:
37
>I am connecting to a SQL server table with a space in the table name (say, [my table]) via a CursorAdapter. How should I write the UpdateNameList property of the CursorAdapter.
>
>I tried quoting the table name with a pair of square brackets like "id [my table].id, num [may table].num". However the CursorAdapter failed to update the master table with the changes in the cursor.
>
>Any idea?

I think here you should use the name of the cursor, not the table. Did you try that? Also, perhaps it's not too late to rename this table and remove the space?

Read this blog post
Do not use spaces or other invalid characters in your column names
If it's not broken, fix it until it is.


My Blog
Previous
Next
Reply
Map
View

Click here to load this message in the networking platform