community.borland.com

Article #25168: Insert string parses without error but does not insert values.

Problem:
Insert string parses without error but does not insert values 
due to incorrect syntax.


	

 		Statement failed, SQLCODE = -104

		Dynamic SQL Error
		-SQL error code = -104
		-Token unknown - line 1, char 29
		-select

Solution:
Example:

	Metadata used:

	CREATE DATABASE test.gdb;

	CREATE TABLE t1 (
		f1 varchar(10),
		f2 varchar(10));

	CREATE TABLE t2 (
		f1 varchar(10),
		f2 varchar(10));

	Populate TABLE t1:

	INSERT INTO t1(f1,f2) VALUES ("test", "data");

	Offending: (INSERT/SELECT Syntax:)

	INSERT INTO t2(f1,f1) VALUES SELECT f1,f2 FROM t1;

	
	Correct: (INSERT/SELECT Syntax:)

	INSERT INTO t2 SELECT f1,f2 FROM t1;

			(or)

	INSERT INTO t2(f1,f2) SELECT f1,f2 FROM t1

			(or)

	INSERT INTO t2 SELECT * FROM t1

			(or)

	INSERT INTO t2 SELECT f1,f2 FROM t1 WHERE
		f1 = "blah";

			(or)

Last Modified: 29-SEP-00