[[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]]


==== Changes in SYSREPOS records from 2.61 to 3.4??? (OpenInsight Specific) ====
=== At 03 NOV 1997 10:17:45AM Steve Carlson wrote: ===
 
{{tag>"OpenInsight Specific"}}
 
<QUOTE>
In OI 2.61 I had a subroutine that would read 

field 6 from SYSREPOS the APP*OIWINEXE**FORMNAME.

The 2nd value in field 6 would be the DBTABLE name

that the form was using. I used this to open

the form's data table in my subroutine. THIS IS 

NOT THE CASE IN 3.4. 

HELP....  What record (FORMNAME) and field can I record 

to obtain the database table that is associated with 

the form.

Thanks... Steve Carlson   scarl@flash.net
</QUOTE>
----

=== At 03 NOV 1997 12:21PM John Duquette wrote:  ===

<QUOTE>Steve,



When the form is running you can get the TABLE property

which will show you what table the control is 

bound to.



If you want to check a table programatically you could

do something like the following:



Function GetTable(FormName)

Record='

Key   =@appid : '**' : FormName

Open 'SYSREPOSWINS' to h Else

Return 'ERROR'

End

Read Record from H , Key Else

Return 'No such form'

End

Val=Record

Return Val



The 3rd entry in my form was a database bound entry

so any bound control should have an entry in position 

23.



Let me know if you have any problems.



John Revelation

</QUOTE>

----

=== At 03 NOV 1997 03:29PM Steve Carlson wrote:  ===

<QUOTE>John,

Thanks... Field 3,23 from the SYSREPOSWINS record

worked perfect. This was for a generic Audit Trail subroutine

which writes the old and new records when a record

is changed, and also records whenever any user opens

any Form. It quit working a while back and I couldn't

figure out what happened 'til now. You saved me a lot

of looking. Thanks... Steve Carlson

</QUOTE>


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