Some questions

Hi,

First of all, congratulations for the optimal job!

I have some questions about NexusDB:

- I haven't seen anything about the transport protocol "single user" (FF2
windows messages), that I use a lot when I connect to an embedded server
from a dll. This protocol works fine even in old PCs with win95 stand alon
without installing TCP protocol.

- When I create a table with EM I can't find the Encript data flag.

- I've tried to use UNION in SQL even if I can't find it in the Reference.
Il works, but I get two different results:

select * from testtable
-> 2 records

select * from testtable union select * from testtable
-> 6 records ?!

(select * from testtable union select * from testtable)
-> 4 records

(select * from testtable) union (select * from testtable)
-> 6 records ?!

- About EM: If I open two cursors on the same table and I move between the
records, the two windows just opened are "synchronized". Why?


I've found a small mistake on the SQL Reference in the CREATE INDEX rule:

CREATE [UNIQUE] INDEX <index_name> ON ( <table_name> <index> [, <index>
....])

^ the parenthesis doesn't go here, but after

Best Regards
Pierantonio Bovo

"Pierantonio Bovo" <bovo@bludata.com> wrote in message
news:3f0d892a@wic040d....
> - I've tried to use UNION in SQL even if I can't find it in the
Reference.
> Il works, but I get two different results:
>
> select * from testtable
> -> 2 records
>
> select * from testtable union select * from testtable
> -> 6 records ?!
>
> (select * from testtable union select * from testtable)
> -> 4 records
>
> (select * from testtable) union (select * from testtable)
> -> 6 records ?!

"?!" indeed! Can I borrow the table, pls?

> I've found a small mistake on the SQL Reference in the CREATE INDEX
rule:
>
> CREATE [UNIQUE] INDEX <index_name> ON ( <table_name> <index> [,
<index>
> ...])
> ^ the parenthesis doesn't go here, but after

Good one. If Naomi doesn't see it here I'll make sure she's made aware.

- Per