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

Showing results 1 to 50 of 86
Search took 0.01 seconds.
Search: Posts Made By: obeltrami
Forum: nexusdb.public.support 15th March 2020, 07:10 PM
Replies: 2
Views: 84
Posted By obeltrami
Enterprise Manager: taSqlHistoryPost: Cannot modify a read-only dataset

The Enterprise Manager saves some system tables in a crazy folder such as

C:\ProgramData\NexusDB4\Enterprise Manager\D%3A%5CQ%2B%2BServerXV4%5CDbEngine%5C\

This seems to be due to a hack in the...
Forum: nexusdb.public.support 15th January 2020, 08:42 PM
Replies: 2
Views: 257
Posted By obeltrami
Thank you very much.

Thank you very much.
Forum: nexusdb.public.support 14th January 2020, 04:26 AM
Replies: 2
Views: 257
Posted By obeltrami
nxRemoteServerEngine.Transport.ActualBytesReceived

Hello,

I am using the nxRemoteServerEngine.Transport.ActualBytesReceived and related values to log network traffic, and it works really nicely.

However, I am starting to suspect that I...
Forum: nexusdb.public.support 5th May 2019, 10:17 PM
Replies: 3
Views: 536
Posted By obeltrami
Thank you very much !

Thank you very much !
Forum: nexusdb.public.support 4th May 2019, 11:13 PM
Replies: 3
Views: 536
Posted By obeltrami
Does EM work with Embedded Free Rio 10.3

Hello,

