to order online
Subscription info here.
to order online.
Tamar E. Granor,
Length: 24 pages (A4)
Formats Available: Printed (incl. electronic) or Electronic only
Printed format: A4 (210x297 mm or 8.3x11.7 in)
Electronic format: PDF
Single Issue Price ($US): 29.00 (printed+electronic) $19.00 (electronic only)
Press date: November, 2012
Printed issue availability: 2012/11 issue being mailed in December, 2012.
Electronic issue availability: Available for download.
Source code: Available for download.
November, 2012 - Number 29
Vive La Difference – How SQLite varies from VFP SQL
“We need to get away from DBFs” is a refrain I hear regularly from fellow developers. Be it due to perceived instability of the file format, the need for tables larger than 2 GB, or the result of political machinations, the result is the same – a desire to move to a SQL database back-end. SQLite can be an excellent intermediate step – and possibly the final word - in the process of restructuring your application to talk to a SQL back-end.
In the last three articles, I've shown you (1) how to connect to a SQLite database from VFP, (2) how to handle a variety of errors you may run into when connecting, and then how to use SQLEXEC() to send SQL commands from VFP to SQLite, and (3) how to move lots of data in and out of SQLite. In this article, I'll alert you to some of the differences between SQLite and VFP's SQL implementation.
Try Thor’s Terrific Tools, Part 1
[[Tamar E Granor]]
Thor makes developers’ lives easier with dozens of handy tools. In this series, Tamar takes a
look at her favorites.
Creating ActiveX Controls for VFP using.NET, Part 4
Doug concludes his series on creating ActiveX controls using .Net by looking at another way to create ActiveX controls and how to deploy them to your user’s system.
IntelliSense was introduced in Visual FoxPro 7. Many developers have extended it by creating scripts that are stored in the FoxCode.DBF table. Christof Wollenhaupt (with the help of many others) created a tool named ISX to extend IntelliSense without modification to the FoxCode table. Jim Nelson extends this excellent public domain utility, makes some of his own enhancements, and integrates it into Thor on VFPX.