Code: Select all
"SELECT (@T:=duration-x) as T, if( @T>0, concat(@T,' days'), 'DONE') as ETC FROM database;"
I receive this ERROR on runtime:
"MyQuery1: type mismatch for field 'ETC', Expecting:WideMemo actual: String'"
In the first Open it works but when you close and open again it gives this error. BlobType is also "ftWideMemo"
bug or any idea ?
CAST(if( @T>0, concat(@T,' days'), 'DONE') as CHAR) as ETC also doesnt help
ok final test:
concat(@T, 'days') results as TMemoField and it outputs error
concat(cast(@T as CHAR), 'days') concat('zzz ', 'days') results TMemoField and it outputs error
concat('zzz ', 'days') results as TStringField and it outputs no error