The problem is going to be with the data itself. For instance, let's say for a particular record that datex is empty {}, this would give you the error you describe.
>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
>