Determine if a File is Open

I extracted "d:\test_dir\test.pdf". Then used ShellExecute to open it. The user reads the pdf and later I want to erase it. But, it will not erase if the user has not previously closed it. How can I tell if it is closed? Even better, is there a way I can close it? Carl Lindner --- St

Re: Determine if a File is Open

Probably the easiest way is just trying to open it and trapping the error. So assuming you know the file exists then lnHandle = fopen(lcMyFileName) if lnHandle = -1 * -- The file couldn't be opened so is open somewhere else. else fclose(lnHandle) endif To close it you would ha

CURSORTOXML and NULLs

While I'm poking away at this, I thought I'd check with the collective wisdom. I've found a situation where I want to take advantage of CURSORTOXML and XMLTOCURSOR. The issue I'm running into is if the cursor being converted to XML has fields with NULL values in the first record, this appears to

Re: CURSORTOXML and NULLs

I tend to create the cursor and use flags to append to the existing cursor. Tracy On March 29, 2022 7:01:47 PM EDT, Richard Kaye wrote: >While I'm poking away at this, I thought I'd check with the collective wisdom. >I've found a situation where I want to take advantage of CURSORTOXML and >XML

RE: CURSORTOXML and NULLs

VGhhdOKAmXMgYW5vdGhlciBwb3NzaWJpbGl0eS4gVGhhbmtzLCBUcmFjeS4g8J+Yig0KDQpUaGUg b3JpZ2luYWwgZGF0YSBzb3VyY2UgaXMgY29taW5nIGZyb20gYSBTUUwgYmFja2VuZCBzbyBJ4oCZ dmUganVzdCBhZGRlZCBzb21lIElTTlVMTCBjYWxscyBhcm91bmQgdGhlIGZpZWxkcyB3aGljaCBt YXR0ZXIgdG8gdGhlIENVUlNPUlRPWE1ML1hNTFRPQ1VSU09SIGNhbGxzLg0KDQotLQ0K

RE: CURSORTOXML and NULLs

Let’s try this again. (Stupid Outlook…) That’s another possibility. Thanks, Tracy. 😊 The original data source is coming from a SQL backend so I’ve just added some ISNULL calls around the fields which matter to the CURSORTOXML/XMLTOCURSOR calls. -- rk From: ProfoxTech On Behalf Of Tracy Pear