I am trying to use a basic prompt in the universe and getting an error message.
Here is an example:
@Prompt(‘Enter the Log Name’,‘A’,)
The error I am receiving when I parse the Query is :
ODBC Error : Syntax Error in From Clause.
I have also attached the error as a screenshot.
What I do not understand is that why is the error showing FROM clause. DO I need to specify Table Name?
Please advise
Masonlko (BOB member since 2010-06-11)
Your prompt is not complete.
A prompt has to be associated to a column in your query, so you have given an example, but if this is what your code looks like, then that is why it doesn’t work.
Yes a prompt does need an association to a table and it gets this by way of the column that you associate it to.
You will really need to provide a little bit more information about what exactly your are trying to do with the result of the prompt.
A working prompt might look something like this:
customer.customer_no = @prompt('Enter Customer No: ','A',,,)This prompt will parse as its associated to the table ‘customer’.
plessiusa 
(BOB member since 2004-03-22)