![]() | ![]() Products ![]() ![]() ![]() ![]() |
Home » Technical Support » ElevateDB Technical Support » Support Forums » ElevateDB SQL » View Thread |
Messages 1 to 6 of 6 total |
![]() |
Tue, Jun 5 2007 5:42 AM | Permanent Link |
Roy Lambert NLH Associates ![]() | Tim
================================================================================ SQL Query (Executed by ElevateDB 1.03 Build 1) Note: The SQL shown here is generated by ElevateDB and may not be exactly the same as the SQL that was originally entered. However, none of the differences alter the execution results in any way. ================================================================================ SELECT ALL "_Name" AS "_Name" FROM "companies" ORDER BY "_Name" Source Tables ------------- ================================================================================ The execution was aborted, 0 row(s) returned in 0 secs ================================================================================ ================================================================================ 0 row(s) returned in 0.407 secs ================================================================================ Strangely enough I'm then shown 9305 rows...... Roy Lambert |
Tue, Jun 5 2007 1:37 PM | Permanent Link |
Tim Young [Elevate Software] Elevate Software, Inc. ![]() | Roy,
<< SELECT ALL "_Name" AS "_Name" FROM "companies" ORDER BY "_Name" >> Do I have this table ? Also, what is the setting for RequestSensitive ? -- Tim Young Elevate Software www.elevatesoft.com |
Tue, Jun 5 2007 2:01 PM | Permanent Link |
Roy Lambert NLH Associates ![]() | Tim
You don't have it - its part of a database converted from an existing app using 1.03. Database as a whole 80Mb, this table 17Mb. I also tried it on a different table and obtained the same result. Request sensitive is the default - checked. That reminds me of another question - how do I tell if EDBMan has returned a sensitive result set or not? Does it uncheck the box? Roy Lambert |
Tue, Jun 5 2007 2:42 PM | Permanent Link |
Tim Young [Elevate Software] Elevate Software, Inc. ![]() | Roy,
<< You don't have it - its part of a database converted from an existing app using 1.03. Database as a whole 80Mb, this table 17Mb. I also tried it on a different table and obtained the same result. >> Can you get it to happen on any of the tables that I do have, like those from MandN ? << Request sensitive is the default - checked. That reminds me of another question - how do I tell if EDBMan has returned a sensitive result set or not? >> The insert, update, delete task links in the left-hand tasks pane will not be present for read-only (insensitive) result sets. -- Tim Young Elevate Software www.elevatesoft.com |
Wed, Jun 6 2007 3:15 AM | Permanent Link |
Roy Lambert NLH Associates ![]() | Tim
>Can you get it to happen on any of the tables that I do have, like those >from MandN ? Sure can. ================================================================================ SQL Query (Executed by ElevateDB 1.03 Build 1) Note: The SQL shown here is generated by ElevateDB and may not be exactly the same as the SQL that was originally entered. However, none of the differences alter the execution results in any way. ================================================================================ SELECT ALL "_subject" AS "_subject" FROM "mandn" ORDER BY "_subject" Source Tables ------------- ================================================================================ The execution was aborted, 0 row(s) returned in 0 secs ================================================================================ ================================================================================ 0 row(s) returned in 10.375 secs ================================================================================ But I think this is also migrated via 1.03 - check the row count (I have 154358). I can't remember if I sent you the DBISAM or the ElevateDB tables. ><< Request sensitive is the default - checked. > > That reminds me of another question - how do I tell if EDBMan has returned >a sensitive result set or not? >> > >The insert, update, delete task links in the left-hand tasks pane will not >be present for read-only (insensitive) result sets. Ahh Roy Lambert |
Wed, Jun 6 2007 5:07 PM | Permanent Link |
Tim Young [Elevate Software] Elevate Software, Inc. ![]() | Roy,
<< Sure can. >> Cool, thanks. I was missing the static/insensitive result set part and was assuming a sensitive result set. A fix will be in 1.03 B2. -- 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 ? ![]() |