- John Murphy
- PowerBuilder
- Sunday, 24 May 2020 01:31 PM UTC
Here is another weird SyntaxFromSQL
If I select pmf.corp, pmf.branch from pmf; I get
column=(type=char(2) updatewhereclause = yes name=corp dbname="pmf.corp")
column=(type=char(2) updatewhereclause = yes name=pmf_branch dbname="pmf.branch")
If I select pmf.corp, pmf.branch, inv.corp, inv.branch from pmf, inv; I get
column=(type=char(2) updatewhereclause = yes name=corp dbname=corp")
column=(type=char(2) updatewhereclause = yes name=pmf_branch dbname="pmf.branch")
column=(type=char(2) updatewhereclause = yes name=inv_corp dbname="inv.corp")
column=(type=char(2) updatewhereclause = yes name=inv_branch dbname="inv.branch")
why in the second select is the dbname not pmf.corp?
Find Questions by Tag
Helpful?
If a reply or comment is helpful for you, please don’t hesitate to click the Helpful button. This action is further confirmation of their invaluable contribution to the Appeon Community.