Go Back   NexusDB Newsgroups > Search Forums
Log in
FAQ Members List Calendar Search Today's Posts Mark Forums Read

Showing results 1 to 10 of 10
Search took 0.00 seconds.
Search: Posts Made By: jhoehne
Forum: nexusdb.public.support.sql 22nd January 2021, 03:49 AM
Replies: 1
Views: 165
Posted By jhoehne
Re: Update table from several tables

There is a SQL standard for this: MERGE

MERGE INTO dest_tab tt
USING source_tab st
ON tt.id = st.id
WHEN MATCHED THEN
UPDATE SET tt.code = st.code, tt.description = st.description

It would...
Forum: nexusdb.public.support 28th August 2018, 07:12 PM
Replies: 4
Views: 1,348
Posted By jhoehne
Re: Integrity of tables in database..

Couldn't you simply use the monitor/extender feature mentioned in the documentation? (see "How to create a monitor/extender" in the NexusDB manual). This seems to me like a "clean" approach to the...
Forum: nexusdb.public.support 27th July 2018, 12:22 AM
Replies: 3
Views: 1,596
Posted By jhoehne
Ah! I've set only "ServerNameDesigntime" and...

Ah! I've set only "ServerNameDesigntime" and thought this will be used at runtime too if I leave ""ServerNameRuntime" blank.
With "ServerNameRuntime" set to "NexusDB@127.0.0.1" too it takes only 22...
Forum: nexusdb.public.support 26th July 2018, 02:29 AM
Replies: 3
Views: 1,596
Posted By jhoehne
Connecting speed

Hello,

connecting to a database on the same machine via TCP/IP takes approx. 3 seconds. Is this a normal connection time?

I made a small test program, only nxRemoteServerEngine, nxWinsockTransport,...
Forum: nexusdb.public.support.sql 12th July 2018, 02:09 AM
Replies: 4
Views: 2,173
Posted By jhoehne
Re: SQL statement exclude items that CONTAIN a substring

With FoxPro-"SQL" you can do some pretty special stuff, e.g. a query using aggregates, where the "group by" clause doesn't contain all grouping fields:

select count(*), field1, field2 from...
Forum: nexusdb.public.discussions 20th June 2018, 03:25 AM
Replies: 2
Views: 1,833
Posted By jhoehne
The last Delphi version which included a CORBA...

The last Delphi version which included a CORBA implementation (VisiBroker) was Delphi 7.
Forum: nexusdb.public.support 7th June 2018, 02:38 AM
Replies: 6
Views: 2,642
Posted By jhoehne
Thumbs up Re: Trial installation (4.5003) asks for "extended id"

...but if I type in my email they send me an ID. Thx folks, well done!
Forum: nexusdb.public.support 7th June 2018, 01:37 AM
Replies: 6
Views: 2,642
Posted By jhoehne
Trial installation (4.5003) asks for "extended id"

Somebody at NexusDB just uploaded a newer version (4.5003) of the trial installation. I tried it, but no luck. This newer version also asks for "customer email" and "extended ID"...
Forum: nexusdb.public.support 2nd May 2018, 07:14 PM
Replies: 6
Views: 2,642
Posted By jhoehne
When can I expect the new version?

When can I expect the new version?
Forum: nexusdb.public.support 10th April 2018, 07:05 PM
Replies: 6
Views: 2,642
Posted By jhoehne
Trial installation (4.5002) asks for "extended id"

Hello,

I tried to install the current trial version of NexusDB, but it asks for "customer email" and "extended ID", which I don't have. If I leave the fields blank, I can't get any...
Showing results 1 to 10 of 10

 
Forum Jump

All times are GMT +11. The time now is 05:43 AM.


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