OldtTimerDon
Programmer
Imagine a personnel file containing fields empno, fname, m_init, lnane, addr, st, city, zip, etc. A related file (Recognition.dbf) contains empno, award_code, license_code, and year achieved. The codes for licenses and awards are 3 characters and are translated in the Awards.dbf file
When the user seeks an employee, either by using find, next, or previous, my "Do ParseIt routine with empno" queries the Awards table for only that employee's data and expands the awards and license codes into an array. That array is then processed for conditions and based on those conditions accumulated to a variable myText which is then returned.
I have tested the ParseIt routine separately and it does exactly what is desired. My problem concerns where the "Do ParseIt routine with empno" should be on the employee form. As aa test, I added it to the click event of the Next button. This failed with the message "no update tables are specified. Use the table property of the cursor."
Note: My employee form has an editbox with a control source of "Thisform.myText" which is a property of the employee form.
I don't understand the error message but I am aware that error messages don't always relate to the problem. To restate the problem, as a user changes records, myText should show what awards and licenses have been achieved. (Some employees will have none.)
VFP is good brain cell medication!
Don Lawrence
Sun City, AZ, USA
When the user seeks an employee, either by using find, next, or previous, my "Do ParseIt routine with empno" queries the Awards table for only that employee's data and expands the awards and license codes into an array. That array is then processed for conditions and based on those conditions accumulated to a variable myText which is then returned.
I have tested the ParseIt routine separately and it does exactly what is desired. My problem concerns where the "Do ParseIt routine with empno" should be on the employee form. As aa test, I added it to the click event of the Next button. This failed with the message "no update tables are specified. Use the table property of the cursor."
Note: My employee form has an editbox with a control source of "Thisform.myText" which is a property of the employee form.
I don't understand the error message but I am aware that error messages don't always relate to the problem. To restate the problem, as a user changes records, myText should show what awards and licenses have been achieved. (Some employees will have none.)
VFP is good brain cell medication!
Don Lawrence
Sun City, AZ, USA