Information générale
Titre:
SQL SELECT bug in VFP 8, using memo fields
I think I ran into a bug in VFP, as decribed below. I wonder whether anybody knows a workaround.
The problem is that SQL SELECT .... INTO CURSOR generates an error (String is too long) if memo field used to create new column in destination cursor is a part of expression (ALLTRIM, TRANSFORM, etc.).
Steps to reproduce:
CREATE CURSOR a1 (bb M)
APPEND BLANK IN a1
REPLACE bb WITH REPLICATE('a', 2000) IN a1
Now, the following works:
SELECT a1.bb as dd from a1 INTO CURSOR c1
While, the following generates an error:
SELECT TRANSFORM(a1.bb) as dd from a1 INTO CURSOR c1
This error exists if any function used against the originam memo column: TRANSFORM, ALLTRIL, RTRIM, etc.
Thank you,
Igor.
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