Hi Friends,
i am Calling Stored Procedure with Free Hand SQL in Teradata using
TeradataODBC DSN here i am using 5(five) @prompt to accept user input to
stored procedure in which
2 are must and in remaining three either 2 or one, please dont confuse
let me write code below:
Here first two are must and in next three either (Enter three )or
(Enter four and Enter five)
if user want to enter date in three then he should enter four and five
as zero(0)
if user want to enter data in four and five then he should enter three
as zero (0)
i want to validate user input in business objects b4 going to Database
Teradata
…can you give a little more detail. Do you really need to have the other prompts appear if they are zeros? If not, you can follow this thread https://bobj-board.org/t/24319 and do your coding from VB.
Sorry for the long delay in getting back to, I’ve been traveling.
Why don’t you just build your logic into your stored procedure using nested if statements as in. Although you will need to change your prompt type.
‘N’ is number, I believe you stated date for this field.
In any case, you should be able to build your validation into your SP.
If isdate then =0 and =0… so on and so forth.
I’m not sure what your backend is so you may need to change the syntax to meet your needs. You may even need to write a function for user input and then call the function from the BO object in the universe.
The only other choice I can see is to write a vb variation of the thread I sent you, where the input box is displayed first and then other prompts can be filled in with a select case statement in your code.
(BOB member since 2003-10-22)