main logo
Subject: RE: mysql vs ms sql server
Author: "Stephen the Cook"
Posted: 2005/01/31 13:13:00
 
View Entire Thread
New Search


Judith Barer wrote:
>> Secondly, if you have a USE MyTable in your system you have rewriting
>> to
> do.
>
>> You have to decide if your going to have all access via SPT's or
>> Remove Views?
>
>
>
> I probably don't have many use Mytable because I use the
> dataenvironment. I have Select Mytable all over the place but not Use
> Mytable.

That means that a VFP builder went and created the code in your GUI to :
Use Table1 alias BlaBla in 0
Use Table2 alias BlaBlaBla in 0
.......

Your probably going to find switching to remote views the easiest to do
initially, but hard to deal with in terms of inserts, updates, deletes, as
well as P-Keys.

SPT would have been just as tough on all the "other stuff" you would have
just had to do the connections class and then call that for each table on
the back end.



Stephen Russell
S.R. & Associates
Memphis, TN 38115

901.246-0159




 
©2005 Stephen the Cook
<-- Prior Message New Search Next Message -->