0

I want the user to be able to select certain checkboxes, in the background a sql query is created, depending on which selections have been made. Then a button is pressed to execute the query against an Oracle DB and results returned to page. Because the sql query will vary in construct I don't think I can use BCS as BCS would be pre-fixed and wont work with dynamic sql queries.

Is the BCS aspect correct and is this at all possible ootb or VS?

Thanks

Improve this question

1 Answer 1

Reset to default
0

A custom interface, with check boxes and a submit button with a dynamic query, you'll need to build a solution in Visual Studio.

Improve this answer
4
  • Thanks, am I correct about BCS and should it not be used? Commented Aug 12, 2016 at 14:37
  • I could be wrong, but I don't think it can be customized with a dynamic query. I have mine as SQL Views and pull those in via BCS. Commented Aug 12, 2016 at 14:53
  • So do you think I could directly connect to the Oracle DB from within the Visual Studio solution? Commented Aug 12, 2016 at 15:04
  • Yes. A quick google search brings up tutorials. Commented Aug 12, 2016 at 15:28

Start asking to get answers

Find the answer to your question by asking.

Ask question

Explore related questions

See similar questions with these tags.