BOB: Business Objects Board
Not endorsed by or affiliated with SAP

Register | Login 

Want to sponsor BOB? 
Want to sponsor BOB? (Opens a new window)  

General Notice: BOB is going to retire...please see details here.
General Notice: No events within the next 45 days.

Getting freehand-SQL queries using VBA macro


 
Search this topic... | Search SDK (VBA/ASP/JSP)... | Search Box
Register or Login to Post    Forum Index -> SDK (VBA/ASP/JSP)  Previous TopicPrint TopicNext Topic
Author Message
chittari
Forum Member
Forum Member



Joined: 14 Aug 2006

Posts: 4



PostPosted: Mon Aug 14, 2006 10:53 pm 
Post subject: Getting freehand-SQL queries using VBA macro

Hi,
I am new to BO/VB macros. Can I get some help of API to get freehand-SQL queries using VBA macro.

My BO version is 5.1.6

Thanks,
CC
Back to top
BO_Chief
Forum Fanatic
Forum Fanatic



Joined: 06 Jun 2004
ASUG Icon
Posts: 5585
Location: Somewhere on God's Land.


flag
PostPosted: Tue Aug 15, 2006 12:12 am 
Post subject: Re: Getting freehand-SQL queries using VBA macro

Your question is slightly confusing.!!

As per my understanding:
If you are looking to get the SQL from FH SQL Data Providers, then I have not tried for FH Sql nonod.gif

You can search in the forum, For FH sql Data Providers it might or may not be possible because it might not have exposed to VBA I think. ?

_________________
help us help you! make sure your post has the following elements:
Does it include BO version, Database, an error, a problem, a SQL for object or Condition ?
Does it include some sample data what you have?
Does it include any code you already tried ? (working or not..)
Did you explain what you want for results?
If any of those elements are missing,chances are you didn't post enough information for us to help you!


Last edited by BO_Chief on Tue Aug 15, 2006 1:00 pm, edited 1 time in total
Back to top
chittari
Forum Member
Forum Member



Joined: 14 Aug 2006

Posts: 4



PostPosted: Tue Aug 15, 2006 3:54 am 
Post subject: Re: Getting freehand-SQL queries using VBA macro

Thanks Chief. You got me right.

In such case, Is there any way to find the list of formula's used?
Back to top
Marek Chladny
Forum Advocate
Forum Advocate



Joined: 27 Nov 2003

Posts: 19341
Location: Bratislava


flag
PostPosted: Tue Aug 15, 2006 8:20 am 
Post subject: Re: Getting freehand-SQL queries using VBA macro

chittari wrote:
Hi,
I am new to BO/VB macros. Can I get some help of API to get freehand-SQL queries using VBA macro.

My BO version is 5.1.6

Thanks,
CC


Hi Chittari and welcome to B icon_mrgreen.gif B

in my BO 6.5.1 installation this VBA code gives me the SQLs of all data providers, free-hand SQLs included:
Code:

Sub DP_SQLs()
  For i = 1 To ActiveDocument.DataProviders.Count
     MsgBox "data provider " & i & ":" & Chr(10) & ActiveDocument.DataProviders.Item(i).SQL
  Next i
End Sub


I am not sure if that works in BO 5.1.6. Give it a try and see for yourself.

_________________
BO: BI 4.0, 4.1 | XI 3, 3.1 | XI r2 | 6.x | 5.x
DB: Oracle, MS SQL Server, DB2, Teradata, Netezza
HW: Win, Linux and AIX servers
www.perpendulum.com

Latest Blog Posts
• 2013-07-16 Number of reports in a WebI document
• 2013-04-01 Optional prompts in a universe
• 2012-06-08 Calendar table script for Oracle
Back to top
chittari
Forum Member
Forum Member



Joined: 14 Aug 2006

Posts: 4



PostPosted: Thu Aug 17, 2006 3:39 am 
Post subject: Re: Getting freehand-SQL queries using VBA macro

wow...that works..
Thanks a lot Marek Chladny
Back to top
Marek Chladny
Forum Advocate
Forum Advocate



Joined: 27 Nov 2003

Posts: 19341
Location: Bratislava


flag
PostPosted: Thu Aug 17, 2006 8:00 am 
Post subject: Re: Getting freehand-SQL queries using VBA macro

You are welcome. icon_cool.gif

Good to know that it works also in BO 5.1.6 yesnod.gif

_________________
BO: BI 4.0, 4.1 | XI 3, 3.1 | XI r2 | 6.x | 5.x
DB: Oracle, MS SQL Server, DB2, Teradata, Netezza
HW: Win, Linux and AIX servers
www.perpendulum.com

Latest Blog Posts
• 2013-07-16 Number of reports in a WebI document
• 2013-04-01 Optional prompts in a universe
• 2012-06-08 Calendar table script for Oracle
Back to top
Tejal Chauhan
Forum Member
Forum Member



Joined: 01 Mar 2020

Posts: 1



PostPosted: Sun Mar 01, 2020 6:24 am 
Post subject: Re: Getting freehand-SQL queries using VBA macro

Hi Marek,

In my code I am trying to log in to BO 6m5 opening report.
This works fine

My requirement is to get sql queries and print this Into msgbox Or cmd screen.
While trying to use your code of line it is giving me syntax error.
Back to top
Display posts from previous:   
Register or Login to Post    Forum Index -> SDK (VBA/ASP/JSP)  Previous TopicPrint TopicNext Topic
Page 1 of 1 All times are GMT - 5 Hours
 
Jump to:  

Index | About | FAQ | RAG | Privacy | Search |  Register |  Login 

Get community updates via Twitter:

Not endorsed by or affiliated with SAP
Powered by phpBB © phpBB Group
Generated in 0.0285 seconds using 17 queries. (SQL 0.0025 Parse 0.0009 Other 0.0252)
CCBot/2.0 (https://commoncrawl.org/faq/)
Hosted by ForumTopics.com | Terms of Service
phpBB Customizations by the phpBBDoctor.com
Shameless plug for MomentsOfLight.com Moments of Light Logo