Hiya Yogi,
>Just wondering if VFP 6.0 has made any updates to its database and SQL support. Does it support APPEND and UPDATE Queries and I don't mean the one dimensional support that 5.0 had.
>
Nope. No changes there.
>Also, VFP 5.0 does not support the use of Replication ID that Access and SQL databases use. When I try to create a remote view, the replication ID data comes across as memo data. As a result I can't update data since the replication ID is used as a primary key.
>
Wait a second...why can't you update data? Isn't the ID generated on the server side? If so, ignore it on the VFP side.
------------------------------------------------
John Koziol, ex-MVP, ex-MS, ex-FoxTeam. Just call me "X"
"When the going gets weird, the weird turn pro" - Hunter Thompson (Gonzo) RIP 2/19/05