Execute SQL statement in Visual Data Manager

[smcmanus]

Trying to execute the following SQL statement in Visual Data Manager, but keeps comming up with error "Missing semicolon ( at end of SQL statement. Number 3137." Please note there are 2 INSERT statements. It works fine with one INSERT statement but with 2 INSERT statements comes up with the error. Syntax??

INSERT INTO tblBoltonLabels (fldserialnumber,fldframecode,fldgmpartnumber,fldcaster_camber,fldewo,fldqalevel,fldoptionword,fldlocation) VALUES ('40371906','74L','15753452','092112087086','MG887','R','1','B5') INSERT INTO tblBoltonLabels (fldserialnumber,fldframecode,fldgmpartnumber,fldcaster_camber,fldewo,fldqalevel,fldoptionword,fldlocation) VALUES ('40371906','74L','15753452','092112087086','MG887','R','1','B5')

 

[Guest_imported]

In ANSI standard sql you need a ; at the end of each statement. The error message means exactly what it says you need to ...

insert into atable values(a,b,c,d);
insert into btable values(a,b,c, ....)