Icon View Thread

The following is the text of the current message along with any replies.
Messages 1 to 5 of 5 total
Thread Altering query loses results display in EDBManager
Wed, Aug 4 2010 2:54 AMPermanent Link

Roy Lambert

NLH Associates

Team Elevate Team Elevate

PC: Dell Vostro 1700 RAM: 3Gb Disk 250Gb
OS: Vista
Delphi 2006 SP2
ElevateDB 2.03b17 non-unicode


In EDBManager ran a query

select * from companies where _products is not null

that was fine. I then changed it to

select _products from companies where _products is not null

result set now shows nothing

Roy Lambert
Wed, Aug 4 2010 2:57 AMPermanent Link

Roy Lambert

NLH Associates

Team Elevate Team Elevate

Just to clarify - there were c1800 rows each time it was the column not being displayed that was the problem.

Roy Lambert
Wed, Aug 4 2010 3:43 AMPermanent Link

Malcolm Taylor

OS: Vista
Delphi 2009
ElevateDB 2.03b18 unicode

Roy

I do not see it here in the Manager.  For the second version, I get a
single column displayed with same number of rows.  I do have nulls in
the column I used. <shrug>

--
Thu, Aug 5 2010 3:23 PMPermanent Link

Tim Young [Elevate Software]

Elevate Software, Inc.

Avatar

Email timyoung@elevatesoft.com

Roy,

<< In EDBManager ran a query >>

Please send me the database catalog and table files that you're using.

--
Tim Young
Elevate Software
www.elevatesoft.com
Fri, Aug 6 2010 3:26 AMPermanent Link

Roy Lambert

NLH Associates

Team Elevate Team Elevate

Tim


I will if I can manage to duplicate it again Frown

There's obviously more to it than I thought.

Yesterday it happened every time I tried it (several before posting and few after). Today its working. I think I must try to remember to reboot and test before posting.

Roy Lambert
Image