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

Resolved Using Graphics Mode to edit queries

  1. Issue
0
Votes
Undo
  1. Megan Brusoe
    Megan Brusoe
  2. InfoMaker
  3. Tuesday, 2 July 2019 12:59 PM UTC

Hello

I am attempting to use the graphics mode to edit some queries for reports I have set up in Infomaker. When I do this, I get the error "The FROM clause could not be interpreted successfully".

Can someone help me resolve this error or is there a different way to view graphics mode?

Thanks!

  1. InfoMaker
psr files cannot save as PDF, manually
Clipping Issue with column over two pages.
Responses (1)
Miguel Leeuwe
Miguel Leeuwe Accepted Answer Pending Moderation
  1. Tuesday, 2 July 2019 14:24 PM UTC
  2. InfoMaker
  3. # 1

Maybe a stupid question but:

- Are you connected to the right database when trying to do this?

- You can go to the menu "Design" > "Convert to syntax" (at least you can in "normal" powerbuilder IDE datawindow painter).

Try to delete all the double quotes. Check if maybe columnames or table names have been changed in the database or deleted.

Sorry that's all I can think of for now.

Which database are you using?

regards,

Comment
Load more comments
Miguel Leeuwe
  1. Miguel Leeuwe
  2. Tuesday, 2 July 2019 16:04 PM UTC
Sorry, I don't have Infomaker installed, but this might help you, even though it's for an older infomaker version:

http://infocenter.sybase.com/help/index.jsp?topic=/com.sybase.infocenter.dc37789.1252/html/imug/usergd_dwdefin_sql.htm

  1. Helpful
Miguel Leeuwe
  1. Miguel Leeuwe
  2. Tuesday, 2 July 2019 16:05 PM UTC
quote from previous link:

"

Click the Syntax tab to make the Syntax view available, or select View>Syntax if the Syntax view is not currently displayed.



You may need to use the scroll bar to see all parts of the SQL SELECT statement. This statement is updated each time you make a change.

"

HIH
  1. Helpful
Chris Pollach @Appeon
  1. Chris Pollach @Appeon
  2. Tuesday, 2 July 2019 20:20 PM UTC
Hi Megan;

You might be connected to SQL Server but still, pointing to the wrong database within SS. Check your DB connection either in the "DB Profile" or "Database" painter: of the IM IDE and see.

HTH

Regards ... Chris
  1. Helpful
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.