VO bBrowser using ADS SQL database displays EOF record
Posted: Wed Feb 24, 2021 2:33 pm
Hi Everyone,
In Visual Objects, when using a DBF/CDX database in bBrowser 4 (latest version/update) where the database is created with ADS 12 (also latest version/update) and the AXSQLCDX driver then at the bottom of the bBrowser an "empty" line appears that corresponds to EOF. I have tried numerous settings and variations of the bBrowser but the line stays. On the ADS side there is not much to experiment with, I just pass the query along with the driver and get a DBF in return which is then Used() in the bBrowser. It behaves like a normally opened DBF in most cases, the most notable difference is that automatic locking no longer works, a RLOCK() is necessary for fieldputs. There are no other problems with handling the DBF or with the bBrowser, just this annoying empty line.
I am curious to know if anyone has experienced the same issue and what a possible solution may be. Any help is much appreciated!
Kees.
In Visual Objects, when using a DBF/CDX database in bBrowser 4 (latest version/update) where the database is created with ADS 12 (also latest version/update) and the AXSQLCDX driver then at the bottom of the bBrowser an "empty" line appears that corresponds to EOF. I have tried numerous settings and variations of the bBrowser but the line stays. On the ADS side there is not much to experiment with, I just pass the query along with the driver and get a DBF in return which is then Used() in the bBrowser. It behaves like a normally opened DBF in most cases, the most notable difference is that automatic locking no longer works, a RLOCK() is necessary for fieldputs. There are no other problems with handling the DBF or with the bBrowser, just this annoying empty line.
I am curious to know if anyone has experienced the same issue and what a possible solution may be. Any help is much appreciated!
Kees.