Data Type List

Posted by victor.alves on 11-Dec-2014 06:02

Hello,

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

OpenEdge Development - Forum

All Replies

Posted by James Palmer on 11-Dec-2014 06:11

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.

Posted by victor.alves on 11-Dec-2014 07:05

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 .....)

Posted by Rom Elwell on 11-Dec-2014 07:11

Is this what you are looking for regarding available datatypes for Progress?

documentation.progress.com/.../index.html

Posted by James Palmer on 11-Dec-2014 07:13

Apologies [mention:a6545b3daaeb482aa15fffb9662a0190:e9ed411860ed4f2ba0265705b8793d05] I misunderstood your question.

Posted by victor.alves on 11-Dec-2014 07:21

Exactly this information, but I need a function that returns me this information.

example:

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.

Posted by James Palmer on 11-Dec-2014 07:43

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?

This thread is closed