>>I keep getting syntax error when I save my code. I'm trying to reference fields in my cursor as below. Is it not possible to refer to fields in cursor as (cursor).field ?
>>
>>
>>
>INSERT INTO (cCursor4) ((cCursor4).c1, (cCursor4).c2, (cCursor4).c3, (cCursor4).c4, ;
> (cCursor4).c5, (cCursor4).c6, (cCursor4).c7, (cCursor4).c8, (cCursor4).c9, ;
> (cCursor4).c10) ;
> VALUES((cCursor).pp, (cCursor).fname, (cCursor).totpay, (cCursor).fica, (cCursor).retire_amt, ;
> (cCursor).health_ins, (cCursor).retiree_med, (cCursor).unempins, (cCursor).wrkcompins, ;
> (cCursor).total_salary)
>
>>
>>
>>
>>Thanks
>>Nick Patel
>
>I believe you have to use
>
>&cCursor4..
>
>You must use the double "." because the first . stops the macro substitution and the second will be used in the expression.
>
>HTH.
I tried (&cCursor4)".".fname and it did allow me to save, but when I ran the program, it gave me a syntax error. I even tried (&cCursor4).fname and it still gave me an error. Apparently it sees the value in &cCursor4 just fine, it just doesn't understand fname.
Thanks
Nick Patel