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 69
Search took 0.00 seconds.
Search: Posts Made By: yannou
Forum: nexusdb.public.support.sql 26th May 2020, 07:11 PM
Replies: 5
Views: 1,276
Posted By yannou
Thanks !

Thanks !
Forum: nexusdb.public.support.sql 26th May 2020, 05:15 PM
Replies: 5
Views: 1,276
Posted By yannou
Hello, Can you give a quick look please ?...

Hello,

Can you give a quick look please ?

https://www.nexusdb.com/mantis/view.php?id=2340
Forum: nexusdb.public.support.sql 31st January 2020, 12:09 AM
Replies: 5
Views: 1,276
Posted By yannou
Did you guy tested this ? Should i post it in...

Did you guy tested this ?

Should i post it in mantis ?

Regards
Forum: nexusdb.public.support.sql 15th January 2020, 09:30 PM
Replies: 5
Views: 1,276
Posted By yannou
Strange Behavior on Indices choice using current_date alias

Hello guys I found something strange in the index choice for some query that are using "current_date".

I did not test other alias.

For example we have this test table with 2 indices :

- 1 using...
Forum: nexusdb.public.support 27th November 2019, 08:07 PM
Replies: 1
Views: 485
Posted By yannou
Hi, Yes it does!

Hi,

Yes it does!
Forum: nexusdb.public.support.adoprovider 29th October 2019, 10:08 PM
Replies: 10
Views: 2,175
Posted By yannou
Hi, Do you realize this probleme force us to...

Hi,


Do you realize this probleme force us to use **OLD** Nexus version ?

No answer for 1 month now.

This is critical !

Why should we keep paying update, if our connector can't connect to newest...
Forum: nexusdb.public.support.adoprovider 11th October 2019, 06:42 PM
Replies: 10
Views: 2,175
Posted By yannou
Hi, Any news on this ?

Hi,

Any news on this ?
Forum: nexusdb.public.support.adoprovider 21st September 2019, 12:16 AM
Replies: 10
Views: 2,175
Posted By yannou
ExceptionInfo: nil Exception:...

ExceptionInfo: nil
Exception: EAssertionFailed
Message: Assertion failure (D:\Delphi\3p\NexusDB3Build\Source\trunk\nxsqlProxies.pas, line 8248)
AWE Enabled: False
[00000000005E36F8]...
Forum: nexusdb.public.support.adoprovider 21st September 2019, 12:15 AM
Replies: 10
Views: 2,175
Posted By yannou
Hello, we are facing the exact same issue. For...

Hello, we are facing the exact same issue.

For the moment we were unable to use 4.50.14/15 ; it just crashes all the db.

Reading this topic, I realised the first query I do (which leads to a...
Forum: nexusdb.public.support 28th June 2019, 10:41 PM
Replies: 8
Views: 1,100
Posted By yannou
Any way to prevent this ?

Any way to prevent this ?
Forum: nexusdb.public.support 28th June 2019, 07:56 PM
Replies: 8
Views: 1,100
Posted By yannou
Hey thanks I now did understand. My problem here...

Hey thanks I now did understand.

My problem here is that as a dev I often need to read some information in production database;

The production database is used 90% from SQL
=> nexus consider all...
Forum: nexusdb.public.support 20th June 2019, 08:23 PM
Replies: 8
Views: 1,100
Posted By yannou
Well it's our bad, we installed 4,1100 instead...

Well it's our bad, we installed 4,1100 instead of 4.5.011 ...

You can close this i believe the lastest versison will fix this ;)

Sorry wasting your time


Regards
Forum: nexusdb.public.support 20th June 2019, 08:10 PM
Replies: 8
Views: 1,100
Posted By yannou
Thanks for the answer, i'll try to update one...

Thanks for the answer,

i'll try to update one the 2 server I have here.
--

The probleme is that most of the work is done with SQL, there is no cursor directly opened on this table all day long.
I...
Forum: nexusdb.public.support 20th June 2019, 05:49 PM
Replies: 8
Views: 1,100
Posted By yannou
nxEntrepriseManager makes nxServer restart/empty cache

Hello,

Since we updated our nxserver to -> Engine version: 4,1100 Release (D22) Standard Edition 64bit

We sometimes face a strange behavior from the server.

When our dev randomly closes table...
Forum: nexusdb.public.support 21st February 2019, 05:21 PM
Replies: 8
Views: 766
Posted By yannou
I sent another log file at support@nexus.com

I sent another log file at support@nexus.com
Forum: nexusdb.public.support 20th February 2019, 05:54 PM
Replies: 8
Views: 766
Posted By yannou
We are running in native mode; But to be honest...

We are running in native mode;

But to be honest I dont know the differences.
Forum: nexusdb.public.support 19th February 2019, 07:49 PM
Replies: 8
Views: 766
Posted By yannou
Thanks for the reply, we have more and more...

Thanks for the reply, we have more and more crash (2 this morning);

