Win a copy of Design for the Mind this week in the Design forum!
  • Post Reply
  • Bookmark Topic Watch Topic
  • New Topic

Create statement

 
Candy Bortniker
Ranch Hand
Posts: 123
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
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
GenRocket Founder
Ranch Hand
Posts: 15302
6
Chrome IntelliJ IDE Mac OS X
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
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:

[ October 18, 2003: Message edited by: Gregg Bolinger ]
 
  • Post Reply
  • Bookmark Topic Watch Topic
  • New Topic