1. Megan Brusoe
  2. InfoMaker
  3. Tuesday, 02 July 2019

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!

Miguel Leeuwe Accepted Answer Pending Moderation
0
Votes
Undo

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
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. Miguel Leeuwe
  2. Tuesday, 2 July 2019
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. Miguel Leeuwe
  2. Tuesday, 2 July 2019
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. Chris Pollach
  2. Tuesday, 2 July 2019
There are no comments made yet.
  1. Tuesday, 2 July 2019
  2. InfoMaker
  3. # 1
  • Page :
  • 1


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