Multiple line table creation

I’m creating a table with multiple lines and having a problem with the last line: getting “syntax error”. The following is shortened but is six lines and 47 varchar in size.

GFYDB.SQLExecute “create table PGYF(ID integr NOT NULL PRIMARY KEY, txtA varchar, txtB varchar,” +_
“txtZ varchar, txt01 varchar”)

Is there an error in the +_ that is causing a problem in second line. I don’t seem to be able to find this in the manual. Does anyone see the problem? Thank you.

You need to remove the closing bracket at the end, or add an open bracket directly after GFYDB.SQLExecute…

GFYDB.SQLExecute "create table PGYF(ID integr NOT NULL PRIMARY KEY, txtA varchar, txtB varchar," +_ "txtZ varchar, txt01 varchar"

Isnt integr spelled integer ?

GFYDB.SQLExecute "create table PGYF(ID integr NOT NULL PRIMARY KEY, txtA varchar, txtB varchar, " _
+ "txtZ varchar, txt01 varchar)"

Just a “space” between " and _ and a + on line two :slight_smile:

Thank you.

JAMES:

in the Data Base cases, I CAPITALIZE all Data Base related commands (INTEGER, VARCHAR, etc.) to be sure I do make errors.

Helas, I still continue to do errors, but this helps me ;-:).