edlcl/jet-tool

Automatically exported from code.google.com/p/jet-tool

jet-tool's Issues

Mid-string semi-colons are still treated as command terminators

What steps will reproduce the problem?
1. Save the following text as a file names "semicolon.sql" in the current 
directory:

CREATE TABLE blah ( [blah] TEXT(255) NOT NULL );
INSERT INTO blah VALUES ('blah semicolon;!!');

2. Execute the following command:

Jet.exe exec -new -force -f .\blah.mdb < .\semicolontest.sql

3. Observe the following output:

Error while executing:
INSERT INTO blah VALUES ('blah semicolon
EOleException: Syntax error in string in query expression ''blah 
semicolon'(0x80040E14)

4. Open blah.mdb and observe a table was created but is empty.

What is the expected output? What do you see instead?

I expected that a row with the text "blah semicolon;!!" would appear in the 
blah table, but the table is empty.

What version of the product are you using? On what operating system?

Not quite sure of the version number, but I definitely downloaded it since the 
last change.

Original issue reported on code.google.com by [email protected] on 28 Jul 2014 at 9:04