Posted inVisual Foxpro
Calculate next workday
Visual Foxpro code to calculate the next working day. Taking into account that our working week is from Monday (1) to Friday (5).
Posted inTools Visual Foxpro
Connection Strings
Listing of many types of connections strings to databases using several driver types. Tip from the YouTube clip “Everything You Wanted to Know About ODMC”.
Posted inVisual Foxpro
LDAP Query from Foxpro
Needing LDAP access to be able to create some sort of Single Sign-On (SSO), I googled and created this testcode that is able to query the LDAP and place the results in a cursor.
Posted inOffice Visual Foxpro
Outlook.Application
Using the Outlook.Application object to read e-mails from Visual Foxpro. Trying to read e-mail using POP3 or IMAP proved to be hell to me. Documentation is not present or hardly…
Posted inOffice Visual Foxpro
Read from Excel using MS ODBC
If you just want to read the contents of an Excel spreadsheet, there is an easier way using the Microsoft Excel (ODBC) Driver. In a previous post (Foxpro and Excel)…
Posted inSoftware Visual Foxpro
Installing Visual Foxpro on Windows 10 64bit
After replacing my computer, I needed to reinstall Visual Foxpro. I had the install disc contents, but whatever executable I started with: it kept on crashing. A Google search brought…
Posted inVisual Foxpro
Foxpro ReturnObject
Function to prevent problems during object creation to crash your program. When problems arise, your program might be unable to continue, but at least you can show the user what…
Posted inVisual Foxpro
Foxpro and Excel
It is very possible to automate spreadsheets from Visual Foxpro using VBA/ COM automation. Here I wil document the parts I need. Connecting to Excel oExcel = CreateObject("Excel.Application") if vartype(oExcel)…
Posted inVisual Foxpro
VFP: Create header files
Header files (.H) contain declarations and sometimes code. Software uses codes for specific actions or settings, but these codes are illegible for most humans. The header file for Microsoft Word…
Posted inVisual Foxpro
VFP: Check already running (NL)
Draait een programma al? Door jasperdg op 16 Jul 2007 Het is soms niet handig als je een programma start terwijl dit al draait. Vooral bij programma's die bewerkingen uitvoeren…