Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Special char in field name
Message
 
 
To
All
General information
Forum:
Visual FoxPro
Category:
Databases,Tables, Views, Indexing and SQL syntax
Title:
Special char in field name
Environment versions
Visual FoxPro:
VFP 9
OS:
Windows Server 2008
Network:
Windows 2008 Server
Application:
Desktop
Miscellaneous
Thread ID:
01552504
Message ID:
01552504
Views:
65
I'm using remote view to access filemaker table using connection string.

One of the field of the table is called "Téléphone", with french accentuated character

So far I've tried :
1) REPLACE Téléphone with '514777999'   in c_Cursor  
    = IF TABLEUPDATE(.T.,.T.,c_cursor,laError)  && Fails

2) SELECT c_Cursor
    SCATTER NAME oTest MEMO
    oTest.téléphone = '514777999' 
    GATHER NAME oTest
    = IF TABLEUPDATE(.T.,.T.,c_cursor,laError)  && Fails


3) lcSQL =[UPDATE TableName SET [Téléphone] = '514777999'  WHERE code_client = '123']
     =  SQLExec(nHandle,lcSQL,[Tablename],aCountInfo) > 0   && Fails
Any suggestion is welcome....
Luc Nadeau
lnadeau@neova.ca

"the theory, it is when all is known and that nothing works. The practice, it is when all works and that nobody knows why." - Albert Einstein (Nobel of physique 1921)
Next
Reply
Map
View

Click here to load this message in the networking platform