The below code works fine on my PC but under and EXE on a users PC it fails with an error 11 - function argument, value, type, or count is invalid.

The original code used an IN (This.cAlias) and I replace that with a SELECT (This.cAlias) before the replace. I also added an 'X' to the end of each column that might be confused with a reserved word.

Still get the same error. Anyone see anything wrong with this?

      REPLACE namex     WITH LOWER( namex )                                  ,;
              datetimex WITH DATETIME( YEAR( datex )                         ,;
                                      MONTH( datex )                         ,; 
                                      DAY( datex )                           ,;
                                      INT( VAL( SUBSTR( timex, 1, 2 ) ) )    ,;
                                      INT( VAL( SUBSTR( timex, 4, 2 ) ) )    ,;
                                      INT( VAL( SUBSTR( timex, 7, 2 ) ) ) )  ALL