View Single Post
  #6 (permalink)  
Old March 11th, 2004, 01:00 PM
jmss66 jmss66 is offline
Friend of Wrox
Points: 1,035, Level: 12
Points: 1,035, Level: 12 Points: 1,035, Level: 12 Points: 1,035, Level: 12
Activity: 0%
Activity: 0% Activity: 0% Activity: 0%
 
Join Date: Jun 2003
Location: , , USA.
Posts: 196
Thanks: 0
Thanked 0 Times in 0 Posts
Send a message via Yahoo to jmss66
Default

Okay. After playing with it some more I was finally able to create it. My mistake was I was creating a table and a recordset at the same time. What I did was :

sqlString = "CREATE TABLE Names (FirstName TEXT (20), LastName TEXT (20), DateOfBirth DATETIME, CONSTRAINT MultiConstraint UNIQUE(FirstName, LastName, DateOfBirth) )"
objconn.Execute (strSQL)

This created a table. Now I have to figure out how to delete or destroy this table after session is over.

Thanks,
Judy

Reply With Quote