🚀 go-pugleaf

Hello Everyone,

As I said in my subject, SQLEXEC( ) returns error code 239 (IDAPI
Error). But, I am having trouble figuring out the problem. This is VdB
5.6.

The code boils down to this:

lcLine    = "select * from 'g:\productn\tkhistry' where employee =
'6064353'"
lcFile    = "temp"
x    = SQLEXEC( lcLine, lcFile )

The files are level 5 standard .dbfs. The path and file name are
correct. The SQL works if run as local SQL*. And, the killer... it works
when run from the form through the dBASE environment, but not through
the .exe!

The g: drive is on our network server. Novell 4.10. I have Netware Admin
privileges. Client PCs are Win95 (osr2). The tkhistry file is huge
(about 1 GB) and contains about 1 million records.There is over 1 GB of
free space on g: The file is used by us every day and there does not
appear to be any corruption. The program uses the same command on 2
other files that have identical record structures, but much fewer
records (10,000 and 5,000 respectively). The result was the same.

When I copied all of my forms, custforms, relevant files into the
g:\productn directory, I was able to run the form through my VdB 5.6 and
the program worked like a charm! However, the .exe, even after
recompiling and restarting the PC, did not work.

When you execute SQL in dBASE, there are 3 "steps" that are shown in the
status bar during the execution of the command. These are not happening
in this case. The SQLEXEC( ) comes back very quickly with the error
message. SQLERROR( ) and SQLMESSAGE( ) are blank - so no clues from
them.

Any thoughts on what the problem is? Any suggestions? I need this to
work in 5.6, so upgrading is not an answer (as much as I would like it
to be).

Thanks in advance for your help.

--
Geoff Wass
Kuala Lumpur, Malaysia


=============================================================
Please respond to a newsgroup posting by posting a reply (not e-mail).
In this way, all can help and all can learn!


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