Anyone out there had any experience of getting GPF errors in IDAPI01.DLL
when embedding SQL queries in Delphi 1.02?

The basic setup is that I'm running under Windows 3.11 and DOS 6.22, no
network, Pentium with 32 MB of memory, nothing else running except Delphi.

The application is a fairly simple one - it takes a dBASE .DBF, and
updates the fields in that database from data held in a Pascal random
access file created by a BP7 application, though that's hardly
relevant. The program works its way down the random access file,
retrieves a few values, and then does an SQL UPDATE with a batch of
replaceable parameters to update the DBF.

The SQL query itself is very simple, just a straight UPDATE with a
WHERE clause on one of the fields in the database. The program works
just fine till I call the query.open, and that's the point at which it
GPFs after a couple of seconds, returning an EGPFault message from the
BDE, at an address in IDAPI01.DLL.

I've been through all the paramters, all the fields are exactly as
expected, no problems there. The corresponding routine to rebuild one of
the random access files (via a SELECT on the same database) works with
no problem whatsoever. I've checke the configuration of the BDE, and
can't see anything wrong, the database alias is properly defined,
directory is correct, and so on.

This one is driving me scatty - I've been trying to sort this error for
three days now, and no progress. Any ideas VERY gratefully received, I'm
at the stage of trying anything that sounds like it has ANY chance of
success!

Thanks,
Brian.

: The SQL query itself is very simple, just a straight UPDATE with a
: WHERE clause on one of the fields in the database. The program works
: just fine till I call the query.open, and that's the point at which it
: GPFs after a couple of seconds, returning an EGPFault message from the
: BDE, at an address in IDAPI01.DLL.
[snip]

Hallo Brian!

You should use query.ExecuteSQL (?)  instead of query.open.
UPDATE SQL query does not return result set - it means that BDE returns
null pointer but Delphi TQuery component does not expect this and passes
this BDE back .. and this generates GPF.
query.ExecuteSQL does not expect result set and should be used always when
no answer is expected from server.

hope it helps!
Tanel