unknown statement drop table

[Anonymous]

Hi guys,

when i compile the script this error is occurred.

For each vTable in $(list1)

  inner JOIN ([NewData.Name]) LOAD * RESIDENT [$(vTable)];

  let o=pick(wildmatch(vTable,'*NewData.Name*'),'1');

  if o <> 1

  then

  Drop Table $(vTable);

  End If

Next vTable

I have this error :

Unknown Statement  : then Drop Table NewData.Surname.

notice :

NewData.Surname is the table which i want to drop.

stalwar1‌

swuehl‌

[antoniotiman · Accepted solution]

Try this

if o <> 1  then

Drop Table $(vTable);

End If;

[Anonymous]

Thanks.

it is working.