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

Nick,
The line of code would be

&cCursor4..fname

There are no quotes in the command. Sorry if my post lead you to believe there were.