SETFILTER in SQL Database different with Native Database?

intelcore2quad88 · 2012-03-26

Hello everyone,

I have the issues below: When i release my report to Customer, they say that number in report is wrong, but when I backup database and restore to my laptop, I have the right number! After that, I know my customer run NAV with Native Database, I run with SQL Database, and I have the problem with SETFILTER command:

GLEntry.SETFILTER("G/L Account No.",'<>131*');

- In Native Database, it return Data with G/L Account No: 13199

- In SQL Database, it does not return Data with G/L Account No: 13199

So, this is reason why Customer run report which return wrong number, but I run report return right number #-o

Has everyone had the problem yet?

Thanks.

mohana_cse06 · 2012-03-26

Check whether these posts are helpfull or not
http://www.mibuso.com/forum/viewtopic.php?t=18962
http://www.mibuso.com/forum/viewtopic.php?t=23219

David_Singleton · 2012-03-26

intelcore2quad88 wrote:

I have the issues below: When i release my report to Customer, they say that number in report is wrong, but when I backup database and restore to my laptop, I have the right number! After that, I know my customer run NAV with Native Database, I run with SQL Database, and I have the problem with SETFILTER command:

WRONG. Your issue is that you are developing in a different environment to that which your customer is using.

You must use the same versions for development and testing and live.

This is just one of many things that are different between the two databases.

ssingla · 2012-03-27

As David suggested there is difference between the sorting of "Code" field in Native and SQL db.

intelcore2quad88 · 2012-03-27

After I have tried some expression filter, I decide not to use : <>A*, because no expressions return right value in Native Database!
So I decide to choose another way.
This is my way:

Before
1. GLE.SETFILTER("G/L Account No.",'<>A*&<>B*');
2. GLE.SETFILTER("G/L Account No.",'%1&%2','<>A*','<>B*');
2. GLE.SETFILTER("G/L Account No.",'<>%1&<>%2','A*','B*');
=> all are fail
After
Create new variable GLE2
1. GLE2.SETFILTER("G/L Account No.",'A*|B*'); //Get entry contain "G/L Account No." = A* or B*
2. IF GLE.FINDSET THEN REPEAT
       IF NOT GLE2.GET(GLE."Entry No.") THEN BEGIN
       ...........//Doing with entry no contain "G/L Account No." = A* or B*
       END;
    UNTIL GLE.NEXT = 0;
=> return right value

Thanks for everyone.

kriki · 2012-03-27

SETFILTER("...",'<>XYZ*'); does work on SQL but on native it doesn't work.

SETFILTER in SQL Database different with Native Database?

Comments

Categories