V
Vel murugan
Guest
the below query works fine to fetch tha field details. SELECT "_Field-Name", "_Data-type" FROM PUB."_Field" WHERE "_file-recid" = ( SELEC ROWID FROM PUB."_file" WHERE "_file-name" = 'Customer')"; in Progress v11.6, Since ROWID is not unique, in order to achieve uniqueness , i have changed the above query and replaced ROWID to PRO_PARTN_ROWID . SELECT "_Field-Name", "_Data-type" FROM PUB."_Field" WHERE "_file-recid" = ( SELECT PRO_PARTN_ROWID FROM PUB."_file" WHERE "_file-name" = 'Customer')"; i am getting inconsistent types error. what am I missing here?
Continue reading...
Continue reading...