I know it adds code, but you will be better off storing the control values to variables and using the variables in the SQL.
>I seem to be having a problem with the update command. I've been using FoxPro for some time now and have never ran into this problem
>
>when I execute this statment
>
>update employeemain set firstname = thisform.firstname_txt.value;
>where employeeId = thisform.employeeId_txt.value
>
>I get the error alias firstname_txt not found.. When I save the value to a variable first and then use the variable to update it seems to work fine.. Another anomaly is the fact that the where clause works and needs no changing. I've used similar syntax in Insert statments useing "thisform.xxxxx.value" and had no problems. I can use the variable method, but it is rather messy and involves many extra lines of code 15 in my case. Any insight would be greatly appriciated
Mark McCasland
Midlothian, TX USA