Account Schedule under SQL Filter Problems

twdavis

Recently converted Nav40 to SQL.
Running the Account Schedule I am getting a circular reference error.

Debug reveals tahe the following code does not work NOW! (I have simplified the code, Expression is in the "Totaling" field of the Acc. Schedule Line table.)


Expression := '01..75';
SETRANGE("Schedule Name",'MFG OVHD');
SETFILTER("Row No.",Expression);

I should have seen only records with "Schedule Name" = 'MFG OVHD' and "Row No." = '01' thru '75'

The SETFILTER for '01..75 does not work now.
I cannot change the SQL Data Type to Integer because they have alphanumeric values.

Any suggestions? Please?

ara3n

Change the row No. to 4 digits?

twdavis

I am going to try the VARIANT setting of the SQL DATA TYP.

twdavis

Variant is setting!

Thanks