Application Development and Automation Discussions
Join the discussions or start your own on all things application development, including tools and APIs, programming models, and keeping your skills sharp.
cancel
Showing results for 
Search instead for 
Did you mean: 
Read only

EXEC SQL PERFORMING

Former Member
0 Likes
659

when run the following program ,it reported error as

"the error occurred in the current database connection "DEFAULT".

how to solve the problem ?

=================================

DATA : BEGIN OF WA,

CLIENT(3),

ARG1(3),

ARG2(3),

END OF WA.

DATA F3 VALUE '1'.

EXEC SQL PERFORMING LOOP_OUTPUT.

SELECT CLIENT , ARG1 INTO :WA FROM TABLE_001 WHERE ARG2 = :F3.

ENDEXEC.

FORM LOOP_OUTPUT.

WRITE : / WA-CLIENT,WA-ARG2.

ENDFORM.

==================================

1 REPLY 1
Read only

Former Member
0 Likes
365

hi

try

SELECT * FROM TABLE_001 INTO CORRESPONDING FIELDS OF WA WHERE ARG2 = F3.

KUMAR