How to read from the registry value inserted into SQL 2000 database? Can you give an example?
The following a short read values from the registries and then wrote TXT file, I want to directly inserted into the SQL database, it is very urgent, master can you tell me how to do ah?
FOR li_idx=1 TO ll_cnt
Li_rtn=RegistryGet (ls_RegKeySoftList + "" + lsa_swlist [li_idx], & amp;" DisplayName ", & amp; RegString! , & amp; Lsa_listvalue [li_idx] & amp;)
IF li_rtn=1 THEN

END the IF
NEXT

CodePudding user response:

Write directly embedded SQL
Insert into yourtable (col1, col2)
Values (: var1, var2);
Commit;

CodePudding user response:

Don't ask such a simple question.

Although simple, but really want to implement is more troublesome.

CodePudding user response:

Is so simple ah. What seems to be the trouble??

If you are not familiar with SQL, you can use the datastore or datawindow to do ah, insertrow (), setitem (), update () a few dw function.

CodePudding user response:

FOR li_idx=1 TO ll_cnt
Li_rtn=RegistryGet (ls_RegKeySoftList + "" + lsa_swlist [li_idx], & amp; "DisplayName", RegString! , lsa_listvalue [li_idx])
Insert into table (col1, col2) values (li_idx, : lsa_listvalue [li_idx]);
NEXT
Commit;

CodePudding user response:

Wait for people to answer.