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.
We use cookies which are necessary for the proper functioning of our websites. We also use cookies to analyze our traffic, improve your experience and provide social media features. If you continue to use this site, you consent to our use of cookies.