George Young
|
| Posted: 07/14/2003, 10:07 AM |
|
Just need some advice,
I am currently working my way through using Codecharge Studio using an
Access as my development database but with the intention of installing the
final product onto a server running Oracle.
Will Codecharge convert the application that I am developing onto the Oracle
Databsae platform without any issues and if there will be could anyone give
me a very simple overview what to and not to do?
As you can see I am no expert in this field so any help you can offer me
would be very much appreciated.
George
|
|
|
 |
DonB
|
| Posted: 07/14/2003, 10:51 AM |
|
You will need to declare the Oracle connection by right-clicking it and
selecting "Edit". It is possible that only changing the server portion will
be required, as you may want to leave Access as the database you use during
development. You can select the server database to be the same, or a
different, one as the development database.
If you have any manually-edited SQL in your code, that would have to be
re-edited to comly with Oracle standards. Being relatively new to CCS, you
probably have not gotten into this aspect of the tool.
The code in your application does not require any modifications as the
database connection object maintains a consistent interface regardless of
the database you select.
DonB
"George Young" <george.young9@btinternet.com> wrote in message
news:beuo17$a6f$1@news.codecharge.com...
> Just need some advice,
>
> I am currently working my way through using Codecharge Studio using an
> Access as my development database but with the intention of installing the
> final product onto a server running Oracle.
>
> Will Codecharge convert the application that I am developing onto the
Oracle
> Databsae platform without any issues and if there will be could anyone
give
> me a very simple overview what to and not to do?
>
> As you can see I am no expert in this field so any help you can offer me
> would be very much appreciated.
>
> George
>
>
|
|
|
|
George Young
|
| Posted: 07/15/2003, 1:27 AM |
|
DonB,
Just so I understand this right if I use Codecharge to change some of the
SQL Statements they may not work with an oracle database. Is there any way
that I can make sure that any SQL I change conforms to Oracle apart from
manually checking all statements ?
Also is there any way to simulate an oracle databse on my system?
Thank you for your time.
"DonB" <7432D63DBB01D03A196B1EDD80E8@comcast.net> wrote in message
news:beuqj0$dek$1@news.codecharge.com...
> You will need to declare the Oracle connection by right-clicking it and
> selecting "Edit". It is possible that only changing the server portion
will
> be required, as you may want to leave Access as the database you use
during
> development. You can select the server database to be the same, or a
> different, one as the development database.
>
> If you have any manually-edited SQL in your code, that would have to be
> re-edited to comly with Oracle standards. Being relatively new to CCS,
you
> probably have not gotten into this aspect of the tool.
>
> The code in your application does not require any modifications as the
> database connection object maintains a consistent interface regardless of
> the database you select.
>
> DonB
>
>
> "George Young" <george.young9@btinternet.com> wrote in message
>news:beuo17$a6f$1@news.codecharge.com...
> > Just need some advice,
> >
> > I am currently working my way through using Codecharge Studio using an
> > Access as my development database but with the intention of installing
the
> > final product onto a server running Oracle.
> >
> > Will Codecharge convert the application that I am developing onto the
> Oracle
> > Databsae platform without any issues and if there will be could anyone
> give
> > me a very simple overview what to and not to do?
> >
> > As you can see I am no expert in this field so any help you can offer me
> > would be very much appreciated.
> >
> > George
> >
> >
>
>
|
|
|
|
DonB
|
| Posted: 07/15/2003, 7:13 AM |
|
As long as CCS is creating everything that interacts with the database,
meaning you have not written an custom code (events) where you build and
execute SQL statements of your own, then you have nothing to worry about.
If you change the database connection from one database to another, CCS
knows how to rebuild its code properly to work with that database. If you
wrote your own code (where you see the background of the text is white
instead of a gray color), CCS will not be able to change references in those
sections because it can't reliably parse your stuff.
There are a number of functions provided to help you make your code
"database neutral" (not specific to one database) so you can minimize the
above limitation by making use of those functions (e.g., DLookup()). The
functions always have the same syntax regardless of the database and the
underlying implementation of the functions does always reflect the database
you have selected.
DonB
"George Young" <george.young9@btinternet.com> wrote in message
news:bf0dte$evf$1@news.codecharge.com...
> DonB,
>
> Just so I understand this right if I use Codecharge to change some of the
> SQL Statements they may not work with an oracle database. Is there any way
> that I can make sure that any SQL I change conforms to Oracle apart from
> manually checking all statements ?
>
> Also is there any way to simulate an oracle databse on my system?
>
> Thank you for your time.
>
> "DonB" <7432D63DBB01D03A196B1EDD80E8@comcast.net> wrote in message
>news:beuqj0$dek$1@news.codecharge.com...
> > You will need to declare the Oracle connection by right-clicking it and
> > selecting "Edit". It is possible that only changing the server portion
> will
> > be required, as you may want to leave Access as the database you use
> during
> > development. You can select the server database to be the same, or a
> > different, one as the development database.
> >
> > If you have any manually-edited SQL in your code, that would have to be
> > re-edited to comly with Oracle standards. Being relatively new to CCS,
> you
> > probably have not gotten into this aspect of the tool.
> >
> > The code in your application does not require any modifications as the
> > database connection object maintains a consistent interface regardless
of
> > the database you select.
> >
> > DonB
> >
> >
> > "George Young" <george.young9@btinternet.com> wrote in message
> >news:beuo17$a6f$1@news.codecharge.com...
> > > Just need some advice,
> > >
> > > I am currently working my way through using Codecharge Studio using an
> > > Access as my development database but with the intention of installing
> the
> > > final product onto a server running Oracle.
> > >
> > > Will Codecharge convert the application that I am developing onto the
> > Oracle
> > > Databsae platform without any issues and if there will be could anyone
> > give
> > > me a very simple overview what to and not to do?
> > >
> > > As you can see I am no expert in this field so any help you can offer
me
> > > would be very much appreciated.
> > >
> > > George
> > >
> > >
> >
> >
>
>
|
|
|
|
|