Does EM work with Embedded Free Rio 10.3 ?
It gets installed, but then I cannot see how to access the tables, as there are no aliases.
Trying to help someone (personally I use the paid C/S...
Forum: nexusdb.public.support.sql 16th March 2019, 02:34 PM
Replies: 11
Views: 2,038
Posted By obeltrami
Thank you Roberto and Eivind. I'll try the user...

Thank you Roberto and Eivind.
I'll try the user creation code.
Forum: nexusdb.public.support.sql 15th March 2019, 04:29 PM
Replies: 11
Views: 2,038
Posted By obeltrami
Hi Thorsten, Thank you very much for your...

Hi Thorsten,

Thank you very much for your reply.

I currently do not use accounts. Is there a basic built-in read-only account (similar to the Windows guest account) ?

If not, how can I create it...
Forum: nexusdb.public.support.sql 15th March 2019, 01:41 AM
Replies: 11
Views: 2,038
Posted By obeltrami
Readonly Query

Hi,

In my app I am adding a form where users can add free-style SQL to query aspects of the data that I might not have thought of (actually, I might be the one using this feature the most).

But I...
Forum: nexusdb.public.support 5th December 2018, 01:04 AM
Replies: 7
Views: 1,035
Posted By obeltrami
See my separate post from a few minutes ago.

See my separate post from a few minutes ago.
Forum: nexusdb.public.support 5th December 2018, 12:55 AM
Replies: 5
Views: 808
Posted By obeltrami
Delphi 1.0.3 exception with Field.AsString

Hello,

I am also getting a problem with Field.AsString in Delphi 10.3 and Nexus 4.5008, while Delphi 10.2 (also using Nexus 4.5008) runs fine.

The problem seems to be that the file nxDefineJedi.inc...
Forum: nexusdb.public.support 3rd December 2018, 06:05 PM
Replies: 7
Views: 1,035
Posted By obeltrami
Any news on this ? Should I hold off moving to...

Any news on this ?
Should I hold off moving to 10.3 ?

Olivier
Forum: nexusdb.public.support 26th November 2018, 08:21 PM
Replies: 2
Views: 801
Posted By obeltrami
No, I had not tried to run the 4.5005 updater. I...

No, I had not tried to run the 4.5005 updater.
I will wait for the official updater.
Thank you very much,

Olivier
Forum: nexusdb.public.support 26th November 2018, 04:00 PM
Replies: 2
Views: 801
Posted By obeltrami
The latest source version already supports Rad Studio 10.3 Rio

Hi,

Last week I received an email stating that the latest source version already supports Rad Studio 10.3 Rio, but looking at the downloads area I only see version 4.5005 from last October.

The...
Forum: nexusdb.public.support 4th November 2018, 04:17 PM
Replies: 12
Views: 1,483
Posted By obeltrami
Great ! Thank you very much.

Great !
Thank you very much.
Forum: nexusdb.public.support 2nd November 2018, 03:38 AM
Replies: 12
Views: 1,483
Posted By obeltrami
Great, thank you very much. One last question,...

Great, thank you very much.

One last question, is this something managed at the client end ?

That is to say, when I read the value of ActualBytesSent, for example, is this info already available at...
Forum: nexusdb.public.support 31st October 2018, 05:22 PM
Replies: 12
Views: 1,483
Posted By obeltrami
I meant - Bytes sent/received - Messages...

I meant

- Bytes sent/received
- Messages sent/received

Could these be measured at the client end ?
Forum: nexusdb.public.support 26th October 2018, 11:52 PM
Replies: 12
Views: 1,483
Posted By obeltrami
Could these stats be gleaned on the client side ?

Could these stats be gleaned on the client side ?
Forum: nexusdb.public.support 18th October 2018, 02:57 AM
Replies: 12
Views: 1,483
Posted By obeltrami
Thank you very much. SQL-only suits me fine. Any...

Thank you very much.

SQL-only suits me fine.
Any plans to add:

? Bytes sent/received
? Messages sent/received

Very best regards,
Forum: nexusdb.public.support 18th October 2018, 12:20 AM
Replies: 12
Views: 1,483
Posted By obeltrami
Per Sessions Statistics

Hi,

This new feature (Per Sessions Statistics) seems quite interesting, but I cannot find any information on it. All the website links point to the v.3 PDF. I know that the updater installs the PDF...
Forum: nexusdb.public.support.sql 26th July 2018, 08:50 PM
Replies: 3
Views: 1,266
Posted By obeltrami
When I try to add a column to a primary index...

When I try to add a column to a primary index with the code below, all works well, except that the index which was DEFAULT before being dropped is no longer default (the sequential index now is).

if...
Forum: nexusdb.public.support.sql 25th July 2018, 04:55 AM
Replies: 3
Views: 1,266
Posted By obeltrami
Adding Column to Primary Index

Hi,

I need to use SQL to add an existing column (integer) to an existing primary index.

Is the only way to drop the index and the recreate it ? Or is there a better way ? Anything to be wary of in...
Forum: nexusdb.public.support 28th June 2018, 08:08 AM
Replies: 3
Views: 767
Posted By obeltrami
Hi Thorsten, Thank you for your response. I...

Hi Thorsten,

Thank you for your response. I think I may have given too much details; my question was really just whether it was OK to call Append on a CachedDataSet. I take it from your response...
Forum: nexusdb.public.support 26th June 2018, 07:27 PM
Replies: 3
Views: 767
Posted By obeltrami
Cannot Append to a TnxCachedDataSet ?

Hello,

I am trying to keep track of modified records in a TnxCachedDataSet to avoid always querying the server who is thousands of miles away.

When the app starts I open nxCDSModifiedCountries (a...
Forum: nexusdb.public.support 17th June 2018, 08:48 PM
Replies: 2
Views: 826
Posted By obeltrami
Thank you very much.

Thank you very much.
Forum: nexusdb.public.support 17th June 2018, 08:17 PM
Replies: 2
Views: 826
Posted By obeltrami
Mixing 4.1302 and 4.5003

Hi,

I have (finally) had the time to upgrade my setup from 4.1302 to 4.5003. All went smoothly at my end.

But I am wondering about my users.

For a while they will have 4.5003 executables...
Forum: nexusdb.public.support 22nd April 2018, 05:42 PM
Replies: 9
Views: 1,255
Posted By obeltrami
Thank you. I am planning to move to Delphi...

Thank you.

I am planning to move to Delphi 10.2.3 this summer, when things are more quiet, at the same time as I move from Nexus 4.13.02 to 4.5 to take advantage of ExecSQL not asking for a...
Forum: nexusdb.public.support 22nd April 2018, 09:42 AM
Replies: 9
Views: 1,255
Posted By obeltrami
I have used NexusDB version 4, including my own...

I have used NexusDB version 4, including my own modified and recompiled server, with Delphi 10 Seattle, 10.1 Berlin and 10.2.2 Tokyo, and have not encountered any particular issues (apart from some...
Forum: nexusdb.public.support 21st March 2018, 06:37 AM
Replies: 2
Views: 931
Posted By obeltrami
:) Thank you very much. Olivier

:)

Thank you very much.

Olivier
Forum: nexusdb.public.support 20th March 2018, 05:33 PM
Replies: 2
Views: 931
Posted By obeltrami
Version 4.5 revision: 3695

Hi,

There was a mention of Version 4.5 revision: 3695 in the bug tracking system. Any timeline ?

Very best regards,

Olivier
Forum: nexusdb.public.support 18th March 2018, 02:28 AM
Replies: 1
Views: 716
Posted By obeltrami
TnxRemoteServerEngine.Exclusive

Hi,

Is there a way to make the access of a user to a TnxRemoteServerEngine Exclusive as can be done for a TNxDatabase ?

During some updates of my app I'd like to make sure that no one else is...
Forum: nexusdb.public.support.sql 23rd January 2018, 08:39 PM
Replies: 2
Views: 1,187
Posted By obeltrami
Hi Michael, Looks like what I need. I'll give it...

Hi Michael,

Looks like what I need.
I'll give it a try.

Thank you very much,

Olivier
Forum: nexusdb.public.support.sql 23rd January 2018, 04:33 PM
Replies: 2
Views: 1,187
Posted By obeltrami
Extending JOIN to Multiple Columns

Hi,

I am using the following SQL to delete rows from one table that also exist in another table as ID_Holiday is the unique key.

DELETE FROM Data."HolRules"
WHERE "ID_Holiday" IN (SELECT DISTINCT...
Forum: nexusdb.public.support 23rd January 2018, 12:38 AM
Replies: 15
Views: 2,149
Posted By obeltrami
The problem was the "Default Style". I changed it...

The problem was the "Default Style".
I changed it to "Bue Dream" and now all is well.
I can now read the Newsgroup again.

Thank you, thank you, thank you, thank you, thank you !

Olivier
Forum: nexusdb.public.support 17th January 2018, 06:22 PM
Replies: 15
Views: 2,149
Posted By obeltrami
Probably since the Newsgroup is loaded in a...

Probably since the Newsgroup is loaded in a different framework depending on the PC I use.

My question is, how can I force the loading of the Newsgroup in the "Nexus" UI rather than the "vBulletin"...
Forum: nexusdb.public.support 17th January 2018, 04:20 PM
Replies: 15
Views: 2,149
Posted By obeltrami
That's the point. Until recently, I had never...

That's the point. Until recently, I had never seen the vBulletin interface (or at least the logo). The Newsgroup just appeared with the Nexus logo and header.

I was able to get the old UI back on an...
Forum: nexusdb.public.support 15th January 2018, 04:19 PM
Replies: 15
Views: 2,149
Posted By obeltrami
The image I uploaded was shrunk by...

The image I uploaded was shrunk by vBulletin.
Attached is a zip of that image.
Forum: nexusdb.public.support.sql 15th January 2018, 02:49 PM
Replies: 15
Views: 3,295
Posted By obeltrami
Is this something I could modify in the source...

Is this something I could modify in the source code myself ?

I would really like to implement this as soon as possible as a lot of my code uses ExecSQL instead of Open hoping for minimized network...
Forum: nexusdb.public.support 15th January 2018, 02:45 PM
Replies: 15
Views: 2,149
Posted By obeltrami
Getting the old Newsgroup UI back ?

Is there a way to get the old Newsgroup UI back ?

A few weeks ago came this new "vBulletin" interface an it makes it really hard to read posts as lines are not wrapped, but rather trimmed, and an...
Forum: nexusdb.public.support.sql 21st December 2017, 12:55 AM
Replies: 15
Views: 3,295
Posted By obeltrami
Thank you very much for the "under the hood"...

Thank you very much for the "under the hood" explanations, it really helps me when deciding on the approach to given tasks.

The issue is now tracked as ID 0002151.
Forum: nexusdb.public.support.sql 20th December 2017, 08:52 AM
Replies: 15
Views: 3,295
Posted By obeltrami
I ran a test on the Query given in my post of...

I ran a test on the Query given in my post of "9th December 2017 04:41 PM" and, here, the StoredProc approach took about 35% longer (even though the procedure had already bee registered before on the...
Forum: nexusdb.public.support.sql 10th December 2017, 04:32 PM
Replies: 15
Views: 3,295
Posted By obeltrami
OK. I'll try to convert the one that is the most...

OK. I'll try to convert the one that is the most time consuming and see what happens.

Thank you very much for your help on a weekend (and in general).
Forum: nexusdb.public.support.sql 10th December 2017, 01:41 AM
Replies: 15
Views: 3,295
Posted By obeltrami
I guess, before I start converting some of my...

I guess, before I start converting some of my queries to StoredProcs, I'd be interested to know if you think there's be a gain in speed (over slow internet lines with moderate latency issues) in...
Forum: nexusdb.public.support.sql 9th December 2017, 08:34 PM
Replies: 15
Views: 3,295
Posted By obeltrami
Thank you very much for your detailed...

Thank you very much for your detailed explanations. I really appreciate it.
Forum: nexusdb.public.support.sql 5th December 2017, 07:46 AM
Replies: 15
Views: 3,295
Posted By obeltrami
Also, there does not seem to be any way to define...

Also, there does not seem to be any way to define the stored procedure in TnxStoredProc. Does the code in the top half of that post have to be entered via a TxnQuery, before using a TnxStoredProc ?
Forum: nexusdb.public.support.sql 5th December 2017, 07:32 AM
Replies: 15
Views: 3,295
Posted By obeltrami
Thank you very much. I had seen that post but...

Thank you very much.

I had seen that post but did not really understand it.

Why are there MyCustomFunction and MyCustomProcedure ? Are both needed ?

Assuming that MyCustomFunction is not relevant...
Forum: nexusdb.public.support.sql 5th December 2017, 01:20 AM
Replies: 15
Views: 3,295
Posted By obeltrami
Using TnxStoredProc and Output Parameters

Hi,

Over a slow internet connection, the function below takes a couple of seconds. Not the end of the world, but I am trying to optimize.

My question is, as all I want back from the SQL, is a...
Forum: nexusdb.public.support.qualitysuite 4th December 2017, 03:30 AM
Replies: 4
Views: 2,484
Posted By obeltrami
Hi Eivind, Thank you for the prompt...

Hi Eivind,

Thank you for the prompt response.
Solved the problem.

How do I go about logging an issue ?

Very best regards,

Olivier
Forum: nexusdb.public.support.qualitysuite 3rd December 2017, 12:32 PM
Replies: 4
Views: 2,484
Posted By obeltrami
BTW: I am also able to use the 64-bit Block...

BTW: I am also able to use the 64-bit Block Profiler, no problems there either.
Problem seems limited to the Line Profiler.
Forum: nexusdb.public.support.qualitysuite 3rd December 2017, 12:15 PM
Replies: 4
Views: 2,484
Posted By obeltrami
Unable to execute LineTimer64.exe "...\myapp.exe" (Error 2)

Hi,

I have just downloaded the trial version of Quality suite 1.61 and installed it into Delphi 10.1 Berlin (with all patches) running on Windows 7 (with all patches).

I am able to run the 64-bit...
Forum: nexusdb.public.support 15th November 2017, 08:52 PM
Replies: 8
Views: 2,419
Posted By obeltrami
Thnak you very much. Sounds great. Can you give...

Thnak you very much. Sounds great.

Can you give me an idea in a nutshell of the work involved on my part to convert my current C/S setup using NexusDB to use the RemoteDB (components to...
Showing results 1 to 50 of 86

 
Forum Jump

All times are GMT +11. The time now is 10:13 AM.


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