Re: MsAccess vs Oracle

[Jamie Harris <JHarris@FCC.CC.MD.US>]

In most cases that's true.  Just make sure there is no SQL specific
stuff in the SQR.  For example, if the SQR uses a stored procedure in
some way or it uses some SQL-server built-in function. :)

-----------------------------------------------------
Jamie Harris
Junior Systems Programmer/Analyst
Information Technology Division
Frederick Community College
-----------------------------------------------------

>>> Tcscad@AOL.COM 6/17/2002 10:40:54 AM >>>
Yes, you can use your SQR without any modifications in either way you
choose.

In a message dated 6/14/02 3:28:42 PM Central Daylight Time,
joan.hatcher@BAESYSTEMS.COM writes:


> I want to transition a Unix-based Oracle 7 database to either a
higher
> version of Oracle or to a windows based  MSAccess database.  Our
current
> report writer is SQR, and I don't want to-re-write all the reports.
>
>   1. If I went with MSAccess, am I correct in assuming that I could
use
> ODBC
> to run my old SQRs ?
>   2. If I went with Oracle, what is the highest version that can be
used
> with SQR ?
>
> Thank you for your help.
>
>   Joan Hatcher
>
>
>
> ______________________________________________
> Joan A. Hatcher                       301-862-7177  (phone)
> Programmer Analyst III          301-862-7107  (fax)
>
> joan.hatcher@baesystems.com
>
BEGIN:VCARD
VERSION:2.1
X-GWTYPE:USER
FN:Harris, Jamie
TEL;WORK:2668
ORG:Work;Division of Information Technology
EMAIL;WORK;PREF:JHarris@fcc.cc.md.us
N:Harris;Jamie
TITLE:Systems Analyst, PeopleSoft
ADR;DOM;WORK;PARCEL;POSTAL:;L-205
LABEL;DOM;WORK;PARCEL;POSTAL;ENCODING=QUOTED-PRINTABLE:Harris, Jamie=0A=
L-205
END:VCARD