Subject Re: How to use a Dbase app on two geographically diverse locations
From Ken Mayer <dbase@nospam.goldenstag.net>
Date Sat, 13 Jan 2018 07:08:05 -0800
Newsgroups dbase.getting-started

On 1/13/2018 6:25 AM, Akshat Kapoor wrote:
> On 13/01/2018 18:38, Ronnie MacGregor wrote:
>> In article <6HRfZUFjTHA.1828@ip-AC1E04A7>, akshat.kapoor@kapoorsons.in
>> says...
>>> Modified the user access and now the connection was successful.
>> Good stuff !!
>>
>>
>
> Another small query
>
> Question 1.
> If I use the executesql method of ADOdatabase what will be the
> limitations of sql command,
> 1. Subset of SQL provided by BDE
> 2. Limitations of SQL Server if any. All commands taught by w3schools
> are allowed

executeSQL() bypasses the BDE and sends information to the server.
ADODatabase is meant to bypass the BDE as well, so that should take it
out of the equation.

> Question 2
> Difference between Query class and ADOquery Class
>
> As far as my limited knowledge goes Query class uses BDE for its
> operations whereas in case of ADOquery the query is passed on to the SQL
> server directly for processing.

Same as above.

Ken

--
*Ken Mayer*
Ken's dBASE Page: http://www.goldenstag.net/dbase
The dUFLP: http://www.goldenstag.net/dbase/index.htm#duflp
dBASE Books: http://www.goldenstag.net/dbase/Books/dBASEBooks.htm
dBASE Tutorial: http://www.goldenstag.net/dbase/Tutorial/00_Preface.htm