headers
Donato Marro | 20 Aug 2005 22:35
Picon
Picon

McKoiDB and Schemes

Hello,

i'm running the McKoiDB 1.0.3 on my local system (WinXP, JDK 1.5.0_03).
The complete DB-Data was converted from McKoiDB 0.93b.

Now when accessing the DB with DbVisualizer 4.3.3, I can only
see the schemes APP, SYS_INFO, SYS_JDBC, but not the schema previously
created in the old DB. Anyway I can access this schema by connecting
to jdbc:mckoi://localhost:9157/myschema/ or by referring the tables
through myschema.<TABLE_NAME>.
When creating a new schema (myschema2) and reconneting to the DB,
DbVisualizer shows me the schemes APP, SYS_INFO, SYS_JDBC and myschema2.

So why can I see the schemes created on McKoiDB 1.0.3 only, but not
my old (existing) schema?

Greetings,
Donato Marro

---------------------------------------------------------------
Mckoi SQL Database mailing list  http://www.mckoi.com/database/
To unsubscribe, send a message to mckoidb-unsubscribe <at> mckoi.com
Permalink | Reply | 0 comments |
headers
Grégoire Dubois | 22 Aug 2005 22:27
Picon

SELECT with LIMIT

Hi all,

Is there any solution to use something like LIMIT in a SELECT query in
Mckoi ?

In MySQL for example, it's like : [LIMIT {[offset,] row_count |
row_count OFFSET offset}]. Is there something like this ? If not, is
that planned to be implemented ?

Thank you very much.
Grégoire

---------------------------------------------------------------
Mckoi SQL Database mailing list  http://www.mckoi.com/database/
To unsubscribe, send a message to mckoidb-unsubscribe <at> mckoi.com
Permalink | Reply | 0 comments |
headers
James | 25 Aug 2005 01:20
Picon
Favicon

RE: SELECT with LIMIT

Following message is from a couple years ago:

http://mckoi.com/database/mail/subject.jsp?id=5942&highlight=rownum+#MSG_5943

---------------------------------------------------------------
Mckoi SQL Database mailing list  http://www.mckoi.com/database/
To unsubscribe, send a message to mckoidb-unsubscribe <at> mckoi.com
Permalink | Reply | 0 comments |

Gmane