how to identify table from MFS (OpenInsight 32-bit Specific) [Revelation On-Line Wiki]

This page is read only. You can view the source, but not change it. Ask your administrator if you think this is wrong.
[[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]]


==== how to identify table from MFS (OpenInsight 32-bit Specific) ====
=== At 08 JUN 2005 09:31:10AM matt bavis wrote: ===
 
{{tag>"OpenInsight 32-bit Specific"}}
 
<QUOTE>
I am working with a MFS.  I have a need while the MFS is being executed to determine the Table Name.  Is there a way to do this that I am overlooking?  Of course during the MFS I have the file HANDLE, but is there a way to translate this into the table's name such as CUSTOMERS?



Thanks,

Matt
</QUOTE>
----

=== At 08 JUN 2005 09:52AM support@sprezzatura.com wrote:  ===

<QUOTE>There are various methods depending upon whether the file is indexed or not. The two favourite methods which work with both file types are to add the file name into the filehandle at open time and strip it out before passing it on, putting it back on the return (or changing a copy and passing this forward) or to store the name and handle in labelled common at open time and then locate on this.



support@sprezzatura.com

The Sprezzatura Group Web Site

[i]World Leaders in all things RevSoft[/i]

[img]http://www.sprezzatura.com/zz.gif[/img]

</QUOTE>

----

=== At 08 JUN 2005 03:13PM matt bavis wrote:  ===

<QUOTE>I am trying to use the method you described to store the handle and filename in a common at the time of open.  However, it appears the Handle value is for Revmedia, rather than the file I am opening.  Am I doing something wrong?



Thanks,

Matt

</QUOTE>

----

=== At 08 JUN 2005 03:21PM matt bavis wrote:  ===

<QUOTE>Nevermind.  I see it's in the Record variable, not the Handle.



Thanks,

Matt

</QUOTE>

----

=== At 09 JUN 2005 10:09AM German Gonzalez wrote:  ===

<QUOTE>Try with this in your mfs in code 1,2,3,4,5,6,7,8,9,10 



         FILE_NAME='

	 Pos=index(@TABLES(5), HANDLE,1)

         

	 If Pos then

		Pos=DCOUNT(@TABLES(5)1,Pos, @FM)

		FILE_NAME=@TABLES(0)

	 End

</QUOTE>


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