11 px] [size=dw_kqsz. Settransobject (sqlca)
Declare uscur cursor for
The select user_id
The from t_hyb;
The open uscur;
The fetch uscur into: s_userid

The do while the sqlca. Sqlcode=0
I_currentrow=dw_kqsz. Insertrow (0)
Dw_kqsz. Setitem (i_currentrow, "hd_id", i_actv)
Dw_kqsz. Setitem (i_currentrow, "user_id", s_userid)
Dw_kqsz. Setitem (i_currentrow, "hd_dt", today ())
The fetch uscur into: s_userid;
Loop
The close uscur;


Tip old said,,, do that line and loop error c0031: syntax error
And I am the wrong use cursor,,, the eldest brother help ah, thank you [/size]

CodePudding user response:

Less a semicolon
The open uscur;
The fetch uscur into: s_userid ;

The do while the sqlca. Sqlcode=0

CodePudding user response:

Upstairs positive solutions.

CodePudding user response:

Ha ha, semicolon is very important

CodePudding user response:

The original poster is a green hand