Plateforme Level Extreme
Abonnement
Profil corporatif
Produits & Services
Support
Légal
English
Data Type Mismatch, after SCATTER MEMVAR
Message
Information générale
Forum:
Visual FoxPro
Catégorie:
FoxPro 2.x
Divers
Thread ID:
00009646
Message ID:
00009730
Vues:
44
>>This is driving me nuts, I have one screen in this
>>application and when I add a record the first time
>>after issuing INSERT FROM MEMVAR INTO ALIAS()
>>and the SCATTER MEMVAR I can't assign any value to a
>>memory variable, if I try something like :
>>m.memory_var=table1.field_name
>>Fox returns data type mismatch, for me it doesn't make
>>any sense, because Fox let you assign any type of value
>>to any type of variable, that is it lets you change
>>the data type at run time without any problem, like
>>if I say :
>>m.memory_var=5
>>and after that I say :
>>m.memory_var='Luis'
>>In Fox it is ok to do that.
>>Any Suggestions ?
>
>It can be irrelevant but from my own experience I know that using SCATTER command I often miss MEMO clause and Foxpro skips memo field squeezing array. If you have memo field it might be the case.

Thanks Edward, I found it, the problem was the next :
I had this environment
SELECT 0
USE table1
SET ORDER TO field1

SELECT 0
USE table2
SET RELATION TO field1 INTO table1

SCATTER MEMVAR
m.memory_var=table1.field2

in a point inside of the program I was issuing a SEEK on table1 and
then after the SEEK I was setting the order to 0 (zero), that
automatically reset the relationship between tables, so when I was
trying to say again :
m.memory_var=table1.field2, while my current area was table2, I had
the error DATA TYPE MISMATCH, it still doesn't make too much sense, but
that was all the problem.
Thanks a lot for trying to help.
Luis Guzman, MCP
"The only glory most of us have to hope for
is the glory of being normal." Katherine Fulleton Gerould
Précédent
Répondre
Fil
Voir

Click here to load this message in the networking platform