The data window can't show the data in the database! Other Settings. The operation feeling also have no wrong! I don't know what is the problem? Refer to master how to solve!

CodePudding user response:

Run things pop up like the attached error message!

CodePudding user response:

Not write very clear...
Before dw_1. Settransobject (sqlca)?
If you connect; Yet?

CodePudding user response:

In the window of the Open events or data window constructor to write code in the

Dw_1. Settrans (sqlca) (not recommended)
Or
Dw_1. Settransobject (sqlca) (recommended)

CodePudding user response:

Remember to retrieve

CodePudding user response:

1. May not connect library.
2. No dw_1. Settransobject (sqlca), dw_1. Retrieve ()

CodePudding user response:

//connect to the database
Connect Using the SQLCA;

IF the SQLCA. Sqlcode & lt;> 0 Then
MessageBox (" message ", "connect to database failure!" )
End the IF

Dw_1. Settransobject (SQLCA)
Dw_1. Retrieve ()

Have to do this step, the proposal to write out the contents of the question in the title bar, so that can help you faster, thank you!