Error data window, help!-CodePudding

Dw_1. Settransobject (sqlca)
Dw_1. Setsqlselect (" SELECT * FROM phone_pp ")
Dw_1. Retrieve ()

Run separately SELECT * FROM phone_pp there is no problem, but
Run error:
Select error: object 'phone_pp' invalid,

How to deal with? Where is the problem? Help!

CodePudding user response:

The

refer to the original poster HWFTH response:

dw_1. Settransobject (sqlca)
Dw_1. Setsqlselect (" SELECT * FROM phone_pp ")
Dw_1. Retrieve ()

Run separately SELECT * FROM phone_pp there is no problem, but
Run error:
Select error: object 'phone_pp' invalid,

How to deal with? Where is the problem? Help!

Don't use the select * from phone_pp, coupled with the column name try

CodePudding user response:

Or directly to build a data window, you need not setsqlselect, direct retrieve a try, if not, that is you have a database connection problem

CodePudding user response:

The building Lord may database even mistaken

CodePudding user response:

Haven't seen such a direct, are generally use getsqlselet data window, get the current data window SQL statements, and then modified with dw_1. Setsqlselect (), welcome advice

CodePudding user response:

What database connection

CodePudding user response:

The building Lord so try
Dw_data. Object. DataWindow. Table. Select="Select * from phone_pp"

CodePudding user response:

Eighty percent is program database connection has a problem

CodePudding user response:

Have a look at the database of the sqlca right,

But the usage of the building Lord: oh, I didn't like used are generally selected data sources using the SELECT data window, and then retrieve directly

CodePudding user response:

Make a here, and I met, I had also use setsqlselect directly to a dw, but this function in addition, the tooling have parameters and the problem of parameters of single and double quotation marks, and one more thing is that your setsql with the original number of columns in the SQL, be consistent in the same serial number column type, otherwise setsqlselect will go wrong

CodePudding user response:

Database connection problem, this table is not in the database connection

CodePudding user response:

Is likely to be a database connection,