Subject Re: Queries
From Akshat Kapoor <akshat.kapoor@kapoorsons.in>
Date Fri, 22 May 2020 09:14:35 +0530
Newsgroups dbase.getting-started

On 22.05.2020 03:59, Khalid Al Awadhi wrote:
> Greetings
> I come from an old school if dBase 5 dos
> I’m still not so understanding the terms of the new ones
> I understand that we can create more than one query on a DBF file
> Is that same as opening more than one NDX files on one DBF?
> In other words are index files replaced with queries?

Good Morning Khalid,
No creating two queries is not the same as opening two ndx files. Ndx
files were index files. Queries are not index files

queries are connection to a dbf file.

Creating two queries would be the same as
use TableA order FirstName
select B
use TableA order LastName.


>
> My second help request is how to create a query using sql

Where do you intend to create a query. The steps will vary.
I will against request you to go through the tutorial It will take you
through all these steps.

If you want  to purchase books then it will cost you but the tutorial is
free.

To learn dBase you will have to select one of the above two steps.

Regards
Akshat