Property Type via Script

[EAButNotForGames]

Does anybody know if it is possible to fill the Type field of a property element in its Property Tab via a script.
I can read it through PropertyTypeName, but I can't find a way to edit it.
I want to automatically generate Properties via a Script and define their Type (and maybe even the Initial Value) on specific conditions.

I can't even find that Type field of that property in the sql tables.

[Geert Bellekens]

It is definitely possible.

The easiest way to find out what is happening exactly, is to check what EA sends to the database.

If you have an MS SQL Server, you can use SQL Profiler. Other databases likely have a similar tool.

In case you don't have a tool like that, I would start comparing before and after a change, and see what happens.
I'm pretty sure it will either be in t_object, t_xref or maybe t_objectproperties(tagged values).
Once you know where it is stored in the database, it's usually pretty easy to figure out what field in the API you need.

Geert

[EAButNotForGames]

I figured it out. But weirdly I can't give it one of the types, that are shown in the drop-down menu of the type field in the property tab.
You have to set an existing element as the type.

[Geert Bellekens]

Not sure if this applies to your case as well, but for attributes there are actually two field.
One field
t_Attribute.Type is the name of the type
t_Attribute.Classifier is the ID of the datatype for this attribute.

The standard dropdown (int, string, boolean) only sets the type field. If you use Select Type, the Classifier will be filled in (as well as the type field)

Geert