Page 2 of 2

Re: Small problem with QBase

Posted: Sun Mar 23, 2025 11:28 am
by Derek_Stewart
HI,

I do not seem to have a disassembly of DBAS, which is strange, as this is one of my most used extension/systems on the QL.

If you want I can produce a disassembly and post it on Github

Re: Small problem with QBase

Posted: Sun Mar 23, 2025 5:37 pm
by NormanDunbar
Thanks Derek, and Dilwyn for your responses.

Yes please Derek, If you wouldn't mind creating a disassembly just of data_bin for my needs, that would be great.

Thanks again.

Cheers,
Norm.

Re: Small problem with QBase

Posted: Mon Mar 24, 2025 5:13 pm
by NormanDunbar
If anyone wants to look over this stuff.....

The attached DBAS_BUGS.zip file, created on a QL, holds 4 test assembly programs with source. These are:

Select_CD01: Should exclude all "CD 01" records from the database. There are 5 of those, so there should be a record count of 779. Instead there is a record count of 5 and all 5 have "CD 01" disc names. INCORRECT.

Select_CD01_64: Should include only the 5 "CD 01" records from the database. Instead there is a record count of 784 (all records) and all have "CD 01" disc names. INCORRECT.

Select_GG01: Should exclude 47 "GG 01" records from the database. There should be a record count of 737. Instead there is a record count of 127 and all have "CD 01" disc names. INCORRECT.

Select_CD01_64: Should include only the 47 "GG 01" records from the database. Instead there is a record count of 784 (all records) and all have "CD 01" disc names. INCORRECT.

I have also tested a reset of the database by selecting ALL rows, with the first byte in the parameter set to 64, to include all rows, it does indeed include all rows. When set to zero to exclude all rows, it does also work.

So, for including all rows, 64 works as does zero to exclude all rows. However, when including or excluding specific disc labels, the parameters do not appear to be working.

Also attached is an "in progress" PDF for the DBAS system --- a conversion of the Quill docs.

DBAS.pdf
(403.78 KiB) Downloaded 34 times
DBAS_BUGS.zip
(14.72 KiB) Downloaded 36 times



Cheers,
Norm.

Re: Small problem with QBase

Posted: Mon Mar 24, 2025 7:52 pm
by NormanDunbar
Sorry, I'm a plank!

I neglected to position to the next record in the database before fetching and printing the disc name. However, I have now fixed that problem, and guess what, the results are exactly the same!

I've uploaded the latest zip file.

DBAS_BUGS.zip
(97.99 KiB) Downloaded 41 times

Cheers,
Norm.