>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.
Larry Miller
MCSD
LWMiller3@verizon.netAccumulate learning by study, understand what you learn by questioning. -- Mingjiao