Using SQL in BO?

sdk development
1

I am looking for way to access data in a database from BO Scripting. In VB it is very simple using a recordset. Is there a way to embed SQL in BO Scripting or possibly another way?
Thanks,
Venu

Listserv Archives (BOB member since 2002-06-25)

2

Venu:

Rather than limit yourself to the BO Scripting language, why not just use VB? We have implemented Reporter using OLE and found it to work with a few hitches here and there.

Good Luck,

I am looking for way to access data in a database from BO Scripting. In VB it is very simple using a recordset. Is there a way to embed SQL in BO Scripting or possibly another way?

Listserv Archives (BOB member since 2002-06-25)

3

Jay,

I am trying to implement a Custom Script for the document agent server & I need to pass a list of e-mail addresses that
the scheduled reports will be sent to after their execution.

If I am able to pass this list onto the Custom Script from a VB application that I am using to set the schedule options I
don’t even need the database.

Do you have any ideas ??

Thanks,

Venu Chakrapani
Project Leader
Lucent BusinessObjects Help-Desk
(w)(847) 673 0900 x129
venu@dunnsys.com
http://www.dunnsys.com

Listserv Archives (BOB member since 2002-06-25)

4

Venu,

Try doing this:

  1. create script which will add a variable to BOVariables called “distribution_list” and assign all the E-mail addresses separated by commas.
    Run this script before sending this document to das 2) Modify the custom script to read the bo variable “distribution_list” and use this list while generating e-mail.

Good luck

Listserv Archives (BOB member since 2002-06-25)

5

Hi,

It is very possible to do this, the functions are documented in the scripting language guide and they all start with SQL.

Example:
success = SQLRequest("",“Select distinct year from calendar”,4,0,yrs())

But there others that allow extra flexibility.

Hope this helps!

Phil Morris
Analyst Programmer
BITS dept.
Tarmac Heavy Building Materials UK Ltd.
PO Box 8
Ettingshall
Wolverhampton
West Mids
WV4 6JP

Tel: 01902 382183
Email: pimorris@tarmac.co.uk

“My own opinions are not necessarily those of my employer…”

Listserv Archives (BOB member since 2002-06-25)