Small problem with QBase

[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

[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.

[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 18 times

DBAS_BUGS.zip

(14.72 KiB) Downloaded 18 times

Cheers,
Norm.

[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 23 times

Cheers,
Norm.