Subject | re:Fox to Interbase with IBO/IB_WISQL? |
---|---|
Author | Joe Fay |
Post date | 2000-07-11T19:39:48Z |
I'm new to your list, and glad to have it available, since I'm almost a
rank beginner with Interbase AND IBO. I have an existing app that uses
FoxPro 2.6 tables, and since the BDE doesn't handle FoxPro tables too
well (the indices have a nasty habit of getting corrupted %#@*&^!) I
recognized that I need to do something different. Helen mentioned your
elist when trying to answer my fledgling questions about conversion,
status of Interbase, and components to use, so, hat in hand, I'm bringing
my problem here.
My goal is to convert all of those fox tables to an Interbase database,
with as little problems in data type conversion as possible, and to at
least duplicate the indices where applicable, and to replace as many of
those nasty little FoxPro 'valid' and 'when' clauses with stored
procedures, triggers, views, and the other nice features of Interbase.
The platform will be Windows 95 (I know...), and the app to be written in
Delphi 4 C/S with all the patches
My first question is this: Is there an extant help file, essay,
whatever, on the entire process of doing such a thing? You know, a way
to get an overall view of the entire process, with pitfalls, that covers
as much of this as possible? I realize I will have to do a lot of
reading to get from Oracle 7 and DB2 to Interbase using IB_Objects...I'm
prepared for that. But I must admit, after cruising the Interbase and
IBO sites a lot today, that I might be just a bit overwhelmed, but not
discouraged. : )
Sorry for the length of this post, but I wanted to include as much info
as might be needed to facillitate any help you could offer.
Joe Fay
Musician, programmer, and erstwhile poet.
________________________________________________________________
YOU'RE PAYING TOO MUCH FOR THE INTERNET!
Juno now offers FREE Internet Access!
Try it today - there's no risk! For your FREE software, visit:
http://dl.www.juno.com/get/tagj.
rank beginner with Interbase AND IBO. I have an existing app that uses
FoxPro 2.6 tables, and since the BDE doesn't handle FoxPro tables too
well (the indices have a nasty habit of getting corrupted %#@*&^!) I
recognized that I need to do something different. Helen mentioned your
elist when trying to answer my fledgling questions about conversion,
status of Interbase, and components to use, so, hat in hand, I'm bringing
my problem here.
My goal is to convert all of those fox tables to an Interbase database,
with as little problems in data type conversion as possible, and to at
least duplicate the indices where applicable, and to replace as many of
those nasty little FoxPro 'valid' and 'when' clauses with stored
procedures, triggers, views, and the other nice features of Interbase.
The platform will be Windows 95 (I know...), and the app to be written in
Delphi 4 C/S with all the patches
My first question is this: Is there an extant help file, essay,
whatever, on the entire process of doing such a thing? You know, a way
to get an overall view of the entire process, with pitfalls, that covers
as much of this as possible? I realize I will have to do a lot of
reading to get from Oracle 7 and DB2 to Interbase using IB_Objects...I'm
prepared for that. But I must admit, after cruising the Interbase and
IBO sites a lot today, that I might be just a bit overwhelmed, but not
discouraged. : )
Sorry for the length of this post, but I wanted to include as much info
as might be needed to facillitate any help you could offer.
Joe Fay
Musician, programmer, and erstwhile poet.
________________________________________________________________
YOU'RE PAYING TOO MUCH FOR THE INTERNET!
Juno now offers FREE Internet Access!
Try it today - there's no risk! For your FREE software, visit:
http://dl.www.juno.com/get/tagj.