When I am executing a program, I sometimes need to make a call to another program to do a simple routine. My problem is that I need to use some files in my second program which I do not want to leave open because they are files that I am using in my current program, but can't change the record pointer. How do I close out the tables and such in my program that I make a call to without closing out the tables in my original program? Is there another command other than close tables?
Tek-Tips is the largest IT community on the Internet today!
Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!
-
Congratulations strongm on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!
making a call to a program from another
- Thread starter dawg
- Start date
YOU JUST RE-OPEN THE TABLE WITH ANOTHER NAME OR ALIAS SAMPLE.<br>
IF YOU HAVE OPEN A TABLE NAMED VENDORS WRITE THIS<br>
USE VENDORS IN 0 ALIAS OTHER_VENDORS SHARE AGAIN<br>
AND YOU CAN DO ANYTHING IN OTHER_VENDORS WITH OUT CHANGE THE POINTER IN VENDORS IS LAKE OTHER TABLE.<br>
<br>
GOOD LUCK<br>
IF YOU HAVE OPEN A TABLE NAMED VENDORS WRITE THIS<br>
USE VENDORS IN 0 ALIAS OTHER_VENDORS SHARE AGAIN<br>
AND YOU CAN DO ANYTHING IN OTHER_VENDORS WITH OUT CHANGE THE POINTER IN VENDORS IS LAKE OTHER TABLE.<br>
<br>
GOOD LUCK<br>
Steve Bowman
MIS
The key in the above post is to use both the "ALIAS newname SHARE AGAIN" this will only work if the table is opened SHARE to begin with
LordOfCode
Programmer
Although the above post have the right answer if you have to open many tables and you want to complicate your life you can create a DataEnvironment Object holding cursors and relationships as in the DataEnvironment of a Form. I know it's too complicated!
- Status
Similar threads
