🚀 go-pugleaf

=============================================================
Hello everyone!

I have a new problem which has gotten progressively worse. This is for
VdB 5.6 and BDE 4.50

I started by having a simply SQL command in a program that was executed
using SQLEXEC( ) as
follows:

SQLEXEC( "SELECT * FROM TKHistry WHERE Employee = '12345678' ",
"mytemp.dbf" )

This was working fine for many weeks. I then tried the following as
something new (same as before
with a change in the sign):

SQLEXEC( "SELECT * FROM TKHistry WHERE Employee > '12345678' ",
"mytemp.dbf" )

This failed with SQLEXEC( ) returning a 269 (IDAPI error). I was
perplexed but put it aside.

A few days later, another program was run that does something similar.
It failed with the same error
code! I noticed that the SQLEXEC( ) was no longer showing "Step 1...
2... 3" in the status bar as it
would normally do. Even the first SQL command (with the = sign) now
fails. On my PC I do not get
anything displayed by the status bar, my colleague's PC which has VdB
5.6 with BDE 2.50 has the
same problem but at least Step 1 displays in the status bar when the
SQLEXEC( ) is executed.

It does not matter if the file is large or small or whether the index is
character or numeric, it still fails
now. If I run the query as local SQL, it works, except in the case of
the large file which gets
"insufficient disk space" which is another matter.

It was bad enough that the new thing I wanted to do would not work, but
now everything that was
working is failing with 269.

Has anyone run into this? Any suggestions? Please do not suggest a
higher version of dBASE, I have
to stick with 5.6! Thanks in advance for your help!


Geoff Wass
Kuala Lumpur, Malaysia




Triumph is in the first syllable.
=============================================================