![]() | ![]() Products ![]() ![]() ![]() ![]() |
Home » Technical Support » ElevateDB Technical Support » Support Forums » ElevateDB SQL » View Thread |
Messages 1 to 8 of 8 total |
![]() |
Fri, Feb 13 2009 10:44 PM | Permanent Link |
"Jan-Erik Johansen" | The following query works just fine
select T1.*, (select IntegerField from T2 where T2.ID = T1.ID AND T2.ItemNo = T1.ItemNo ORDER BY T2.ItemNo RANGE 1 TO 1) as F from T1 where T1.ID = 8 However, if I try getting a blob field in the select from T2, everythings just stops responding. select T1.*, (select BlobField from T2 where T2.ID = T1.ID AND T2.ItemNo = T1.ItemNo ORDER BY T2.ItemNo RANGE 1 TO 1) as F from T1 where T1.ID = 8 It does work if I LEFT JOIN T2 but I need to use a RANGE as I want just one of the records in T2. -- Jan-Erik |
Sat, Feb 14 2009 8:39 PM | Permanent Link |
Tim Young [Elevate Software] Elevate Software, Inc. ![]() | Jan-Erik,
<< However, if I try getting a blob field in the select from T2, everythings just stops responding. >> Could you send me the source tables and the database catalog ? Thanks, -- Tim Young Elevate Software www.elevatesoft.com |
Mon, Feb 16 2009 5:19 AM | Permanent Link |
"Jan-Erik Johansen" | "Tim Young [Elevate Software]" > wrote
> > Could you send me the source tables and the database catalog ? I'll prepare something that you can download, the size makes it unsuitable for e-mailing. -- Jan-Erik |
Mon, Feb 16 2009 2:50 PM | Permanent Link |
Tim Young [Elevate Software] Elevate Software, Inc. ![]() | Jan-Erik,
<< I'll prepare something that you can download, the size makes it unsuitable for e-mailing. >> Thank you very much. It would be nice if I can get a fix in 2.02 B8 if it is indeed a bug. -- Tim Young Elevate Software www.elevatesoft.com |
Mon, Feb 16 2009 7:18 PM | Permanent Link |
"Jan-Erik Johansen" | Tim,
I've sent you the necessary download info in an e-mail. -- Jan-Erik |
Tue, Feb 17 2009 10:44 PM | Permanent Link |
Tim Young [Elevate Software] Elevate Software, Inc. ![]() | Jan-Erik,
<< I've sent you the necessary download info in an e-mail. >> Are you executing this in the EDB Manager or in .NET ? I just tried it here with the Unicode EDB Manager and it returns 538 rows in 0.516 secs. Also, are you executing this locally or remotely ? -- Tim Young Elevate Software www.elevatesoft.com |
Wed, Feb 18 2009 5:26 AM | Permanent Link |
"Jan-Erik Johansen" | Tim,
> Are you executing this in the EDB Manager or in .NET ? I just tried it > here with the Unicode EDB Manager and it returns 538 rows in 0.516 secs. I always profile the queries in the EDB Manager unless they are straight forward, so Yes, it is running from EDB Manager. > Also, are you executing this locally or remotely ? Remotely. It is running on Windows Server 2008, but that shouln't matter. I'll send you another mail with more info later today. -- Jan-Erik |
Wed, Feb 18 2009 8:29 AM | Permanent Link |
Tim Young [Elevate Software] Elevate Software, Inc. ![]() | Jan-Erik,
<< I always profile the queries in the EDB Manager unless they are straight forward, so Yes, it is running from EDB Manager. Remotely. >> Hmm, works fine here with a remote session also. Response time is still good, 0.531 secs in the EDB Manager. -- Tim Young Elevate Software www.elevatesoft.com |
This web page was last updated on Wednesday, August 14, 2024 at 07:31 PM | Privacy Policy![]() © 2024 Elevate Software, Inc. All Rights Reserved Questions or comments ? ![]() |