>Hi Dragan,
>
>Catching up after the holidays and fighting fires after getting back this week...
>
>OK - the SQL statements are in a table and you fetch them before firing them: did you then run this through a parser to change the statement e.g. swapping ISNULL() with NVL()? And what was the "base" SQL language you used - MS SQL?
Wasn't my code, it was done before I joined the team, but there was a series of strtran() statements and I think VFP syntax was first, i.e. older, so there was a lot of strtran(lcSql, ".f.", "1") (with extra parameters to make it case blind) and such. The hard cases, as I said, were simply manually copied into separate records and manually translated.