Information générale
Catégorie:
Base de données, Tables, Vues, Index et syntaxe SQL
Titre:
Problem with Update - 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
Suivant
Répondre
Voir le fil de ce thread
Voir le fil de ce thread à partir de ce message seulement
Voir tous les messages de ce thread
Voir tous les messages de ce thread à partir de ce message seulement