Not perfectly. I have problems with date functions - if "formula" with date functions is used in the mapping e.g. formula="datepart(yyyy,myfield)" or formula="datediff(yyyy,myfield1,myfield2)" strange errors from sqlclient are reported - something like "mytable0_.yyyy is not a recognized datepart option" or "this.yyyy is not a recognized datediff option". (no errors with sql2k)
BTW - maybe someone has a solution for this ? My current workaround is rather not nice - I have written 'wrapper' user-definied functions for the above ones.
_________________ michal
|