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 67
Search took 0.00 seconds.
Search: Posts Made By: yannou
Forum: nexusdb.public.support.sql 31st January 2020, 01:09 AM
Replies: 2
Views: 257
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, 10:30 PM
Replies: 2
Views: 257
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, 09:07 PM
Replies: 1
Views: 266
Posted By yannou
Hi, Yes it does!

Hi,

Yes it does!
Forum: nexusdb.public.support.adoprovider 29th October 2019, 11:08 PM
Replies: 10
Views: 1,381
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, 07:42 PM
Replies: 10
Views: 1,381
Posted By yannou
Hi, Any news on this ?

Hi,

Any news on this ?
Forum: nexusdb.public.support.adoprovider 21st September 2019, 01:16 AM
Replies: 10
Views: 1,381
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, 01:15 AM
Replies: 10
Views: 1,381
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, 11:41 PM
Replies: 8
Views: 887
Posted By yannou
Any way to prevent this ?

Any way to prevent this ?
Forum: nexusdb.public.support 28th June 2019, 08:56 PM
Replies: 8
Views: 887
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, 09:23 PM
Replies: 8
Views: 887
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, 09:10 PM
Replies: 8
Views: 887
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, 06:49 PM
Replies: 8
Views: 887
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, 06:21 PM
Replies: 8
Views: 595
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, 06:54 PM
Replies: 8
Views: 595
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, 08:49 PM
Replies: 8
Views: 595
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, 01:49 AM
Replies: 8
Views: 595
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, 06:43 PM
Replies: 3
Views: 1,361
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, 02:35 AM
Replies: 3
Views: 1,361
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, 02:23 AM
Replies: 4
Views: 799
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, 02:20 AM
Replies: 3
Views: 720
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, 07:46 PM
Replies: 4
Views: 799
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, 02:05 AM
Replies: 4
Views: 799
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, 10:16 PM
Replies: 1
Views: 2,062
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, 09:29 PM
Replies: 1
Views: 1,038
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, 09:23 PM
Replies: 11
Views: 4,121
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, 11:39 PM
Replies: 11
Views: 4,121
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, 07:42 PM
Replies: 11
Views: 4,121
Posted By yannou
Hello, Any updates on this ? Regards

Hello,

Any updates on this ?

Regards
Forum: nexusdb.public.support.adoprovider 23rd December 2017, 12:19 AM
Replies: 11
Views: 4,121
Posted By yannou
É

É
Forum: nexusdb.public.support.adoprovider 23rd December 2017, 12:18 AM
Replies: 11
Views: 4,121
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, 11:19 PM
Replies: 11
Views: 4,121
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, 07:45 PM
Replies: 7
Views: 2,681
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, 02:02 AM
Replies: 7
Views: 2,681
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, 08:12 PM
Replies: 7
Views: 2,681
Posted By yannou
Well it does not work

Well it does not work
Forum: nexusdb.public.support.sql 11th April 2017, 10:31 PM
Replies: 7
Views: 2,681
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, 10:09 PM
Replies: 7
Views: 2,681
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, 09:09 PM
Replies: 1
Views: 1,731
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, 10:25 PM
Replies: 7
Views: 2,148
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, 09:23 PM
Replies: 7
Views: 2,148
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, 06:55 PM
Replies: 6
Views: 2,942
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, 07:29 PM
Replies: 20
Views: 3,532
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, 01:18 AM
Replies: 20
Views: 3,532
Posted By yannou
No news on this ?

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

Hello,



"EXTENDED Type is not supported"
Forum: nexusdb.public.support.sql 30th October 2015, 01:45 AM
Replies: 20
Views: 3,532
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, 10:32 PM
Replies: 20
Views: 3,532
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, 03:49 AM
Replies: 20
Views: 3,532
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, 01:19 AM
Replies: 20
Views: 3,532
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, 11:33 PM
Replies: 20
Views: 3,532
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, 08:14 PM
Replies: 20
Views: 3,532
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...
Forum: nexusdb.public.support.sql 28th October 2015, 01:51 AM
Replies: 20
Views: 3,532
Posted By yannou
No answer ? Anyone ? ... :confused:

No answer ? Anyone ?
... :confused:
Forum: nexusdb.public.support.sql 19th October 2015, 08:34 PM
Replies: 20
Views: 3,532
Posted By yannou
Full text index and limitation

Hi there,


I'm testing a fullText index and i'm facing a limitation :


SELECT * FROM MYTABLE where contains(fullTextIndex,'abc' and 'def' ) --works


SELECT * FROM MYTABLE where...
Showing results 1 to 50 of 67

 
Forum Jump

All times are GMT +11. The time now is 07:04 PM.


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