Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
 
					
				
		
Hi, i am using without success this simple macro in QV 9 to update database:
sub cmdUpdate
SET Result = ActiveDocument.DynamicUpdateCommand ("UPDATE Table SET EQUIP_MODEL_REF = 0 Where LOCATION_DEF = 30001283")
if Result = false then
MsgBox Result.ErrorMessage
end if
end sub
When use the macro it directly opens the module editor but doesn't show error message
Does anyone know what i have to do?
Thanks!
 
					
				
		
In Document your settings, on the Server tab, make sure the Enable Dynamic Data Update is ticked.
Hope this help.
Andrew
 
					
				
		
Ok, I didn't know it only works in Server edition.
Thanks
