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