Its hard for us to send you a testcase, as many applications are connecting through differents connector (mainly...
Forum: nexusdb.public.support 19th February 2019, 12:49 AM
Replies: 8
Views: 766
Posted By yannou
Nexus crashs

Hello there,


For a few weeks now we are facing random nxserver crashs.

In the log we can only found the same message :

ExceptionCode: $C0000005 = EXCEPTION_ACCESS_VIOLATION - The thread tried to...
Forum: nexusdb.public.support.sql 5th September 2018, 05:43 PM
Replies: 3
Views: 1,592
Posted By yannou
Thanks for the answer, so I can assume what I do...

Thanks for the answer, so I can assume what I do (on a sql side) is correct and I cannot optimize this ?


Regards,

[QUOTE='Thorsten Engler [NDA];111248']NexusDB doesn't cache query outputs.
It only...
Forum: nexusdb.public.support.sql 5th September 2018, 01:35 AM
Replies: 3
Views: 1,592
Posted By yannou
Slow textIndex?

Hello there,

We have a table with ~1 million records and we need to setup a fast search on 3 differents columns (strings).

The indices on this table are :
they are more but i'll write the relevant...
Forum: nexusdb.public.support 14th June 2018, 01:23 AM
Replies: 4
Views: 938
Posted By yannou
Hey, Thanks for the answer. FYIk; this...

Hey,

Thanks for the answer.

FYIk; this happened again today, and I can confirm you that there is no relevant log.

I rolled back to NXE 4.0.1.0 32bits; it works.

(I was using 4.50.0.3 64bits )
Forum: nexusdb.public.support 14th June 2018, 01:20 AM
Replies: 3
Views: 862
Posted By yannou
Hello, "Is there a way to specify what indexes...

Hello,



"Is there a way to specify what indexes the parser should use in SQL"

=> I asked this a few months ago; they said no!

Good luck ~
Forum: nexusdb.public.support 13th June 2018, 06:46 PM
Replies: 4
Views: 938
Posted By yannou
Hello, No I don't see specific logs on the...

Hello,


No I don't see specific logs on the error itself.

From our .net backend (using sql/adoprovider) => queries ends in TO.

From our delphi software, I see this error/stack (not sure if it's...
Forum: nexusdb.public.support 13th June 2018, 01:05 AM
Replies: 4
Views: 938
Posted By yannou
Server crash after NXEntreprise close table

Hello there,


Since we updateded to lastest nexus server version (Engine version: 4,5003 Release (D23) Standard Edition 32bit with AWE);

We have server Crash when we close a table using...
Forum: nexusdb.public.support.adoprovider 16th April 2018, 09:16 PM
Replies: 1
Views: 2,529
Posted By yannou
EF Core

Hello guys,


Is nexus compatible with EF CORE ?

we are trying to build a .NET CORE 2 website.

Regards
Forum: nexusdb.public.support.sql 19th March 2018, 08:29 PM
Replies: 1
Views: 1,230
Posted By yannou
Text index, seach ignoring accent

Hello,

We are using a table with different index and a fullTextIndex.

We want to know if its possible to perform a search ignoring accents.

Example :

select * from t where myStringField = 'e';...
Forum: nexusdb.public.support.adoprovider 30th January 2018, 08:23 PM
Replies: 11
Views: 5,632
Posted By yannou
Hey, I think I did everything you said, you see...

Hey,

I think I did everything you said, you see details here in my process explorer https://ibb.co/e5vvdm

I'm using native=true.

I posted a gitlab in your issue tracker, the code didn't change;...
Forum: nexusdb.public.support.adoprovider 29th January 2018, 10:39 PM
Replies: 11
Views: 5,632
Posted By yannou
Hello, Either the fix do not work for my...

Hello,

Either the fix do not work for my problem; or I forgot something.



- I downloaded and installed the visual studio pack 320
- I checked my nxServer.exe , was using the...
Forum: nexusdb.public.support.adoprovider 18th January 2018, 06:42 PM
Replies: 11
Views: 5,632
Posted By yannou
Hello, Any updates on this ? Regards

Hello,

Any updates on this ?

Regards
Forum: nexusdb.public.support.adoprovider 22nd December 2017, 11:19 PM
Replies: 11
Views: 5,632
Posted By yannou
É

É
Forum: nexusdb.public.support.adoprovider 22nd December 2017, 11:18 PM
Replies: 11
Views: 5,632
Posted By yannou
It seems the char are badly encoded aswell in...

It seems the char are badly encoded aswell in code snippets on the forum :

The query was : "SELECT '?' from #dummy;"

It returns "?" in the first case;

and "�" in the second.
Forum: nexusdb.public.support.adoprovider 22nd December 2017, 10:19 PM
Replies: 11
Views: 5,632
Posted By yannou
Netcore 2 encoding

Hello,

We are creating a new website using netcore2.0; and we faced some issue using adoprovider on this framework's version.

In .net 4.X we use this to connect to nexusDb :


...
Forum: nexusdb.public.support.sql 13th April 2017, 06:45 PM
Replies: 7
Views: 2,908
Posted By yannou
Hey, Thanks thorsten for the complete answer. I...

Hey,

Thanks thorsten for the complete answer.

I tryed with the sample in NexusDB\Visual Studio Pack\Demos\WebDemo1 with my connection string + query. And the default TO is still 20s.

Im using...
Forum: nexusdb.public.support.sql 13th April 2017, 01:02 AM
Replies: 7
Views: 2,908
Posted By yannou
This didn't work. My connection string is : ...

This didn't work.
My connection string is :

<add name="NexusConnectionString"...
Forum: nexusdb.public.support.sql 12th April 2017, 07:12 PM
Replies: 7
Views: 2,908
Posted By yannou
Well it does not work

Well it does not work
Forum: nexusdb.public.support.sql 11th April 2017, 09:31 PM
Replies: 7
Views: 2,908
Posted By yannou
I forgot to mention that i want to configure it...

I forgot to mention that i want to configure it globally;
I know the #T xxx option :)
Forum: nexusdb.public.support.sql 11th April 2017, 09:09 PM
Replies: 7
Views: 2,908
Posted By yannou
Default SQL Timeout

Hello,

We are using nexusDb with ado Connector/SQL only;

Is there a way to configure the default timeout ?


Thanks
Forum: nexusdb.public.support.sql 1st February 2017, 08:09 PM
Replies: 1
Views: 1,867
Posted By yannou
Creating fullTextIndex from SQL

Hello,

Is there a way to create and configure a fullTextIndex from SQL ?

Best regards
Forum: nexusdb.public.support.sql 20th June 2016, 09:25 PM
Replies: 7
Views: 2,295
Posted By yannou
Okay thanks, that's where I was looking for in...

Okay thanks,

that's where I was looking for in the first place.

Regards
Forum: nexusdb.public.support.sql 14th June 2016, 08:23 PM
Replies: 7
Views: 2,295
Posted By yannou
Get nexus version from SQL

Hi,


Is there any way to get nexus version from SQL ?
Forum: nexusdb.public.support.adoprovider 18th December 2015, 05:55 PM
Replies: 6
Views: 3,156
Posted By yannou
Hello Thorsten, any news on this ? Having the...

Hello Thorsten, any news on this ?

Having the same issue.


Best regards
Forum: nexusdb.public.support.sql 10th November 2015, 06:29 PM
Replies: 20
Views: 3,919
Posted By yannou
Thank you Thorsten, you answered all my...

Thank you Thorsten, you answered all my concerns.

Have a nice day
Forum: nexusdb.public.support.sql 10th November 2015, 12:18 AM
Replies: 20
Views: 3,919
Posted By yannou
No news on this ?

No news on this ?
Forum: nexusdb.public.support.adoprovider 6th November 2015, 01:43 AM
Replies: 1
Views: 1,778
Posted By yannou
EXTENDED Type is not supported

Hello,



"EXTENDED Type is not supported"
Forum: nexusdb.public.support.sql 30th October 2015, 12:45 AM
Replies: 20
Views: 3,919
Posted By yannou
Thanks again for the detailled answer; but as I...

Thanks again for the detailled answer; but as I said in my 1st post :



Nexus simply rejects queries like those :
SELECT * form xxx WHERE CONTAINS (...) AND ....
-- OR
SELECT * form xxx WHERE...
Forum: nexusdb.public.support.sql 29th October 2015, 09:32 PM
Replies: 20
Views: 3,919
Posted By yannou
Thanks for your reply, using temp table or...

Thanks for your reply, using temp table or :

SELECT * from CONTACTS where
clecontact IN ( SELECT clecontact FROM CONTACTS where contains(fullTextIndex2,STARTS WITH 'martin' and '#1146') )
OR...
Forum: nexusdb.public.support.sql 29th October 2015, 02:49 AM
Replies: 20
Views: 3,919
Posted By yannou
Well in fact my problem is a bit more complex...

Well in fact my problem is a bit more complex than the example I posted;

I created an indexField in my TABLE wich will contains the value of 4 others columns as :
indexField = "col1 #col2 {col3...
Forum: nexusdb.public.support.sql 29th October 2015, 12:19 AM
Replies: 20
Views: 3,919
Posted By yannou
Well I tryed : SELECT * FROM table where ID IN...

Well I tryed :
SELECT * FROM table where ID IN (
SELECT ID FROM table WHERE CONTAINS (fullTextIndex, 'abc' and 'def' )
UNION
SELECT ID FROM table WHERE CONTAINS (fullTextIndex, 'xyz' )
); but it wont...
Forum: nexusdb.public.support.sql 28th October 2015, 10:33 PM
Replies: 20
Views: 3,919
Posted By yannou
Well I already had this solution, splitting the...

Well I already had this solution, splitting the query like this :

select DISTINCT * from(
SELECT * FROM CONTACTS where contains(fullTextIndex2,STARTS WITH 'martin' and '#1146') UNION all
SELECT...
Forum: nexusdb.public.support.sql 28th October 2015, 07:14 PM
Replies: 20
Views: 3,919
Posted By yannou
Hi wolfgang, As I said its not possible nexus...

Hi wolfgang,

As I said its not possible nexus send back this errror :

"Combining separate CONTAINS phrases with OR in a single table expression is not currently supported"

It would be a huge...
Showing results 1 to 50 of 69

 
Forum Jump

All times are GMT +11. The time now is 10:49 PM.


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