addnew
Printed From: Web Wiz Forums
Category: General Discussion
Forum Name: Database Discussion
Forum Description: Discussion and chat on database related topics.
URL: https://forums.webwiz.net/forum_posts.asp?TID=20339
Printed Date: 28 March 2026 at 8:59pm
Software Version: Web Wiz Forums 12.08 - https://www.webwizforums.com
Topic: addnew
Posted By: Charlie Goodwin
Subject: addnew
Date Posted: 17 June 2006 at 8:31am
|
I need to store more info on the database tables. So I will need to add new fields to the table, in this case tblAuthor.
and Amend asp code to cater for the new fields.
I am about to start but I want to have a better idea of the addnew/update process.
For starters, where is the table specified?
I can see rscommon being created and the methods, addnew and update being invoked but I can't see where the table relating to rscommon is specified.
I mean, how does SQL OLE DB know which table is being processed?
Your help would be appreciated
|
Replies:
Posted By: VBScript
Date Posted: 17 June 2006 at 8:52am
|
If your on about adding rows to the database you may want to look at some of the http://www.webwiz.net/asp/tutorials/ - tutorials on this site. If you want to add new fields and tables to the database I would recommend looking at the Web Wiz Forums V7.X to V8 Migration tool ------------- http://www.james-r.co.uk" rel="no follow - James http://www.gotrillian.com/?4498-20" rel="no follow - Trillian - M |
Posted By: Charlie Goodwin
Date Posted: 17 June 2006 at 9:10am
Got it!
Open is the key method for stipulating the table.
Should have spotted it but there is a lot of code between opening the recordset and invoking the addnew method
|
Posted By: dpyers
Date Posted: 17 June 2006 at 3:58pm
|
I prefer to add new tables rather than modify existing ones. Makes future upgrades a lot more straight forward.
------------- 
Lead me not into temptation... I know the short cut, follow me. |