How to find a column in database

[santosh2natal]

How can I find a column which is included in a datawindow definition while desiging it but not existing in the database?

 

[pgaec]

Retrieve the datawindow. You should get "Invalid colum name: <column name> " in the sqlerrtext property of ur transaction object.

 

[NorthChert]

use the script like :
string ls_dbname
boolean lb_notdbcolumn=flase

ls_dbname=<DW Control Name>.Describe("<Columnname>.dbName")
or
ls_dbname=<DW Control Name>.Object.<Columnname>.dbName
IF ls_dbname = "" OR ls_dbname = "!" THEN
lb_notdbcolumn=true
// the column is not a db column
else
lb_notdbcolumn=false
// the column is a db column

end if