 |
BorlandTalk.com Borland discussion newsgroups
|
| View previous topic :: View next topic |
| Author |
Message |
Chris Erdal Guest
|
Posted: Tue Feb 07, 2006 3:01 pm Post subject: Index does not exist - SQL-Link MS SQL 2000 |
|
|
I'm stumped here. All comments welcome!
my setup: W2K Pro SP4 + D7 Enterprise + SQL-links (local
SQLServer 2000)
client's setup: W XP Home + client SQL 2000 --> SQL2000 Server on W2K
He complained that when a certain form gains focus, a message pops up
saying
Index does not exist
He closes the popup and all works as usual. As he is always changing from
form to form, it gets a little(!) annoying after a while.
I have done a comparison (using ExamDiff Pro) of the create scripts
generated by his production database and my development one - all indexes
are identical.
I am now on his premises and linked to his network, and have done a byte-
comparison of our respective executables. Identical.
I run MY executable on my PC using HIS network database server, and I
don't get the popup message.
I run HIS executable on my PC using HIS network database server, and I
don't get the popup message.
Where do I look for an explanation?
--
Chris |
|
| Back to top |
|
 |
Chris Erdal Guest
|
Posted: Wed Feb 08, 2006 9:04 am Post subject: Re: Index does not exist - SQL-Link MS SQL 2000 |
|
|
Problem has disappeared after full rebuild for remote debugging, where I
fixed a 'not found' compiler error.
The compiler complained it couldn't find QRPrinter in another form, and so
I added another QRPreview and removed it, and then found that the one left
on the form was called QRPreview1. I renamed it, recompiled, and all is
well.
I had occasionally noticed a run-time message in the IDE complaining about
not finding this QRPreview, but had thought it insignificant as it didn't
stop the program from running on my PC and qrprntr.dcu was on the
compiler's path. It reminded me of certain datasets complaining they didn't
know the database, which I assume is linked to the order the compiler deals
with the forms, some of which had open datasets the last time I closed
them.
So the lesson is, do a full rebuild and do everything you need to to make
the compiler REALLY happy before letting your software out the door.
But I'd still like to know why the error only occurred on his PC...
Thanks for listening :-)
--
Chris |
|
| Back to top |
|
 |
|
|
You cannot post new topics in this forum You cannot reply to topics in this forum You cannot edit your posts in this forum You cannot delete your posts in this forum You cannot vote in polls in this forum
|
|