Create statement

[Candy Bortniker]

I am trying to create a table with several columns. I would like to not put all of the column names on one line because you would have to scroll over to see the full line. Can I do something like:
"CREATE TABLE Reimbursement (GroupAcctNumber VARCHAR(10),
SSN VARCHAR(9), name VARCHAR(20),
date VARCHAR(10), providerSSN(9),
providerName(20) amount float(7),
description VARCHAR(45))"

[Gregg Bolinger]

Are you trying to do this in JAVA Code? This is basically a String concantanation issue. When creating a String in JAVA and spreading it out over multiple lines a + operator must be used. So your statement would be more like:

String sql = "CREATE TABLE Reimbursement (GroupAcctNumber VARCHAR(10), " +
             "SSN VARCHAR(9), name VARCHAR(20), " +
             "date VARCHAR(10), providerSSN(9), " +
             "providerName(20) amount float(7), " +
             "description VARCHAR(45))";

[ October 18, 2003: Message edited by: Gregg Bolinger ]