Hey Tim,

I have several questions, a request and several discrepancies/bugs:

Question: Will EDB have the capability (i.e., a Server Admin module) to
view the sessions, logs, etc. as is currently possible in the DBISAM
server admin? This is most helpful in my, and I imagine, many other
developer/administrators situations. In my case the server is in
another building and if I needed to disconnect or remove a session, I
can't find a way to do it now except at the server.

Question: Will users and their permissions be able to be administered
from the server or a server admin module? The reason I ask this is that
I may not want (and don't in 99% of cases) an administrator/end-user
having the EDB Manager where they could possibly do damage to the
tables, views, procedures, etc. just to be able to administer users. I
know I am comparing here to DBISAM but the server admin is a
GREATutility in DBISAM for an end-user administrator. I just can forsee
big problems occurring if an end-user administrator, who thinks he's
God's gift to computer technology, decides to start playing around in
the database with the EDB Manager.

Request: Is it possible to place a navigator in the table browser in
the EDB Manager? It would make it a whole lot easier to navigate
through the records rather than using the scroll bars (also see
discrepancy below.)

Discrepancy: Whenever I scroll down to the end of a table and then try
to scroll back up again...I cannot. The scroll bar goes to the top but
the record is not the first record. I have to scroll back to the far
left (first column) then up to get to the first record. The navigator
bar request (above) might help to solve this.

Discrepancy: Upon migrating a DBISAM database with 32 tables, several
of which have both BLOB and Memo fields, the BLOB field (which contains
graphic files) simply shows "0 bytes" and does not migrate the graphic
file (the files are all JPEGs.) The field is migrating over as a BLOB
in EDB. Likewise with any memo fields, they are devoid of any data in
them. The memo fields are being migrated as CLOB fields. This will
create a huge migration problem for me on this one particular database.

Thanks...

--
Regards,
Jan Ferguson

Jan,

<< Question: Will EDB have the capability (i.e., a Server Admin module) to
view the sessions, logs, etc. as is currently possible in the DBISAM
server admin? This is most helpful in my, and I imagine, many other
developer/administrators situations. In my case the server is in another
building and if I needed to disconnect or remove a session, I can't find a
way to do it now except at the server. >>

Currently EDB is missing two SQL maintenance statements - DISCONNECT SERVER
SESSION and REMOVE SERVER SESSION. These will be in the final release.  To
see a list of session on a remote server, just connect to it as an
administrator and then issue the following query on the system's
Configuration database:

SELECT * FROM ServerSessions

<< Question: Will users and their permissions be able to be administered
from the server or a server admin module? The reason I ask this is that
I may not want (and don't in 99% of cases) an administrator/end-user having
the EDB Manager where they could possibly do damage to the
tables, views, procedures, etc. just to be able to administer users. >>

That's what the user security is for.  If you don't want users to be able to
do administrative tasks, then don't give them administrator privileges by
granting them the Administrators role.

<< I know I am comparing here to DBISAM but the server admin is a
GREATutility in DBISAM for an end-user administrator. I just can forsee
big problems occurring if an end-user administrator, who thinks he's God's
gift to computer technology, decides to start playing around in the database
with the EDB Manager. >>

Again, it's only an issue if the user actually has administrator rights by
being a member of the Administrators role.

<< Request: Is it possible to place a navigator in the table browser in the
EDB Manager? It would make it a whole lot easier to navigate through the
records rather than using the scroll bars (also see discrepancy below.) >>

I'll see what I can do.  Space is somewhat limited, but I may be able to fit
it in.

<<  Discrepancy: Whenever I scroll down to the end of a table and then try
to scroll back up again...I cannot. The scroll bar goes to the top but
the record is not the first record. I have to scroll back to the far left
(first column) then up to get to the first record. The navigator bar request
(above) might help to solve this. >>

I'll look into this.

<< Discrepancy: Upon migrating a DBISAM database with 32 tables, several of
which have both BLOB and Memo fields, the BLOB field (which contains graphic
files) simply shows "0 bytes" and does not migrate the graphic file (the
files are all JPEGs.) The field is migrating over as a BLOB in EDB. Likewise
with any memo fields, they are devoid of any data in them. The memo fields
are being migrated as CLOB fields. This will create a huge migration problem
for me on this one particular database. >>

Please send me the DBISAM tables that are having this issue, and I'll look
into it.

--
Tim Young
Elevate Software
www.elevatesoft.com

Tim Young [Elevate Software] wrote:

<<<< Question: Will EDB have the capability (i.e., a Server Admin
<<<<module) to view the sessions, logs, etc. as is currently possible
<<<<in the DBISAM
<<server admin?
<<
<<Currently EDB is missing two SQL maintenance statements - DISCONNECT
<<SERVER SESSION and REMOVE SERVER SESSION. These will be in the final
<<release.  To see a list of session on a remote server, just connect
<<to it as an administrator and then issue the following query on the
<<system's Configuration database:
<<
<<SELECT * FROM ServerSessions

Great news...

<<<< Question: Will users and their permissions be able to be
<<<<administered from the server or a server admin module? The reason I
<<<<ask this is that
<<I may not want (and don't in 99% of cases) an administrator/end-user
<<having the EDB Manager where they could possibly do damage to the
<<tables, views, procedures, etc. just to be able to administer users.
<<
<<That's what the user security is for.  If you don't want users to be
<<able to do administrative tasks, then don't give them administrator
<<privileges by granting them the Administrators role.

Okay...I understand. I hadn't examined that yet as I only added myself
with an Administrator role. Thanks for the clarification!

<<Again, it's only an issue if the user actually has administrator
<<rights by being a member of the Administrators role.

See above...

<<<< Request: Is it possible to place a navigator in the table browser
<<<<in the EDB Manager? It would make it a whole lot easier to navigate
<<<<through the records rather than using the scroll bars (also see
<<<<discrepancy below.) >>
<<
<<I'll see what I can do.  Space is somewhat limited, but I may be able
<<to fit it in.

Thanks...

<<<<  Discrepancy: Whenever I scroll down to the end of a table and
<<<<then try to scroll back up again...I cannot. The scroll bar goes to
<<<<the top but
<<the record is not the first record. I have to scroll back to the far
<<left (first column) then up to get to the first record. The navigator
<<bar request (above) might help to solve this. >>
<<
<<I'll look into this.

Thanks...

<<<< Discrepancy: Upon migrating a DBISAM database with 32 tables,
<<<<several of which have both BLOB and Memo fields, the BLOB field
<<<<(which contains graphic files) simply shows "0 bytes" and does not
<<<<migrate the graphic file (the files are all JPEGs.) The field is
<<<<migrating over as a BLOB in EDB. Likewise with any memo fields,
<<<<they are devoid of any data in them. The memo fields are being
<<<<migrated as CLOB fields. This will create a huge migration problem
<<<<for me on this one particular database. >>
<<
<<Please send me the DBISAM tables that are having this issue, and I'll
<<look into it.

I will WinZip them up and send them to the support email address.

Regards,
Jan

Jan,

<< See above... >>

Sorry about that - I misread what you were originally saying.  If you want
to have a user administration-only type of utility, then for now you'll have
to write your own.  I'll also see about possibly adding a special "user
administrator" role that will only be allowed to administer users and roles,
and not do any other maintenance stuff.  That's basically what you want,
correct ?

<< Discrepancy: Whenever I scroll down to the end of a table and then try to
scroll back up again...I cannot. The scroll bar goes to the top but
the record is not the first record. I have to scroll back to the far left
(first column) then up to get to the first record. >>

I'm not seeing this here.  Does it happen with a specific table, or all
tables ?  Either way, if you could send me the table in question it may
help.

<< I will WinZip them up and send them to the support email address. >>

Thanks.

--
Tim Young
Elevate Software
www.elevatesoft.com

Tim Young [Elevate Software] wrote:

<<Jan,
<<Sorry about that - I misread what you were originally saying.  If you
<<want to have a user administration-only type of utility, then for now
<<you'll have to write your own.  I'll also see about possibly adding a
<<special "user administrator" role that will only be allowed to
<<administer users and roles, and not do any other maintenance stuff.
<<That's basically what you want, correct ?

Yes...pretty much. I want to make sure that an end-user DB
administrator can administer users and roles but not try to add indices
or end up deleting a field (even by accident), etc.

<<<< Discrepancy: Whenever I scroll down to the end of a table and then
<<<<try to scroll back up again...I cannot. The scroll bar goes to the
<<<<top but
<<the record is not the first record. I have to scroll back to the far
<<left (first column) then up to get to the first record. >>
<<
<<I'm not seeing this here.  Does it happen with a specific table, or
<<all tables ?  Either way, if you could send me the table in question
<<it may help.

All tables. Table has been sent.

Regards,
Jan