Go Back   NexusDB Newsgroups > Search Forums
Reload this Page Search Results
Log in
FAQ Members List Calendar Today's Posts

Page 1 of 2 1 2 >
Showing results 1 to 50 of 55
Search took 0.02 seconds. Search: Posts Made By: ericus
Forum: nexusdb.public.support.qualitysuite 4th December 2024, 07:20 PM
Replies: 1
Views: 6,266
Posted By ericus
Qualitysuite

Hi

I just bought Qualitysuite with your black Friday special. I am using it with Delphi 10.2 (Tokyo).

Everything installs fine and under my Delphi Tools menu I find a heap of new options.

Where...
Forum: nexusdb.public.support 23rd October 2024, 06:45 PM
Replies: 7
Views: 2,603
Posted By ericus
Good morning i spoke to soon. I have 2...

Good morning

i spoke to soon. I have 2 problems. The guys from AQB either don't exist anymore because they don't reply to any messages, and two, I cannot see how to incorporate only the AQB...
Forum: nexusdb.public.support 21st October 2024, 07:00 PM
Replies: 7
Views: 2,603
Posted By ericus
Thanks very much. Life saver.

Thanks very much. Life saver.
Forum: nexusdb.public.support 21st October 2024, 05:10 PM
Replies: 7
Views: 2,603
Posted By ericus
NexusDB Query Builder

Good day

This is a stab in the dark but has anyone developed something like a query builder for NexusDB? I would like something similar to Microsoft Query Builder where the user can select a couple...
Forum: nexusdb.public.support 3rd October 2024, 04:20 AM
Replies: 13
Views: 3,674
Posted By ericus
My question was badly formulated. Why can I not...

My question was badly formulated.

Why can I not work in my application accessing data on the server, and open the same data in Enterprise Manager at the same time.

The reverse is also true. If I...
Forum: nexusdb.public.support 2nd October 2024, 09:52 PM
Replies: 13
Views: 3,674
Posted By ericus
Enterprise Manager

Good day

Why can I not create new Aliases or work in tables of an existing alias with the Enterprise Manager on the server?

Regards



Ericus
Forum: nexusdb.public.support.sql 16th June 2024, 12:56 AM
Replies: 3
Views: 13,515
Posted By ericus
Thank you very much for your reply. The query is...

Thank you very much for your reply. The query is probably quite simple if all the components are on the same form.

However the #MemTable is on one form, and so it the nxQuery component. The query...
Forum: nexusdb.public.support.sql 15th June 2024, 08:21 PM
Replies: 3
Views: 13,515
Posted By ericus
UPDATE Query

I am using an #INMEM table and want to update some fields from another regular Nexus table.

UPDATE tnxImportData t1
JOIN plmcontr t2 ON t1.AccountID = t2.AccountID
SET t1.CustomerCode =...
Forum: nexusdb.public.support 29th February 2024, 08:21 PM
Replies: 1
Views: 3,725
Posted By ericus
nxServerEngine multi user access

Good morning

I use nxServerEngine for some local tables in the application directory.

My client now moved to a cloud server and I don't think all the users can access those local files at the same...
Forum: nexusdb.public.support 28th October 2023, 09:33 PM
Replies: 6
Views: 5,193
Posted By ericus
Hallo Elvind I appreciate your time and I am...

Hallo Elvind

I appreciate your time and I am happy it works on your machine. I need it to work on my machine.

When I said'same error' it is the same error as on my first post. The full error is...
Forum: nexusdb.public.support 27th October 2023, 08:05 PM
Replies: 6
Views: 5,193
Posted By ericus
Hallo Elvind That's what I don't understand. ...

Hallo Elvind

That's what I don't understand. 32-bit project, Delphi 10.2 is 32 bit itself, on startup is shows NexusDB 32 bit installed so why the path...
Forum: nexusdb.public.support 26th October 2023, 10:43 PM
Replies: 6
Views: 5,193
Posted By ericus
Unit nxdb not found

Good day

New machine with a hard drive with my Delphi Tokyo installation and all projects.

Howwever I had to reinstall Delphi and all other components.

