Subscribe via RSS
Toggle Submenu
  1. Categories
  2. Recent
  3. Tags
View Replies (1)

Resolved SyntaxFromSQL Weird dbname

  1. Issue
0
Votes
Undo
  1. John Murphy
    John Murphy
  2. PowerBuilder
  3. Sunday, 24 May 2020 13: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? 

  1. DataWindow
  2. PowerBuilder (Appeon)
Git client error code: Unexpected EOF
Graph Object contemporary
Responses (1)
Chris Pollach @Appeon
Chris Pollach @Appeon Accepted Answer Pending Moderation
  1. Tuesday, 26 May 2020 18:51 PM UTC
  2. PowerBuilder
  3. # 1

Hi John;

   Typically when this happens to me, it is when I do not have DBO authority on my DB connection User ID.

Regards ... Chris

Comment
There are no comments made yet.
  • Page :
  • 1


There are no replies made for this question yet.
However, you are not allowed to reply to this question.