CRC16 - Polynom 0x8005

Relevant links: http://www.summitinstruments.com/knowledge_center/pdf/TN410.pdf http://www.lammertbies.nl/comm/info/crc-calculation.html?crc=1234567898765421&method=ascii

Copy, Move, Rename File Preserving Destination Name Case

The CopyFile() and MoveFile() WIN API functions preserve the case of the name for the destination file. Alternatively, WSH can be used. The source and destination file names should include the directory name in both cases.
Note 1 A Copy operation will not change file name case when destination file already exists (overwritten).
Note 2 The WinApiErrMsg is used to retrieve Windows API error message in case of error.

Copy Command Window Selected Text to Clipboard Programmatically

The code uses Editor functions from Foxtools.fll. See George Tasker's Extended Foxtools Help Download #9333 on UT for more info.

Converting ADO Recordset to Cursor with CursorAdapter

CursorAdapter can easily convert ADO recordset into a VFP cursor. It does not support conversion in opposite direction.

Convert Unix time to datetime

Unix time

is the number of seconds since the Unix Epoch (January 1 1970 00:00:00 GMT)

Convert Excel serial number date to VFP date

topic: 

Excel stores dates as the number of days since 1900-01-00. The number 1 represents 1900-01-01 and so on. The time part, if present, is represented as decimal portion. There's a bug in implementation of that sequence. It assumes that there was 1900-02-29 but 1900 is not a leap year. As result the code below correctly convert dates starting with 1900-03-01 only.

For more info about Excel dates see How to use dates and times in Excel and Dates And Times In Excel

.

Pages