Removed the NexusDB folder and reinstalled...
Forum: nexusdb.public.support 4th September 2023, 11:28 PM
Replies: 4
Views: 4,760
Posted By ericus
NexusDB and Firedac

Good day

I notice messages since 2015 about NexusDB inclusion in Firedac.

Is this going to happen?

Thanks in advance


Ericus Steyn
Forum: nexusdb.public.support.sql 27th July 2023, 06:36 PM
Replies: 5
Views: 15,222
Posted By ericus
CAST(SUM(Amount) as VarChar)

Good morning

I am trying to get SUM(Amount) to be displayed with 2 decimals.

I know I must CAST it but I cannot get the correct syntax.

Please help me.


Ericus Steyn
Forum: nexusdb.public.support 30th June 2023, 09:46 PM
Replies: 5
Views: 10,624
Posted By ericus
Elvind in the real world it is not that...

Elvind in the real world it is not that simple.

As an example an accounting system to do the books for different companies. Every set of accounts are in a different folder and located on the...
Forum: nexusdb.public.support 29th June 2023, 06:37 PM
Replies: 5
Views: 10,624
Posted By ericus
Thank you Elvind. Selecting the server is a bit...

Thank you Elvind.

Selecting the server is a bit more tricky. The user has a file open dialog so then might select P:\PASTEL19 which is probably on a server.

However, the data can also be on the...
Forum: nexusdb.public.support 29th June 2023, 12:13 AM
Replies: 5
Views: 10,624
Posted By ericus
Which nxServer to use?

My users can connect to data on either their local machines or to data on a server.

They select the data on start-up of the application.

How do I make sure that the local nxserver is used when...
Forum: nexusdb.public.support 28th June 2023, 01:22 AM
Replies: 11
Views: 16,287
Posted By ericus
Thanks again Elvind. You want me to purchase...

Thanks again Elvind.

You want me to purchase another Windows license to install a VM. Then download a Github application, install that, and do remote logging of the Delphi application to...
Forum: nexusdb.public.support 27th June 2023, 06:38 PM
Replies: 11
Views: 16,287
Posted By ericus
Can someone please take a wild stab at what the...

Can someone please take a wild stab at what the problem could be?

The error is described in the Help file.


DBIERR_INVALIDPARAM 9986 $2702 Invalid parameter.

Maybe that means something to someone....
Forum: nexusdb.public.support 26th June 2023, 09:17 PM
Replies: 11
Views: 16,287
Posted By ericus
Thanks Elvind but to do all things that you...

Thanks Elvind but to do all things that you suggest is like another steep learning curve for me.

My application deployed 100% correct in the past. I now created a simple app with a scaled down...
Forum: nexusdb.public.support 26th June 2023, 06:08 PM
Replies: 11
Views: 16,287
Posted By ericus
Two weeks later and I am no closer to deploying...

Two weeks later and I am no closer to deploying an application.

I am stepping through the code that has always deployed perfectly and the application fails when the RemoteSession is activated.

So...
Forum: nexusdb.public.support 21st June 2023, 05:56 PM
Replies: 1
Views: 9,155
Posted By ericus
Apologies. Solved. I was connecting to Internal...

Apologies. Solved. I was connecting to Internal Server
Forum: nexusdb.public.support 21st June 2023, 05:51 PM
Replies: 11
Views: 16,287
Posted By ericus
Why would the application work on the development...

Why would the application work on the development computer and not when deployed? I don't see how going through the callstack is going to help.
Forum: nexusdb.public.support 21st June 2023, 05:49 PM
Replies: 1
Views: 9,155
Posted By ericus
Alias Tables could not be opened

Good morning

I would assume that on any Alias created I can use the Enterprise Manager to open the tables in the dataset and do whatever I want.

However when I double-click the Tables folder in any...
Forum: nexusdb.public.support 12th June 2023, 10:37 PM
Replies: 11
Views: 16,287
Posted By ericus
Remote Session Error

Good day

Deployment of my app with Nexus has normally gone smoothly.

Now I get the Remote Session Error regardless of deploying the data and NexusDB on a local machine, or where NexusDB runs on the...
Forum: nexusdb.public.support.sql 8th April 2023, 05:13 PM
Replies: 3
Views: 16,224
Posted By ericus
There are 2 ways to look at the below...

