Hi All
Maybe you will be interested in my findings and those of you out there
who might have attempted this can give me some input. I was doing this work
with a Oracle programmer.
I unloaded my R:BASE schema and did a few conversions and created an Oracle
data base.
The changes were all TEXT to VarChar2
all CURRENCY to NUMBER
all TIME to NUMBER
all INTEGER to NUMBER
all DOUBLE to NUMBER
all REAL TO NUMBER
I had to do away with all computed columns , unsupported by Oracle.
The Oracle expert I am doing this with tells me that triggers on tables in
Oracle could be used to replace computed columns.
The R:Base data types TIME, CURRENCY, INTEGER and TEXT are not support by
Oracle 8i.
In fact standard oracle has a small range of data types available.
When I connected to Oracle data base I could connect to all the tables.
The Oracle varchar2 (30) as seen by R:Base was a NOTE (30)
The Oracle Number was seen by R:BASE as Double.
The Oracle Date field was seen by R:BASE as DATETIME.
I was able to insert and update from all these fields types with no
problem.
I was able to get my R:BASE forms to enter and edit data to the oracle
table.
Okay, the next step is to change all my source code and forms and reports to
address the change data types. I would have to develop some logic to use
Double type
for TIME and CURRENCY. All my Interger data type will now be Double. I can
use the masking in forms to display the double as interger.
The problem I have is that the DATETIME function as shown in a form cannot
be masked to
show just the DATE only. R:BASE laso has a DATETIME data type.
nybody have any ideas on how I can just show the date part of the datetime
on an
R:BASE form.
Any advise will be welcome.
Regards
Victor
================================================
TO SEE MESSAGE POSTING GUIDELINES:
Send a plain text email to [EMAIL PROTECTED]
In the message body, put just two words: INTRO rbase-l
================================================
TO UNSUBSCRIBE: send a plain text email to [EMAIL PROTECTED]
In the message body, put just two words: UNSUBSCRIBE rbase-l
================================================
TO SEARCH ARCHIVES:
http://www.mail-archive.com/rbase-l%40sonetmail.com/
