🚀 go-pugleaf

"Vladimir Afanasyev" <avv@systema.kiev.ua> wrote in message
news:3fa77c01$1@newsgroups.borland.com...
>
> Hi Ted,
> Do you try my sample from codecentral?
> http://codecentral.borland.com/codecentral/ccweb.exe/listing?id=19860
> Vladimir.

Hi Vladimir,

Yes, I tried it, but I had trouble following some of it because there is no
explanation of what is happening, or supposed to happen.  Moreover, it is
difficult to relate the code to commands the user has sent because you left
the names of the controls at the default ones given by BCB rather than
giving them names that allow one to know what command has been given just
from the function name.

I did make a lot of progress by studying your code, but I am guessing I
missed something.  Do you have any ideas as to why I see this particular
problem?  I don't understand why the plain insert worked fine but the
subsequent query to see if a given value is already in the lookup table
should fail.  Do I need to be wrapping these queries in transactions, even
though I don't need rollback capability, or is there some other way to
commit the changes I made before submitting the query?  The only way I can
see this error arising is if the initial changes I made, creating the tables
and indices and inserting data had been in a local temporary copy of the
data while the select was done reading directly from the file, and if the
data was commited only when the ADO variables went out of scope.  But if I
am correct here, I am still puzzled because I had thought I was working in
immediate mode.

Cheers,

Ted