There are 2 ways to look at the below requirement:

Select * from PlmMasd LEFT JOIN PlmTrn on PlmTrn.AccountNumber = PlmMasd.CustomerCode

OR

Using the below query and substituting
FROM Plmtrn...
Forum: nexusdb.public.support.sql 7th April 2023, 06:28 PM
Replies: 3
Views: 16,224
Posted By ericus
SQL Row Number follow up

I did not state my requirements exactly. SYSTEM_ROW# is not of any help to me.

The requirements is for every change in the master file record to start the numbering of the detail records at 1.

As...
Forum: nexusdb.public.support.sql 6th April 2023, 11:35 PM
Replies: 1
Views: 13,867
Posted By ericus
SQL Row Number

Hi

I have no idea why I cannot edit my previous post but in any case I managed to get this far in trying to display a row number for each row of my result set.

CREATE FUNCTION RowNumber ()
RETURNS...
Forum: nexusdb.public.support.sql 6th April 2023, 11:04 PM
Replies: 1
Views: 13,618
Posted By ericus
Row_number

I need to get the row number of my sql result set.

Does anyone have an idea how I can do that?

Maybe I am missing something.


Ericus Steyn
Forum: nexusdb.public.support 3rd November 2022, 05:25 PM
Replies: 0
Views: 4,360
Posted By ericus
Yodlee Integration

Good day

For lack of a successful search across the internet I will ask here.

Has anybody managed to integrate to Yodlee from Delphi and are you prepared to share some pointers on how to do...
Forum: nexusdb.public.support 17th May 2021, 05:04 PM
Replies: 2
Views: 4,908
Posted By ericus
Thread creation error - Winsock Transport

Good day

My one application must run on the server as a service.

The code below works on some servers but not others. No idea why. I think I got the code from somewhere here on the...
Forum: nexusdb.public.support 6th May 2021, 01:37 AM
Replies: 1
Views: 4,089
Posted By ericus
BuildandEvolve Database ReadOnly

Good afternoon

I have been using BuildandEvolve to create and restructure tables.

Now, on a new server installation, when running my application for the first time I get the exception DataBase...
Forum: nexusdb.public.support 20th June 2020, 04:01 AM
Replies: 3
Views: 5,705
Posted By ericus
You are right Thorsten. It was not 2 seconds. ...

You are right Thorsten. It was not 2 seconds. It was 10.

I do in 2 what other people normally do in 10.

Thanks for the assistance.
Forum: nexusdb.public.support 18th June 2020, 03:28 PM
Replies: 3
Views: 5,705
Posted By ericus
Delphi Debug and DB Connection closed

Good day

When debugging in Delphi and stepping through the code my connection to NexusDB is closed after barely a second or two. That makes debugging extremely difficult.

NexusDB is running on my...
Forum: nexusdb.public.support 1st November 2019, 07:01 PM
Replies: 5
Views: 6,183
Posted By ericus
Morning John The usual stuff. Some ODBC, some...

Morning John

The usual stuff. Some ODBC, some P.SQL SDK and some proprieatry Btrieve access controls.

Which applications do you use that uses P.SQL? I have developed a complete replacement for...
Forum: nexusdb.public.support 1st November 2019, 02:14 AM
Replies: 5
Views: 6,183
Posted By ericus
Thanks Elvind This Nexus service is as is out of...

Thanks Elvind

This Nexus service is as is out of the box. I would not know how to customise it.

I get to the Pervasive data using other controls.

Regards

Ericus Steyn
Forum: nexusdb.public.support 31st October 2019, 11:44 PM
Replies: 5
Views: 6,183
Posted By ericus
NexusDB as Service with /SETFULLACCESS

Good day

I am following the installation instructions on installing Nexus and creating a user etc. etc.

Last issue I have is with /SETFULLACCESS.

My application interfaces with a SAGE product...
Forum: nexusdb.public.support 19th September 2019, 10:12 PM
Replies: 12
Views: 9,438
Posted By ericus
Off topic

Hi Wolfgang

I see you are in South Africa. Same here. If your clients are using Sage Partner or similar you must email me on let at iafrica dot com.

