>I am guessing that it is throwing up on the
>You may want to read this for details of the syntax
>HOWTO: Add a FoxPro Database to SQL Server as a Linked
>PSS ID Number: Q199131
>Article Last Modified on 07-27-2001
>Allan Mitchell (Microsoft SQL Server MVP)
>I support PASS - the definitive, global community
>for SQL Server professionals - http://www.sqlpass.org
>> I have linked a server to a visual foxpro datasource.
>> having problems updating visual foxpro tables, I get
>> message "command contains unrecognized phras/keyword".
>> This is my sql string
>> update nis_data.[\\oracleserver\nis\nis]..salon
>> SET priority = 'B'
>> WHERE (priority LIKE '%A%')
>> what am I doing wrong?
I read the article and I have already done everything in
the article. When I use update Openquery
(nis_data, 'select * from salon')set priority="B" where
priority="A", it works. But I tried to use this same
statement in a ddq for my update statement like
this...update Openquery(nis_data, 'select * from salon')
set priority="B" where salonid =? it does not work. Can
you not use parameters with this?
Thanks a lot Allan, I've noticed that your support
contributes a great deal to this site!