BusinessObjects Board

Detecting "Do not generate SQL before running" fro

sdk development
#1

[Moved from Reporter to SDK - Anita]

Using the FC SDK, is there a way to detect that a given query is using static SQL (“Do not generate SQL before running” is checked)? I don’t mean detecting a Free-hand provider, just a provider where the developer altered the SQL BO generated.

Thanks,
Scott Patterson

scottpat (BOB member since 2002-08-15)

Search document with "do not generate sql" checked
#2

Scott,
I don’t believe you can do this.

However, if you build your dataprovider in VBA, then the SQL will be writable, so you can make sure this way that the sql displays what you want.

That’s the only thing I could think of…

Olivier Masse :fr: (BOB member since 2002-08-29)

#3

That is the conclusion I came to. I am building a couple utilities. One is a documentation generator. It is nothing special, just something that generates the majority of the doc. I would like to detect if the developer altered the SQL.

Thanks
sbp

scottpat (BOB member since 2002-08-15)

#4

The only thing you could do, providing you know your universe well enough, is to display the SQL as it is.

You won’t have any indicators telling you if it has been modified but if you know your universe well enough you should be able to see if the sql was modified.

Good luck with it…

Olivier Masse :fr: (BOB member since 2002-08-29)