[[https://www.revelation.com/|Sign up on the Revelation Software website to have access to the most current content, and to be able to ask questions and get answers from the Revelation community]]


==== Edit Table Edittable: Is there a way to extract the data in internal format (OpenInsight Specific) ====
=== At 25 APR 2001 10:38:25PM Scott, LMS wrote: ===
 
{{tag>"OpenInsight Specific"}}
 
<QUOTE>
Hi All



Edit tables seem to be the in thing.



If I do something like



my_edtbl=GET_PROPERTY(my_win : ".MY_EDTABLE", "ARRAY")



the data comes back in external format ie all the dates are dd/mm/yyyy ie 20/04/2001 instead of the internal format 12164

which means when I am doing validation, first I have to convert all the external format data to internal format to process.



Is there an edittable property that lets me get and set the data in internal format?



Scott
</QUOTE>
----

=== At 26 APR 2001 04:08AM Oystein Reigem wrote:  ===

<QUOTE>Scott,



From the Help docs:



INVALUE property



Applies to	Database associated controls.



Description	Sets or retrieves DEFPROP property of the control in internal format. The conversion is based on the conversion format defined for the control. If the control specifies default conversion, then the conversion pattern will reflect the contents of the dictionary column associated with the control, if any. No conversion is made if no conversion pattern is specified.



- Oystein -

</QUOTE>


[[https://www.revelation.com/revweb/oecgi4p.php/O4W_HANDOFF?DESTN=O4W_RUN_FORM&INQID=NONWORKS_READ&SUMMARY=1&KEY=5B9FC62C9A89CF7C85256A3A000E8144|View this thread on the  forum...]]