Search condition failed

Classic Servoy
1

Hi ,
I have a very simple search condition.

controller.find();
module_id = “1”;
controller.search();

But this condition failed.
Based upon this condition I have 10 records but it gives 5 records.
And the interesting thing is , if debugger is enabled then it gives all records (10 records) otherwise faulty search.

2

Hi subhranild,

What results are returned when you perform this find manually without using a method ?

Cheers
Harry

3

Hi Harry,
Manually search also gives the wrong serch result.
Only correct search result comes when debugger is enabled.

Thanks,
Subhranil

4

Hi Subhranil,

If the manual search returns bad data too then could it be the data itself then that is at fault ?

What is the data type for that id ?
What database is this running on ?
Can you run a SQL query directly on the data to see if this returns correct results ?

Cheers
Harry

5

Hi Subranhild

Did you also try with

controller.find();
module_id = 1;
controller.search();

if module_id is an integer?

Best regards, Robert

6

Hi Harry,

That id’s datatype is text.
Database is iAnywhere(servoy own database)
I run a SQL query and got the correct result.
But I told previously that interesting thing is

Only correct search result comes when debugger is enabled.

7

Hi Subhranil,

Well I’ve replicated your scenario here on :
Servoy Developer
Version 3.5.3-build 516
Java version 1.5.0_13-121 (Mac OS X)

I cannot get erroneous results using manual or method based search - with or without debugger :(

Is this the only column which exhibits this behaviour ?

Can you send an extract of the module_id raw data or create a very simple solution which replicates this problem and upload it

Cheers
Harry

8

Hi Harry ,

Actually I am working on
Servoy Developer
Version 3.1.2-build 406
Java version 1.6.0-b105 (Windows XP)

It gives the wrong search result.

I open that solutions on

Servoy Developer
Version 3.5.2-build 515
Java version 1.5.0-b64 (Windows XP)

And it work nicely.

Have you any idea about that?

Otherwise I will make a sample solution send you next day.

9

Hi Subhranil,

No find issues with 3.1.x as far as I know - perhaps someone else may chime in if they know of any anomalies :roll:

I have just tested on that version with none of your problems.

Send me the sample in which you can reproduce this behaviour and I’ll use 3.1.2 to test it here

Cheers
Harry

10

Hi Harry,

Thanks for your efforts. :lol:

Yet I have no clue about that problem.

I am attaching a sample solution please checke it.
That solution have the search condition on onShow event.
You just check the result only eneble and disable the debugger.

test.servoy (6.13 KB)

11

subhranild:
Actually I am working on
Servoy Developer
Version 3.1.2-build 406
Java version 1.6.0-b105 (Windows XP)

It gives the wrong search result.

I open that solutions on

Servoy Developer
Version 3.5.2-build 515
Java version 1.5.0-b64 (Windows XP)

And it work nicely.

Subhranil,

Please upgrade first to the latest and greatest for each release branch (currently 3.1.7 for 3.1.x and 3.5.3 for 3.5.x).

Rob

12

Hi ,

I will upgrade the version.

but my problem is , in the same form if I search with different condition then I get correct result.

And please check this solution test.servoy because I change the previous attachment test1.servoy.

13

Hi Subhranil,

Rob is correct about upgrading

I opened your test solution in 3.1.2 and I got the error

BTW - you did not mention originally that it was being triggered onShow and this seemed to be the factor that was causing the erroneous result :o

I then tested in 3.1.3 and 3.5.x and it was fine so, whatever the problem, it seems that it was identified and fixed for further releases :)

So please upgrade and let us know if it is cured from your perspective

Cheers
Harry

14

Thanks Harry and Rob,

I tested this solution in 3.5.x and working fine.

Now I upgrade 3.1.2 to 3.1.3 and it is working nicely.
But I never faced this type of problem at 3.1.2. :shock:

Thanks again Harry. :D