I need to export the default field Captions and Option strings for language NL, version 2009 SP1.
How can I export them without manually table-per-table copy/paste to Excel?
We have no developer license or tools. (I tried the MergeTool but I have no permission to run the objects.)
0
Comments
My Blog - nav.education
I prefer to link an "Option field" table rather than "hard code" the captions in every single query.
Furthermore I'm creating a "business rules" database for checking if all fields on an certain table are filled in correctly for the company I work for. The users only now the dutch field names, so I need the caption of the fields so I can link them to the "business rules".
For Option fields: table name; field name; option no. (0,1,2,ect) ; caption ENU ; caption NLD
For table fields: table name; field name; field no. ; caption ENU ; caption NLD
Maybe someone with developer tools can create a simple CSV for me? [-o<
still need Option fields values...
Line 1 (2 fields): TableID;TableName
Line 2n (3 fields): TableID;LanguageCode,TableCaption
Line 3n (4 fields): TableID;FieldID;FieldName;FieldOptionString
Line 4n (5 fields): TableID;FieldID;LanguageCode;FieldCaption;FieldOptionCaption
Hmm, that's odd, it returns a number over 2000100000 for temp tables.
It seems to work for recref.GETTABLE too, and in 3.60.
Is this how you detect a TEMP table ?
TVision Technology Ltd