>>>Hi All,
>>>
>>>I am having a problem converting a program from 2.6 to VisualFP. The code 'Create Cursor xxx from Array yyy' works just fine in 2.6, but it gave me the 'Syntax error' when I ran that program in 5.0
>>>
>>>Please help!!! Thanks a lot.
>>
>>It works Ok in VFP5. You may try it:
>>Select MyTable
>>=Afields(MyArray)
>>Create Cursor tmp From Array MyArray
>
>
>Edward,
>
>Here is my code:
>
> SELE du
> =AFIELDS(ladhdstru)
> lclen=ALEN(ladhdstru,1)+1
> DIME ladhdstru(lclen,4)
> ladhdstru(lclen,1)='hccode'
> ladhdstru(lclen,2)='C'
> ladhdstru(lclen,3)=4
> ladhdstru(lclen,4)=0
>
> CREATE CURSOR chkit FROM ARRAY ladhdstru
>
>I got the syntax error at the last line. What is the problem??
>
Hi Rick,
The problem is that you'll have .F. in columns 5 through 16 in VFP when you re-dimension the array. Use the debugger to get the data types for those columns and add code to modify them appropriately.
George
Ubi caritas et amor, deus ibi est