>>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