| Author |
 Topic  |
|
|
Da_Stimulator
DEV Team Forum Moderator
USA
3373 Posts |
 Posted - 01 November 2001 : 16:43:01
|
I've successfully written a script to COPY a table to a new table name (given via form) AND copy all of the records from the old table to the new table.
Give me a couple hours (now I have a new toy... heh heh) - I will debug the script and post it up (might be useful for mod creation and editing/debugging)
---------------
-Da_Stimulator |
|
|
Da_Stimulator
DEV Team Forum Moderator
USA
3373 Posts |
Posted - 01 November 2001 : 16:50:16
|
ok maybe not so successful - but very close. I sense this is an easy fix. Can anyone spot a 'syntax error' (I love how error messages are so specific) in the following Create statement?
CREATE TABLE T_ADMIN ( ADMINID COUNTER, ADMINLEVEL TEXT(30), ADMINNAME TEXT(30), ADMINPASSWORD TEXT(30), SHOWBANNERS NUMBER(2), APPROVESITES TEXT(5), SITESTOSHOW NUMBER(2), CONTACTNAME TEXT(100), CONTACTEMAIL TEXT(100), TOPSITENAME TEXT(100), HOMEPAGE TEXT(200), TYPEOFLINK TEXT(20), BUTTONURL TEXT(200), SITEBANNERSTOSHOW NUMBER(2), bgcolor TEXT(25), textcolor TEXT(25), thbg TEXT(25), thtext TEXT(25), tdbg TEXT(25), tdtext TEXT(25), tdborder TEXT(25), dlink TEXT(25), dlinkdecor TEXT(25), vlink TEXT(25), vlinkdecor TEXT(25), alink TEXT(25), alinkdecor TEXT(25), hlink TEXT(25), hlinkdecor TEXT(25), TOPLISTURL TEXT(200))
---------------
-Da_Stimulator |
 |
|
|
RichardKinser
Snitz Forums Admin
USA
16655 Posts |
Posted - 01 November 2001 : 16:52:29
|
But I thought you were a "freakin genious" ?  |
|
|
|
Da_Stimulator
DEV Team Forum Moderator
USA
3373 Posts |
Posted - 01 November 2001 : 16:54:15
|
well I have a feeling I shouldnt specify a size on the 'number' fields, but I needed verification :)
---------------
-Da_Stimulator |
|
|
|
Da_Stimulator
DEV Team Forum Moderator
USA
3373 Posts |
Posted - 01 November 2001 : 17:07:39
|
woohoo it was the number thing - works now - now for compatibility issues... currently it will only work with Access
---------------
-Da_Stimulator |
|
|
|
redbrad0
Advanced Member
USA
3725 Posts |
Posted - 01 November 2001 : 17:11:20
|
for sql server you know you have to change text to nvarchar, memo is now text, and sorry i cant think of any other differences right now
Brad |
|
|
|
Da_Stimulator
DEV Team Forum Moderator
USA
3373 Posts |
Posted - 01 November 2001 : 17:16:06
|
I know the conversions
memo = text
text = varchar or nvarchar
number = int
counter = identity(1,1)
---------------
-Da_Stimulator |
|
|
| |
Topic |
|
Topic Locked
