Win a copy of Building Blockchain Apps this week in the Cloud/Virtualization forum!
  • Post Reply Bookmark Topic Watch Topic
  • New Topic
programming forums Java Mobile Certification Databases Caching Books Engineering Micro Controllers OS Languages Paradigms IDEs Build Tools Frameworks Application Servers Open Source This Site Careers Other all forums
this forum made possible by our volunteer staff, including ...
Marshals:
  • Campbell Ritchie
  • Paul Clapham
  • Liutauras Vilda
  • Knute Snortum
  • Bear Bibeault
Sheriffs:
  • Devaka Cooray
  • Jeanne Boyarsky
  • Junilu Lacar
Saloon Keepers:
  • Ron McLeod
  • Stephan van Hulst
  • Tim Moores
  • Carey Brown
  • salvin francis
Bartenders:
  • Tim Holloway
  • Piet Souris
  • Frits Walraven

Help on simple SQL required!!

 
Greenhorn
Posts: 16
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
I am trying to create a new table in my database using the CREATE of SQL however i am having a problem.
If I choose to INSERT i do:
SQLINSERT = " INSERT INTO UserDefined (Titled, Definition)
VALUES("
SQLINSERT = SQLINSERT & " '" & title & "' , "
SQLINSERT = SQLINSERT & " '" & it & "' )"

set conn = server.createobject("ADODB.Connection")
conn.open "UML"
set add=conn.execute(SQLINSERT)
conn.close
How do I construct the CREATE??
This is what I want to do:
CREATE TABLE UserTable (item char(30))
Which creates a new table in my database with 1 field heading of "item". Is the above line done correctly???
Also what goes after it? like in INSERT i do:
set conn = server.createobject("ADODB.Connection")
conn.open "UML"
set add=conn.execute(SQLINSERT)
conn.close

Help would be much appreciated
 
mister krabs
Posts: 13974
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
The butler did it.
Note: this forum is NOT for serious inquiries about programming but rather it is for anything else. Try posting the above in the JDBC forum. You might have better luck.
 
Yeah, but is it art? What do you think tiny ad?
Java file APIs (DOC, XLS, PDF, and many more)
https://products.aspose.com/total/java
  • Post Reply Bookmark Topic Watch Topic
  • New Topic
Boost this thread!