NAV Filter To SQL Filter

Eugene

the problem: Parse and convert Navision Dataset Filter to SQL statement used to generate ADORecordSet

the question: is there some filter parser/converter already written ? It does not have to cover all the possible cases. It should parse the most basic cases and reject filters it can't convert to SQL

girish.joshi

I have had to deal with this problem on a few occassions.

If possible, after I set the Navision filters, I transfer the data to a new table and then run any SQL I need on the new table.