Problem with updating to new database(Sybase-->Oracle)
Tom Furseth
I use ODBC and VFP6.0.
I have dicovered that when I change my program to a new vendor it does not
work properly. But if I 'update' the remote view's by reengineering
(remaking them) then they work perfectly.
So I figure the problem is in updating the FoxPro's datadictionary. But how
can I update this without making all my queries all over again ? Do I have
to have two databasefiles and change the dbc-files runtime depending on the
database vendor ?
Would appreciate any comment,
Tom
--
Posten SDS A/S, Box 6664 Rodeløkka, N-0502 Oslo, Norway
Joshua D. Weiss
Unfortunately, VFP views are VERY sensitive to any change to the back-end
(even if the back-end is VFP). Because of this I create all my views in
code. When there are any changes to the back-end I just regenerate the dbc
that contains my views. You can create a program that will do this by
running gendbc.prg. I think it's in the VFP\tools\gendbc folder (or
something like that). It will create a .prg that will recreate a dbc,
including its views. One problem with gendbc is that if your dbc contains a
lot of views, gendbc might create a program that's larger than VFP's limit
for a single procedure. You can deal with this by splitting the .prg into
several procedures then calling each of them.
Because even a tiny change to the back-end database can screw up a view I
distribute an EXE that the user can run to regenerate the views.
--
Josh Weiss
Tremont Technologies, Inc.
Boston, MA USA
http://TremontTech.com
(remove X's from e-mail address to reply)
Tom Furseth wrote in message ...