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
is the number of seconds since the Unix Epoch (January 1 1970 00:00:00 GMT)
Convert Excel serial number date to VFP date
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.
Convert Color to RGB
This is sample code. Add error handling and adjust to your requirements as necessary. |
Convert Color to HTML
This is sample code. Add error handling and adjust to your requirements as necessary. |
Changing Command Window Font Programmatically
This code uses Editor functions from Foxtools.fll. See George Tasker's Extended Foxtools Help Download #9333 on UT for more info.
Basic Credit Card Validation
Based on http://www.beachnet.com/~hstiles/cardtype.html