>Help!
>ControlSource of my text fields in my form class is set to fields in my updatable cursor (.ControlSouce='cMyTable.myFieldName'). Whenever I make changes to a text field, & clicked on a command button that issues a TABLEUPDATE(0,.T.), it updates the original table with the new value for the related field, but it does so for all the records in the table (which I do not want) instead of the current record only (which is what I'd like it to do).
>
>I had it working properly at 1 time, but I had made changes since, including creating another updatable cursor (in myForm.LOAD). Can anybody give me a clue where the problem might be?
>
>myForm.Load()
>lcConnStr="DRIVER={Microsoft Visual FoxPro Driver};" + ;
>"SourceDB=c:\projects\myData.dbc;SourceType=DBC;UID=;PWD=;"
>
>lnHandle=SQLSTRINGCONNECT(lcConnStr)
>
>IF lnHandle>0
>lSuccessMyTable=SQLEXEC(lnHandle,"SELECT * FROM myTable","cMyTable")
>IF lSuccessMyTable=1
>SET MULTILOCKS ON
> CURSORSETPROP('Buffering',5,'cMyTable')
> CURSORSETPROP('TABLES','myTable','cMyTable')
> CURSORSETPROP('UPDATABLEFIELDLIST','refno,budgetcode','cMyTable')


Try buf=3
> CURSORSETPROP('KeyFieldList','refno','cMyTable')
> CURSORSETPROP('UpdateNameList','refno myTable.RefNo,budgetcode myTable.budgetcode','cMyTable')
> CURSORSETPROP('FetchMemo',.T.,'cMyTable')
> CURSORSETPROP('SendUpdates',.T.,'cMyTable')
>ENDIF
>ENDIF
>
>cmdSave.CLICK()
>TABLEUPDATE(0,.T.)
>
>**Let's say I changed budgetcode to 15 on record with refno=13.
>**The TABLEUPDATE changes all budgetcode to 15 for all records, not just for refno=13. The above code seems to be working just by itself; there must be a mistake I made somewhere else, but I'm clueless. Can anybody give me a clue?
>
>Thank you all!