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