What is wrong with this script?
dim ptable
set wshell = createobject("wscript.shell"
do
ptable= inputbox("Enter table to truncate","Truncate Database",vbokcancel)
if isempty(pversion) then
msgbox("Please enter valid table to truncate"
else
wscript.quit
end if
loop while isempty(ptable)
When I click cancel, it gave the "please enter ...." and when I click on Ok and the inpubox is empty, it ends without looping.
dim ptable
set wshell = createobject("wscript.shell"
do
ptable= inputbox("Enter table to truncate","Truncate Database",vbokcancel)
if isempty(pversion) then
msgbox("Please enter valid table to truncate"
else
wscript.quit
end if
loop while isempty(ptable)
When I click cancel, it gave the "please enter ...." and when I click on Ok and the inpubox is empty, it ends without looping.