I'm doing a project, need to add a data window to statistical data in another table, but I'm writing scripts is don't know how to get the data in a table, a great god,,, ps: when set up statistics window dw need to establish what contact and the table? Next, ask for advice,,,,,

CodePudding user response:

Use CURSOR
DECLARE cursor_name CURSOR FOR...
The OPEN cursor_name
The FETCH cursor_name INTO...
The CLOSE cursor_name

Or use the datastore
Datastore typical vmlinux.lds
String ls_sql ls_syntax, ls_temp
Typical vmlinux.lds=create datastore
Ls_sql="SELECT the Columns FROM TabelName"
Ls_syntax=SQLCA. SyntaxFromSql (ls_sql, "", ls_temp)
If len (ls_temp) & gt; 0 then
MessageBox (" Error ", "SyntaxFromSQL under caused these errors:" + ls_temp)
The return - 1
End the if
Typical vmlinux.lds. Create (ls_syntax ls_temp)
Typical vmlinux.lds. SetTransObject (sqlca)
Typical vmlinux.lds. Retrieve ()

CodePudding user response:

This method has a lot of kinds, direct write SQL statements by assigned to a variable, or through the DW to get,

CodePudding user response:

You can use data storage datastore

CodePudding user response:

With the DataStore is very good,

CodePudding user response:

Agree with upstairs, datastore or datawindow can be