In OI 2.61 I had a subroutine that would read
field 6 from SYSREPOS the APP*OIWINEXEFORMNAME. 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 [email protected] </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
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