I like that. Something along the lines of a SQLEXEC killer.
>I would think of something like this:
>
>
>Set SQl Engine To SqlServer
>
>=SetSqlConnection("MyDSN")
>OR
>=SetSqlConnection("MyConnect String")
>
>
>Select * From Pubs.Dbo.Employee Where ....
>
>Scan
> ...
>EndScan
>
>Replace .....
>
>=TableUpdate(2, .F., "Pubs")
>
>
>
>>I agree it could be an intriguing wish. But like I replied to Charles, I do not have a clue what this option would mean. What does anyone have in mind that this option would do for you/us?
>>
>>IAC, this has been a most interesting thread. I know JimN has take a ton of heat for starting this, but it has been a great ride.
>>
>>>That definitely needs to go on the top of the wishlist!
>>>
>>>>if I were building stuff into VFP 10 I'd make sure it had a "USE MSDE/SQL" checkbox in Options.
Mark McCasland
Midlothian, TX USA