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

Showing results 1 to 36 of 36
Search took 0.02 seconds.
Search: Posts Made By: Andreas Schachtner
Forum: nexusdb.public.support.sql 4th January 2019, 08:14 PM
Replies: 6
Views: 1,072
Posted By Andreas Schachtner
Hi Michaël, thx for this! You made my day!...

Hi Michaël,

thx for this! You made my day! Perfect!
Forum: nexusdb.public.support.sql 4th January 2019, 05:21 PM
Replies: 6
Views: 1,072
Posted By Andreas Schachtner
new featurerequest logged #2233

new featurerequest logged

#2233
Forum: nexusdb.public.support.sql 4th January 2019, 04:57 PM
Replies: 6
Views: 1,072
Posted By Andreas Schachtner
Hello Eivind, the SQL Error is NexusDB:...

Hello Eivind, the SQL Error is

NexusDB: Query218422687: Query execution failed:
Unexpected exception object raised: [EInvalidOp] Invalid floating point operation

[$3CA1/15521]

....wich is fine,...
Forum: nexusdb.public.support.sql 4th January 2019, 03:42 AM
Replies: 6
Views: 1,072
Posted By Andreas Schachtner
This SQL brings an exeption in EM with the Table...

This SQL brings an exeption in EM with the Table in the Attachement.


Select Sum(Coalesce(Dauer,0)),Mitarbeiter from MitarbeiterPflegeNachweis
where Dauer>0
group by Mitarbeiter


Is there a SQL...
Forum: nexusdb.public.support.sql 2nd January 2019, 04:12 AM
Replies: 6
Views: 1,072
Posted By Andreas Schachtner
Change NAN values in Single Field

I have a Table with a single field and in some rows we have NAN values.

How can i set these rows with SQL to another value?
Forum: nexusdb.public.support.sql 11th December 2018, 08:54 PM
Replies: 6
Views: 982
Posted By Andreas Schachtner
see my issue #2194 in the tracker. The new...

see my issue #2194 in the tracker.

The new Sys_ReparseAll () function in 4.5 should repair the wrong stream's in your stored procedures;
Forum: nexusdb.public.support.sql 3rd December 2018, 02:24 AM
Replies: 2
Views: 637
Posted By Andreas Schachtner
Thank you for the explanation. Now i see!

Thank you for the explanation. Now i see!
Forum: nexusdb.public.support.sql 3rd December 2018, 12:11 AM
Replies: 2
Views: 637
Posted By Andreas Schachtner
diffrent Results for Extract (Month/isoMonth from DateArg)

With the following SQL we get different Results for Extract (Month from DateArg) vs. Extract (isoMonth from DateArg) from the Table in the zip-file-Attachement.
I can't reproduce this with other...
Forum: nexusdb.public.support 4th September 2018, 06:16 AM
Replies: 4
Views: 914
Posted By Andreas Schachtner
*push*

*push*
Forum: nexusdb.public.support.sql 5th July 2018, 03:39 AM
Replies: 17
Views: 1,371
Posted By Andreas Schachtner
#0002194 related

#0002194 related
Forum: nexusdb.public.support.sql 31st May 2018, 10:01 PM
Replies: 2
Views: 998
Posted By Andreas Schachtner
Done! Issue #2194

Done!

Issue #2194
Forum: nexusdb.public.support.sql 31st May 2018, 07:03 PM
Replies: 2
Views: 998
Posted By Andreas Schachtner
StoredProc kill's embedded Serverengine in EM

Have this stored proc since V3 and it works. With 4.5 and up it kills the embedded Server in EM and fires Exception in my Program.


In Debug Mode an Assertion comes...
Forum: nexusdb.public.support.sql 14th September 2017, 04:29 PM
Replies: 20
Views: 5,651
Posted By Andreas Schachtner
I can replicate this only in 64-bit EM 4.12.01...

I can replicate this only in 64-bit EM 4.12.01 via the Internal Server (is this also the Tokyo related bug?).

Btw. when can we have a working 32-Bit EM again? Crashes all the time with simple sql...
Forum: nexusdb.public.support 20th April 2017, 05:14 AM
Replies: 8
Views: 2,955
Posted By Andreas Schachtner
EM 64Bit working with the embedded engine and...

EM 64Bit working with the embedded engine and diffrent SQL Selects.
Forum: nexusdb.public.support 20th April 2017, 04:42 AM
Replies: 8
Views: 2,955
Posted By Andreas Schachtner
...same happens on my machine with the embedded...

...same happens on my machine with the embedded engine in EM with every SQL (Select * from Table). Must kill EM in Taskmanager!

I think it's since the Windows 10 Creators Update? Weird!
Forum: nexusdb.public.remoting 9th April 2017, 04:01 PM
Replies: 2
Views: 6,810
Posted By Andreas Schachtner
Hi Thorsten, thank you for you fast reply. Got...

Hi Thorsten,

thank you for you fast reply. Got it working now!

Btw. very nice feature in my beloved NexusDb. Keep up the good work!
Forum: nexusdb.public.remoting 9th April 2017, 06:50 AM
Replies: 2
Views: 6,810
Posted By Andreas Schachtner
Client to Client Remoting

I try to integrate Client to Client Messaging in my Application's.

My Main App act's as Application Server with Embedded ServerEngine. It has a WinSock-Transport for the Communication with the...
Forum: nexusdb.public.support 20th January 2017, 12:09 AM
Replies: 45
Views: 6,286
Posted By Andreas Schachtner
@Rodrigo Gomez: also my 2 cents!

