I am an experienced VFP programmer trying to use SQL Server for the first
time

My SQL Server database is called CFCS_BOI
It has one table called CANDIDATES
I connect to the database ok and get all the records into a foxpro cursor
which I can browse

But when I change any data in the browsed cursor I get an error message
saying "No update tables are specified. Use the Tables property of the
cursor" and I have to press the "Revert" button..

I am about to tear my hair out! The following is some code which I have set
up in accordance with my understanding.

I am trying to use SQL Pass Through rather than remote views.

Please help.

If sombody has sample code then please email to joe.kelly@ksm.ie


PROGRAM CODE:


m_sqlcmd = "select * from candidates"

m_rcode = SQLEXEC(m_datahndl, m_sqlcmd, "Lcandidates")

sele LCANDIDATES
=cursorsetprop("Tables","candidates","Lcandidates")
=cursorsetprop("KeyFieldList","StaffNumber","Lcandidates")
=cursorsetprop("UpdateNameList","Notes","Lcandidates")
=cursorsetprop("UpdatableFieldList","Notes","Lcandidates")
=cursorsetprop("SendUpdates",.t.,"Lcandidates")
go top
brow



TIA

Joe Kelly

joe.kelly@ksm.ie