Mike,
I meant:
SQLEXEC(lnHandle, "UPDATE QS36F.GMBIAP6 SET GMBIAP6.WSBTC = 'Y';
WHERE GMBIAP6.WDC=' ' AND GMBIAP6.WSBTC = ' '")
& I still receive the token error with it. I was desperately trying everything to get past the error. I tried reversing single & double quotes, changing AND to &. I tried replacing QS36F.GMBIAP6 with QS36F!GMBIAP6.
We are using Client Access V3R1M2. I guess I'm going to have to get that book, because I can't find anything in help to get around this error. I've searched a few web sites hoping to find a solution, but have failed.
So the above command should work? I don't understand why I can retrieve the records through the connection, but not update them.
Thanks again for your help! If you have other recommendations, please send them my way! :)
Précédent
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