@Rodrigo Gomez: also my 2 cents!
Forum: nexusdb.public.support 1st September 2016, 03:03 AM
Replies: 1
Views: 1,108
Posted By Andreas Schachtner
...done. But don't forget to vote on G.

...done. But don't forget to vote on G.
Forum: nexusdb.public.support 2nd August 2016, 04:52 PM
Replies: 2
Views: 1,409
Posted By Andreas Schachtner
...more than 2 Years later, same Question?

...more than 2 Years later, same Question?
Forum: nexusdb.public.support.sql 3rd February 2016, 03:14 AM
Replies: 15
Views: 1,963
Posted By Andreas Schachtner
Re

You are welcome!
Forum: nexusdb.public.support.sql 2nd February 2016, 04:17 PM
Replies: 15
Views: 1,963
Posted By Andreas Schachtner
Re

UpdateQuery.Params[0].asDate := DateOf(InputQuery.FieldbyName('Date1).asDateTime);
Forum: nexusdb.public.support 9th May 2014, 07:45 AM
Replies: 3
Views: 1,138
Posted By Andreas Schachtner
+1 ....

+1 ....
Forum: nexusdb.public.support.sql 12th April 2014, 04:57 PM
Replies: 2
Views: 1,233
Posted By Andreas Schachtner
Thank's Thorsten, much better to work with.

Thank's Thorsten,

much better to work with.
Forum: nexusdb.public.support.sql 11th April 2014, 05:39 AM
Replies: 2
Views: 1,233
Posted By Andreas Schachtner
Changed behavior of INSERT INTO in V4

This code works since V3.?


insert into "\Vorlagen\xPlan_Dokumente"
Select * from "\Daten\Plan_Dokumente" where Kulturnummer=:KN;


In V4 we get the error-message.

---------------------------
Forum: nexusdb.public.support 11th January 2013, 07:50 PM
Replies: 4
Views: 1,450
Posted By Andreas Schachtner
@Stefan Paege A big THANK YOU for this link. You...

@Stefan Paege

A big THANK YOU for this link. You made my day!
Forum: nexusdb.public.support 17th September 2012, 11:39 PM
Replies: 2
Views: 1,411
Posted By Andreas Schachtner
Thanks for the update, enjoy your holiday.

Thanks for the update, enjoy your holiday.
Forum: nexusdb.public.support 27th March 2012, 04:26 PM
Replies: 8
Views: 2,096
Posted By Andreas Schachtner
done!

done!
Forum: nexusdb.public.support 27th March 2012, 06:03 AM
Replies: 8
Views: 2,096
Posted By Andreas Schachtner
With the little App from my previous post i get...

With the little App from my previous post i get for each ExecSQL

45-52 Byte Leak from UnicodeString x 2.

In my MainApp i get 37560 x 45-100 Byte from UnicodeString for a full Calculation. Not...
Forum: nexusdb.public.support 26th March 2012, 03:23 PM
Replies: 8
Views: 2,096
Posted By Andreas Schachtner
Usally i use TnxQuery.Create (nil). Only in this...

Usally i use TnxQuery.Create (nil). Only in this snipped i try self for some reason.

But, for me same error with Create(nil) and Free;
Forum: nexusdb.public.support 26th March 2012, 03:20 AM
Replies: 8
Views: 2,096
Posted By Andreas Schachtner
MemoryLeak in nxQuery?

Since a great Refactoring-Session and Update to NEXUSDB 3.1004 i get MemoryLeaks (ReportMemoryLeaksOnShutDown:=true) in my App.
I use only the embedded Mode of the NexusDb and
i can reproduce this...
Forum: nexusdb.public.support 6th March 2012, 04:47 PM
Replies: 15
Views: 2,380
Posted By Andreas Schachtner
Smile @Eivind and Thorsten, thank you for the fast...

@Eivind and Thorsten,

thank you for the fast reply to my Problem. The new Version works like a charme with DXE2 Update 4. :)

Since we use only the embedded Mode of Nexus for a small Product in a...
Forum: nexusdb.public.support 6th March 2012, 06:15 AM
Replies: 15
Views: 2,380
Posted By Andreas Schachtner
....we have NexusDB Developer DCU only. So no...

....we have NexusDB Developer DCU only. So no simple recompile :(
Forum: nexusdb.public.support 6th March 2012, 03:37 AM
Replies: 15
Views: 2,380
Posted By Andreas Schachtner
Dear Nexus Team, can you provide a new Version...

Dear Nexus Team, can you provide a new Version asap please? A Deadline is near!
Forum: nexusdb.public.support 5th March 2012, 11:07 PM
Replies: 15
Views: 2,380
Posted By Andreas Schachtner
Workaround? New Version for Update 4?

Workaround? New Version for Update 4?
Forum: nexusdb.public.support 5th March 2012, 03:30 PM
Replies: 15
Views: 2,380
Posted By Andreas Schachtner
Can't compile Nexus 3.1003 with DXE2 Upd. 4

Since i have installed Delphi XE2 Update 4 i can`t compile my Applications with nexus as embedded Database (i have Nexus DB Developer DCU only).

[DCC Fataler Fehler] Datenmodul.pas(9): F2051 Unit...
Showing results 1 to 36 of 36

 
Forum Jump

All times are GMT +11. The time now is 06:59 AM.


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