Hi,
While using FP DOS I call a UDF from a SQL SELECT. I was surprised to find out that TRIM() does not work seem to work within the function! The code is this:
SELECT FormatData(cX) AS cX FROM xx INTO CURSOR Y
FUNCTION FormatData
PARAMETER tcData
lcNewData = ...
RETURN lcNewData
After getting funny results I paused within the function and
tested through the DEBUG window that TRIM("aa ")+"." is not
"aa." Does anybody know why? Have I gone through the looking glass?
TIA,
Alex
Suivant
Répondre
Voir le fil de ce thread
Voir le fil de ce thread à partir de ce message seulement
Voir tous les messages de ce thread
Voir tous les messages de ce thread à partir de ce message seulement