BorlandTalk.com Forum Index BorlandTalk.com
Borland discussion newsgroups
 
Archives   FAQFAQ   SearchSearch   MemberlistMemberlist   UsergroupsUsergroups   RegisterRegister 
 ProfileProfile   Log in to check your private messagesLog in to check your private messages   Log inLog in 

Index does not exist - SQL-Link MS SQL 2000

 
Post new topic   Reply to topic    BorlandTalk.com Forum Index -> Delphi Databases (SQL Servers)
View previous topic :: View next topic  
Author Message
Chris Erdal
Guest





PostPosted: Tue Feb 07, 2006 3:01 pm    Post subject: Index does not exist - SQL-Link MS SQL 2000 Reply with quote



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





PostPosted: Wed Feb 08, 2006 9:04 am    Post subject: Re: Index does not exist - SQL-Link MS SQL 2000 Reply with quote



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
Display posts from previous:   
Post new topic   Reply to topic    BorlandTalk.com Forum Index -> Delphi Databases (SQL Servers) All times are GMT
Page 1 of 1

 
Jump to:  
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


Powered by phpBB © 2001, 2006 phpBB Group
SEO toolkit © 2004-2006 webmedic.