code
Remove Structural CDX or Memo flag from a table
The VFP low level file functions (LLFF) can be used to open a table as a file and read/write its header. The Table Header Record Structure is documented in VFP help under Table File Structure.
Note 1 Removing Structural CDX flag will effectively disassociate CDX file from the table but not delete the CDX file.
Note 2 Removing Memo flag will allow to open a table and access all fields excluding memo fields. Attempt to access the memo fields will generate an error.
Retrieve HTML from Clipboard
MSDN:
| This is sample code. Add error handling and adjust to your requirements as necessary. |
lcHtml = HtmlFromClipboard() IF NOT ISNULL(lcHtml) lnStartHTML = VAL(STREXTRACT(lcHtml, "StartHTML:", "")) lnEndHTML = VAL(STREXTRACT(lcHtml, "EndHTML:", "")) * If StartFragment is present, retrieve HTML fragment IF ("StartFragment" $ lcHtml)
Retrieving Windows TaskBar Size and Location
A location and size of the Windows Taskbar can be retrieved with SHAppBarMessage Function.
Array Browser utility
Array Browser utility is a development tool to view an array content in a Browse window. Useful in analyzing content of the arrays during development process.
How to change file attributes programmatically
There're many ways to change file attributes. It can be done through Windows Explorer, DOS ATTRIB comand, third party utilites, e.t.c. Also it can be done programmatically using Windows Scripting Host (WSH) or/and Windows API.
Preventing BackSpace key in a TextBox from moving a cursor to the previous control
Deleting characters in a TextBox with Backspace key doesn't stop when cursor reaches the beginning position but unexpectedly moves cursor to the previous control. It could cause unintended deletion of the data there.
Check if table is part of DBC
It is easy to find out if a table belongs to the open Database Container (DBC) using INDBC() function. Sometimes it's necessary to check it w/o referring to DBC itself.
Birthday Query in VFP
It's a common request to get a list of people whose birthday (or an anniversary date) falls into specified date range w/o regard to the year.
Deleting pages from PDF file through Acrobat automation
Detailed info on Acrobat automation can be found in Interapplication Communication API Reference from Acrobat 8.1 SDK or Acrobat 9.0 SDK at http://www.adobe.com/devnet/acrobat/?navID=downloads. Free registration may be required.
Birthday Query in MS SQL Server
It's a common request to get a list of people whose birthday (or an anniversary date) falls in the specified date range w/o regard to the year.
Recent comments
6 days 13 hours ago
6 days 13 hours ago
6 days 19 hours ago
6 days 21 hours ago
1 week 8 hours ago
2 weeks 8 hours ago
6 weeks 19 hours ago
7 weeks 2 days ago
7 weeks 2 days ago
8 weeks 2 hours ago