| View previous topic :: View next topic |
| Author |
Message |
Katofiad
Joined: 25 Jul 2006
Posts: 3
|
 Posted: Wed Jul 26, 2006 5:51 Post subject: Table Columns |
 |
|
Can you create a new field entry column in a table on the fly? Lets say I created a table called "player" and with the columns "name", "race", "class", and "level. Later on the Player Character adds a second class to his or her character. Can I add the fields "class2" and "level2" on the fly? Or would I have to delete the current table and create a new one?
Im using SQLiteCC via the NWNX2 plug-in. |
|
| Back to top |
|
 |
Acrodania
Joined: 02 Jan 2005
Posts: 208
|
| Posted: Wed Jul 26, 2006 7:23 Post subject: Re: Table Columns |
|
|
| Katofiad wrote: | Can you create a new field entry column in a table on the fly? Lets say I created a table called "player" and with the columns "name", "race", "class", and "level. Later on the Player Character adds a second class to his or her character. Can I add the fields "class2" and "level2" on the fly? Or would I have to delete the current table and create a new one?
Im using SQLiteCC via the NWNX2 plug-in. |
Its just a SQL command issued via SQLExecDirect.
With MySQL its no problem, SQLite is harder and you have to have the correct DLLs for the version that supports it. Don't expect to  |
|
| Back to top |
|
|
Papillon
x-man
Joined: 28 Dec 2004
Posts: 1060
Location: Germany
|
| Posted: Wed Jul 26, 2006 21:13 Post subject: |
|
|
"On the fly" sounds like an SQL command. Again, here's the link:
http://www.sqlite.org/lang_altertable.html
| Quote: | | SQLite's version of the ALTER TABLE command allows the user to rename or add a new column to an existing table. It is not possible to remove a column from a table. |
_________________
Papillon |
|
| Back to top |
|
|
|
FAQ
Search
Memberlist
Usergroups
Register
Profile
Log in to check your private messages
Log in
