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

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

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

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

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

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