Snitz Forums 2000
Snitz Forums 2000
Home | Profile | Register | Active Topics | Members | Search | FAQ
Username:
Password:
Save Password
Forgot your Password?

 All Forums
 Snitz Forums 2000 DEV-Group
 DEV Discussions (Oracle)
 Exporting Access Table into Oracle Schema.
 Forum Locked
 Printer Friendly
Previous Page
Author Previous Topic Topic 
Page: of 2

h20
Starting Member

39 Posts

Posted - 15 November 2000 :  16:55:06  Show Profile
Yes Mike... just take a record count of the table first... then just increment by one ... and there is your cross-platform autonumber... no autonumber data type(MS) and no trigger (Oracle) needed. You would need to change the data type of the message id field to number. There are really only 2 types of management the Database server should perform. They are:

1) User management
2) Concurrency Control Management

For a cross-platform forum, everything else should be managed in the ASP code. I know this will create a lot of up front work. However, if you want a forum that works correctly against MS and Oracle, you have no choice but to perform all but the 2 management processes mentioned earlier in the ASP code.


<
Go to Top of Page
Page: of 2 Previous Topic Topic   
Previous Page
 Forum Locked
 Printer Friendly
Jump To:
Snitz Forums 2000 © 2000-2021 Snitz™ Communications Go To Top Of Page
This page was generated in 0.03 seconds. Powered By: Snitz Forums 2000 Version 3.4.07