Well I converted the code, to increment the ID fields manually, However may change it up to use sequence objects if I can code For them in the script to be created.
I have someone working on it for me and helping me out. -----Original Message----- From: Deanna Schneider [mailto:[EMAIL PROTECTED] Sent: Friday, February 11, 2005 9:53 AM To: CF-Community Subject: Re: Need a favor (Oracle) If you're trying to support earlier versions of Oracle, be aware that the earlier versions didn't support standard outer join syntax for queries. If your client has 10g, that won't be an issue. Also, there's no such thing as an auto-increment field in Oracle, so if you're relying on those at all, you'd have to recode everything to support oracle. On Fri, 11 Feb 2005 09:39:07 -0500, Adkins, Randy <[EMAIL PROTECTED]> wrote: > Well, I have an application that an end user wants to use Oracle. > I have it setup for MySQL, MS-SQL and MS-Access. > > So I thought it would be a benefit if I could go ahead and modify The > application to use Oracle as well. > > I do have Oracle 10g from one of the oracle books I picked up from > Barnes and Noble. But I am still somewhat lost in the administration > Of an oracle DB. > > -----Original Message----- > From: G [mailto:[EMAIL PROTECTED] > Sent: Friday, February 11, 2005 9:33 AM > To: CF-Community > Subject: Re: Need a favor (Oracle) > > Just out of curiosity Randy, how is it that your stuck writing an > Oracle script....without the presence of an Oracle database??? > > I'd feel uncomfortable giving a script to someone that I was unable to > test myself! > > > If anyone has an Oracle database, I have a script to create tables > > within a database if someone can test it for me and let me know if > > there are any errors. > > > > Greatly appreciated! > > > > > > ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| Flash for programmers - Flash MX Pro http://www.houseoffusion.com/banners/view.cfm?bannerid=56 Message: http://www.houseoffusion.com/lists.cfm/link=i:5:147002 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/5 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:5 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.5 Donations & Support: http://www.houseoffusion.com/tiny.cfm/54
