Pb, using odbc to connect oracle, in SQL, under the database SQL window can query to the data, dynamic data window, why the same statement, tectonic dynamic query is successful, no data, please notice! Pb8.0, oracle 10
Pb under the query: select aab001, aab004 from ab01;

//construct statement
Str_sql="select aab001, aab004 from ab01"

//constructs to create data window statement
Str_syntax=sqlca. Syntaxfromsql (str_sql, 'style (type=Grid)', str_err_sql)
Essagebox (" tip ", str_syntax)
If len (str_err_sql) & gt; 0 then
Messagebox (" error ", "obtain the SQL syntax error!" )
The return - 1
End the if

//create the data window
Dw_1. Create (str_syntax str_err_create)
If len (str_err_create) & gt; 0 then
Messagebox (" error ", "an error occurred when creating data window")
The return - 1
End the if
Dw_1. Settransobject (sqlca)

CodePudding user response:

Dw_1. Retrieve ()
Isn't forget to retrieve data?

CodePudding user response:

http://zhidao.baidu.com/question/506917859.html

CodePudding user response:

Not really no dw_1. Retrieve (), your code test is able to pass, no such thing as an error you run

CodePudding user response:

Messagebox (" ", dw_1. Retrieve ()) is know to have the data

CodePudding user response:

Tested, the code is less a sentence dw_1. Retrieve ()

CodePudding user response:

The original poster is too careless

CodePudding user response:

Dw. Retrieve ()

CodePudding user response:

The

reference 7 floor soar_angel response:

dw. Retrieve ()

+ 1

CodePudding user response: