>>Hi ALL,
>>
>>I need to read / write to an ACCESS database.
>>
>>I run into follwing:
>>
>>A column is named, as reported by SQLCOLUMNS(...,'Native'),
Field "C".
>>
>>How do I adress this in a CA?
>>SELCTCMD is like 'SELECT Table.[Field "C"] FROM Table'
>>I get SQL error 1526
>>Error in expression
Table.[Field [C]]>
>Use back quotes `:
>
>SQLEXEC(m.lnODBC,'SELECT Cur1.`Field "C"` AS FieldC FROM myTable AS Cur1')
>
>This is the standard approach for Microsoft ODBC drivers when dealing with column names that contain characters others than simple letters, numbers and underscores.
That solves it.
muito obrigado
Words are given to man to enable him to conceal his true feelings.
Charles Maurice de Talleyrand-Périgord
Weeks of programming can save you hours of planning.
OffThere is no place like [::1]