Howto close only 1 table?

[MdVries]

********************************************
*My code
SELECT * FROM rolk1;
ORDER BY rolnummer, soort, rec_ord, id_ord;
INTO TABLE rolkaart;
********************************************


How can i close only the rolkaart table?

 

[ChrisRChamberlain]

MdVries

[COLOR=blue]USE IN rolkaart[/color]

FAQ184-2483 - answering getting answered.​

Chris
PDFcommander^tm.net
PDFcommander^tm.com

 

[bborissov]

Better:
USE IN SELECT([rolkaart])

That way if the rolkaart is not opened for some reason your program doesn't bomb ;-)

Borislav Borissov

 

[alvechurchdata]

USE IN SELECT([rolkaart])

Just in case you've not met it before, Fox allows [ ] as being equivalent to ' and " so this is the same as:

USE IN SELECT('rolkaart')

SELECT('rolkaart') gives us the workarea holding the table which was opened under the alias of 'rolkaart'. If rolkaart isn't open then SELECT() returns zero and, as Borislav says, your program doesn't bomb.

Geoff Franklin

http://www.alvechurchdata.co.uk