LAE

Welcome to the LAE community!  Please feel free to start a discussion in the discussion tab or join in a conversation.

Discussions

Members

Resources

Events

 View Only

  • 1.  Prompting for Input

    Employee
    Posted 01-14-2011 11:36

    Note: This was originally posted by an inactive account. Content was preserved by moving under an admin account.

    Originally posted by: Richard Peter

    I used Oracle Discoverer in the past. With it I was able to run a query and have it pause to prompt me for an input. For example, I was able to have it ask me to input a model number and when I hit enter it would continue with the execution of the query.

    Is a similar feature available in BRE?


  • 2.  RE: Prompting for Input

    Employee
    Posted 01-14-2011 12:10

    Note: This was originally posted by an inactive account. Content was preserved by moving under an admin account.

    Originally posted by: timonk

    Richard,

    Nodes in BRE do not have the ability to pause sql queries and prompt for input. Once a query has been launched, it will run to completion (successful or otherwise), or the node can be cancelled by the user.

    The closest thing you have to controlling your input is to use the DB Execute node's ability to take an input. See your BRAINScript help for the DB Execute node, and the sqlSelect command.

    # For Oracle (OCI)
    sqlSelect(1, "Select * from billing_data where state = :1", 'state')

    a) write to output '1'
    b) your query is between the double quotes. :1 is special notation.
    c)for each input record to the node, evaluate the ':1' in the query to the value of the 'state' field.

    This gives you some measure of control of what your query will look like based on graph input.

    Regards
    Timon Koufopoulos
    MDA Support


  • 3.  RE: Prompting for Input

    Employee
    Posted 01-16-2011 07:21

    Note: This was originally posted by an inactive account. Content was preserved by moving under an admin account.

    Originally posted by: Richard Peter

    Thanks Timon, I will look into that. It was a nice feature to have. I could write queries for others and they could provide the input when prompted rather than having to go into a node and make edits. For those who were'nt familiar with the software it worked very well.

    I appreciate your response and will make time to investigate the DB Execute node.

    Richard


  • 4.  RE: Prompting for Input

    Employee
    Posted 01-18-2011 08:26

    Note: This was originally posted by an inactive account. Content was preserved by moving under an admin account.

    Originally posted by: jodycrutchfield

    Richard,

    You could have them update a file somewhere that can be read by a graph instead of having them update a node.

    Jody


  • 5.  RE: Prompting for Input

    Employee
    Posted 06-20-2011 15:01

    Note: This was originally posted by an inactive account. Content was preserved by moving under an admin account.

    Originally posted by: Richard Peter

    Hi Jody, Thanks for the advice. I like that idea. Sorry for the late response. I saw your suggestion earlier but forgot to respond. Sorry but I didn't mean to be rude.


  • 6.  RE: Prompting for Input

    Employee
    Posted 12-28-2011 06:37

    Note: This was originally posted by an inactive account. Content was preserved by moving under an admin account.

    Originally posted by: abhiban1

    Can Lavastorm process an Oracle database file to run normal db/csv file queries on??


  • 7.  RE: Prompting for Input

    Employee
    Posted 12-28-2011 08:22

    Note: This was originally posted by an inactive account. Content was preserved by moving under an admin account.

    Originally posted by: timonk

    I'm not quite certain what you mean by an oracle database file. You mean input an actual .dbf directly?

    Regards,
    Timon