Prompts - how to load data with prompts

[Mxmaverick]

Hi everyone, I want to know if using the prompts I can load data directly to a dataset, and after that, a way that all this is showned inside the prompt, or something like a quick view of the table with the new data. Many thanks

[Mxmaverick]

Hi everyone, I want to know if using the prompts I can load data directly to a dataset, and after that, a way that all this is showned inside the prompt, or something like a quick view of the table with the new data. Many thanks

[heffo]

Please don't double post questions. 🙂

[heffo]

I don't fully understand what you want to do. But a prompt is mainly used to select input parameters for the rest of your code. It is not specifically used to feed a table with data. 

The prompt generates macro variables that could be used in the dialog boxes in EG or in code. The code could of course use the macro to create data in a data set, but I don't think that you want this. 

If you want a way to look at a new data set and figure out what it is about, then prompts are not the way to go.

[heffo]

I suspect that you want is in a prompt be able to dynamically show a list of values from a data set. 

If so, then yes you can, but the table needs to be registered in the metadata. You can't dynamically point out the table in the prompt. 

If you on the other hand just want a static list of values from a data set, then you can add (import) those when you create the prompt. But, of course, if the data changes, nothing changes in the prompt.

[Reeza]

I've merged your questions and updated your subject, it was a bit vague.

Your question is unclear. Can you explain what you mean by load data directly to a data set? Are you intending to add records to a data set via a prompt? That is possible but not a great usage of macro variables.