#1  
Old 11th July 2003, 03:39 AM
Pierantonio Bovo
 
Posts: n/a
Default 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


  #2  
Old 11th July 2003, 04:35 AM
Per Larsen [NDX]
 
Posts: n/a
Default Re: Some questions


"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




Thread Tools
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

vB code is On
Smilies are On
[IMG] code is On
HTML code is Off
Forum Jump

Similar Threads
Thread Thread Starter Forum Replies Last Post
Some Questions Danijel Tkalcec nexusdb.public.support.portal 2 3rd October 2009 12:46 AM
Some questions Alessandro Romano nexusdb.public.support.thirdparty 10 6th August 2005 03:36 AM
Questions... Curt nexusdb.public.support.odbc 1 30th May 2004 09:57 AM
Some SQL questions Stefan Paege nexusdb.public.support.sql 3 6th February 2004 12:45 AM
Questions Lee nexusdb.public.discussions 9 1st October 2003 12:00 PM


All times are GMT +11. The time now is 10:33 PM.


Powered by vBulletin® Version 3.6.8
Copyright ©2000 - 2021, Jelsoft Enterprises Ltd.