Information générale
Catégorie:
Codage, syntaxe et commandes
Titre:
REPLACE command does not REPLACE....
Why did this code not work when trying to use the REPLACE command to replace a field in a different alias than the current alias?
SELECT SomeTableOtherThanMachineSched
*-- Some misc code here
REPALCE MachineSched.status with 'C' <------ (An updateable view)
llUpdate=TABLEUPDATE(1,.t.,'MachineSched')&& update local view
IF llupdate=.f.
MESSAGEBOX('Error updating changes to data table in cmdCheck.click()', 0, 'Error')
ENDIF
*-- Requery local view
cMachNo=thisform.mach_num && Required var for local view
REQUERY('MachineSched') && to refresh data set
Problem:
The REPLACE with 'C' would not 'stick' until I specifically SELECTED the correct view alias first.
This code did work:
SELECT SomeTableOtherThanMachineSched
*-- Some misc code here
SELECT MachineSched
REPLACE status with 'C' <------ (An updateable view)
llUpdate=TABLEUPDATE(1,.t.,'MachineSched')&& update local view
IF llupdate=.f.
MESSAGEBOX('Error updating changes to data table in cmdCheck.click()', 0, 'Error')
ENDIF
*-- Requery local view
cMachNo=thisform.mach_num && Required var for local view
REQUERY('MachineSched') && to refresh data set
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