tag:blogger.com,1999:blog-2222398033946644887.post9168372894466448500..comments2023-10-25T09:27:25.852-07:00Comments on PowerBuilder: Dynamically Creating DataWindow ObjectsGuruhttp://www.blogger.com/profile/17664820544726650763noreply@blogger.comBlogger2125tag:blogger.com,1999:blog-2222398033946644887.post-54002194029540269862014-02-18T00:50:59.453-08:002014-02-18T00:50:59.453-08:00can you please help me converting below PBSELECT s...can you please help me converting below PBSELECT statement into SELECT format.<br /><br /><br />PBSELECT( VERSION(400) <br />TABLE(NAME="table_barcode" ) <br />TABLE(NAME="table_barcode_attrib_map" ) <br />TABLE(NAME="table_barcode_attribute" ) <br />COLUMN(NAME="table_barcode.label_name") <br />COMPUTE(NAME="IsNull(table_barcode_attrib_map.value,0) pacmed_valid") <br />JOIN (LEFT="table_barcode.barcode_id" OP ="=" RIGHT="table_barcode_attrib_map.barcode_id" OUTER1 ="table_barcode.barcode_id" ) <br />JOIN (LEFT="table_barcode_attrib_map.attribute_id" OP ="=" RIGHT="table_barcode_attribute.attribute_id" OUTER1 ="table_barcode_attrib_map.attribute_id" ) <br />WHERE( EXP1 ="( ~~"table_barcode~~".~~"barcode_id~~"" OP ="=" EXP2 =":as_barcode_id )" LOGIC ="and" ) <br />WHERE( EXP1 ="table_barcode_attribute.attribute_name" OP ="=" EXP2 ="'PACMED VALID FLAG'" ) ) <br />ARG(NAME = "as_barcode_id" TYPE = string)Sanjiv Singhhttps://www.blogger.com/profile/10723666540126649723noreply@blogger.comtag:blogger.com,1999:blog-2222398033946644887.post-36114474643537698202012-03-13T21:56:25.616-07:002012-03-13T21:56:25.616-07:00Hi, probably our entry may be off topic but anyway...Hi, probably our entry may be off topic but anyways, I have been surfing around your blog and it looks<br /><br />very professional. It’s obvious you know your topic and you appear fervent about it. I’m developing a<br /><br />fresh blog plus I’m struggling to make it look good, as well as offer the best quality content. I have<br /><br />learned much at your web site and also I anticipate alot more articles and will be coming back soon.Thanks you.<br /><br /><br /><br /><br /> <a href="http://www.mdcovered.com/" rel="nofollow">ASC Coding</a>sornahttps://www.blogger.com/profile/17557060311661510045noreply@blogger.com