I need to generate a list of all the Data Type that my database allows in the fields of each table, someone has any idea a function that I can get?
I need after validate the format, is there any other function to validate that right?
Thanks to all
The information you need is help in the VSTs of the database - in particular the _file and _field tables. You can query these in the same way you would any other table.
James thanks for the help, but that is not the doubt.
I need a list to print all data types permitted in progress. For example (character, longchar, integer, int64, logical .....)
Is this what you are looking for regarding available datatypes for Progress?
Apologies [mention:a6545b3daaeb482aa15fffb9662a0190:e9ed411860ed4f2ba0265705b8793d05] I misunderstood your question.
Exactly this information, but I need a function that returns me this information.
I am creating a combo-box for the user to choose the format of the field, but did not want to leave these fixed formats, I wanted the Progress was in charge of searching for data-types available.
I don't think this is available programmatically, although it doesn't change that often anyway... Do you really want them to be able to use all available data types?