||Re: SQL stop sorting at middle of table
Mervyn Bick <email@example.com>
||Sat, 5 Jan 2019 09:06:30 +0200
On 2019-01-05 1:49 AM, Keith wrote:
> Hi Mervyn,
> Condate is a date field and your codes work very beautifully.
> However the Last_consult shows as 02/28/2018.
> Please teach me how to check the contents of condate.
> Much thanks....
You are going to need to inspect the actual records.
In the Command Panel
select count(*) from consults where extract(year from condate) = 2018
This is just to output the count of consults for the year.
select code,condate from consults where extract(year from condate) =
2018 order by condate
//all that on one line
If the last record on view in the browser is 02/28/2018 records for the
rest of the year are not in the table or the values in condate have been
select * from consults
Records for 2018 will have been added to the bottom of the table each
time so you should see them below the entry for 02/28/2018
If there are records after 02/28/2018 how to fix this depends on what's
wrong. Please describe what the dates look like after 02/28/2018 and we
can start from there.
Each select closes the rowset opened previously but to prevent leaving
the last rowset open enter USE when you've finished exploring the table.