Best way to see if a table exists using NWNX2?

johnymutton · Post by **johnymutton** » Wed Apr 14, 2004 9:39 pm

Hiya friends!

I am really enjoying nwnx2. I just converted my persistent world over to it and it has solved alot of my problems that i was experiencing with the bioware database system.

One question that I haven't been able to answer is whats the best way to determine if a table exists?

I like the way the bioware database engine creates the table if it doens't exist automatically when you store a campaign variable.

I have created a workaround for this for nwnx2, but i think there must be a better way.

I would very much like a sql call or something of that nature that can tell me if a table exists or not.

thanks

johnymutton

Server Name: 0 - - - newbies welcome!
Genre: Action
My NWN Resource Page I Cant Find My Sheep

Manuel the White · Post by **Manuel the White** » Wed Apr 14, 2004 10:02 pm

Hi. 8 )

The best place to find information on NWNX is the NWNX Guild located at Bioware's website. It can be found here: http://nwn.bioware.com/guilds_registry/ ... l?gid=3087

We're glad that NWNX is working well for you and so many other persistent worlds. I'm sure Papillion will be pleased by your kind words.

Yours,

- Manuel

johnymutton · Post by **johnymutton** » Thu Apr 15, 2004 4:20 am

thank you!

here is the link to the message I posted on the bioware site regarding this question in case anyone else is interested.

http://nwn.bioware.com/guilds_registry/ ... 0&gid=3087

Server Name: 0 - - - newbies welcome!
Genre: Action
My NWN Resource Page I Cant Find My Sheep

_LuCkY_ · Post by **_LuCkY_** » Thu Apr 15, 2004 5:49 am

I don't think its nessecarily NWNx2 that you should ask the question to, but the database server. For instance in SQL Server there is a table in the master database that stores all the names of the existing tables. All you'd have to do is write a query that checks that table to see if it exists. Might be a bit tougher to do with NWNx2 as you can only work with queries and not with database schemes and the like (or am I wrong here?).