--- Jan Johansen <[EMAIL PROTECTED]> wrote: > Group, > > There are times when I have a pretty good understanding of the property > command. There are others when I don't and this is one of them. > > Lets say I have a table called 'Employee' and a form called 'Employees'. > The form has 'DBEdit' fields. > The form has a button to 'Assign ID' to the employee. > > What is the proper syntax to fill in the DB field with the variable that is > assigned in the button eep.
You have two options: 1. Direct write to field (only works with DBEdit fields): PROPERTY DBEditComponentName TEXT .vIDVariable 2. Write to table and refresh (only works if you have a separate autnumbered primary key, and you are in EDIT and not ENTER mode): SAVEROW UPDATE Employee SET IDColumn = .vIDVariable WHERE KeyColumn = .vKeyValue PROPERTY TABLE Employee REFRESH I have a request in for a third option PROPERTY COLUMN VALUE .vIDVariable, which would work with any type of control without forcing a save of the row, but have not heard if it will be implemented or not. -- Larry