Maybe I can assist in other...
Forum: nexusdb.public.support 18th September 2019, 04:31 PM
Replies: 5
Views: 6,678
Posted By ericus
Thanks Erin 2 issues solved. When I talk about...

Thanks Erin

2 issues solved.

When I talk about a mapped drive I am talking about a mapped drive from the workstation to the server.

So P: on the local machine is mapped to a shared folder ACCPAC...
Forum: nexusdb.public.support 17th September 2019, 11:05 PM
Replies: 5
Views: 6,678
Posted By ericus
I have now started deploying my application but...

I have now started deploying my application but still a few issues. Maybe somebody else encounter this as well and have a solution:

Issue 1:

Erin you refer to *new user and installation time. ...
Forum: nexusdb.public.support 7th September 2019, 10:34 PM
Replies: 1
Views: 5,381
Posted By ericus
SQL Update 1 table with sum from another table

Good day

I something like this possible in Nexus?

Want to update the QtyInStock in one table, with the QtyPurchased in the same table less the sum(quantity) from another table.

#T 0 UPDATE...
Forum: nexusdb.public.support 29th August 2019, 12:38 AM
Replies: 2
Views: 7,880
Posted By ericus
SQL Functions

Good day

I have a big table containing sales information. Let's say Customer, Date, Value.

I want to use this data to create charts using TeeChart.

AFAIK you cannot do select sum(value) group my...
Forum: nexusdb.public.support 28th August 2019, 08:13 AM
Replies: 2
Views: 4,409
Posted By ericus
Sorry asked and answered. CASE WHEN...

Sorry asked and answered.

CASE WHEN Extract(Month From DocumentDate) >10 then Cast(Extract(Month From DocumentDate) as VarChar(2)) else '0'+Cast(Extract(Month From DocumentDate) as VarChar(2)) END...
Forum: nexusdb.public.support 28th August 2019, 08:04 AM
Replies: 2
Views: 4,409
Posted By ericus
SQL Get padded month from date

Good day

I saw this in one of the threads:

SELECT Cast(Extract(Month From DateArg) as VarChar(2))+' / '+SubString(Cast(Extract(Year From DateArg) as VarChar(4)) FROM xxx

How can I pad the month so...
Forum: nexusdb.public.support 13th August 2019, 04:52 AM
Replies: 5
Views: 5,217
Posted By ericus
Thanks Rodrigo But then the backup must always...

Thanks Rodrigo

But then the backup must always be done to the local machine?

So the nxTrans.cfg is only deleted when all users are disconnected from that alias?

Thanks
Forum: nexusdb.public.support 13th August 2019, 02:36 AM
Replies: 5
Views: 5,217
Posted By ericus
NexusDB Backup

I have already received assistance on how to do the backup of the database through nxBackupDatabase and using the example.

All works fine. An alias is created and the data is backed up to that...
Forum: nexusdb.public.support 13th August 2019, 12:20 AM
Replies: 5
Views: 6,678
Posted By ericus
Nexus Deployment Best Practise

Good day

So I want to deploy NexusServer and include it with my advanced installer.

I have read the manual and see an example of the options:

Example 1:

nxServer.exe /install
Forum: nexusdb.public.support 1st August 2019, 01:30 AM
Replies: 5
Views: 6,281
Posted By ericus
Thanks Rodrigo.

Thanks Rodrigo.
Forum: nexusdb.public.support 1st August 2019, 01:29 AM
Replies: 2
Views: 4,965
Posted By ericus
Backup NexusDB

I have read the manual and understand nxBackupController does a real time backup of one database to another.

What if all I want to do is zip the *.nx files and copy that zip file somewhere else? It...
Forum: nexusdb.public.support 31st July 2019, 07:01 PM
Replies: 5
Views: 6,281
Posted By ericus
Thanks Elvin If I understand correctly. I go to...

Thanks Elvin

If I understand correctly. I go to EM, Data Dictionary Code Generator. Create SQL code only and I use this in my application to create the files if they don't yet exist.

If the files...
Showing results 1 to 50 of 55
Page 1 of 2 1 2 >

 
Forum Jump

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

Contact Us - NexusDB Newsgroups - Top

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