|
|
|
EasySQL4Fox
Downloads:
| Views:
|
If you're a FoxPro developer who's tried to use MS SQL, you've undoubtedly discovered that SQL's syntax is different from that of the FoxPro implementation of SQL. I've developed a solution that converts FoxPro SQL syntax to T-SQL syntax in a single function call. This functionality is in the form of an EFoxSQL.FLL which converts FoxPro SQL statements to T-SQL. In addition, For VFP 8 users, I've also included EFox_Data_Adapter, a data adapter class that provides support for such FoxPro functionality as LOCATE, BROWSE and others . Actually a purpose of this class is to create a simple level of abstraction of application from the access-technology (File-Server or Client-Server). To use EasySQL4Fox, you simply attach a EFoxSQL.FLL library (Set Library to EFoxSQL.FLL Additive) and replace every SQL statement in your code with a call to our E_SQL_Select_Convert function. For example, if your MAIN contains a logical variable called UsingSQL that's .True. for SQL access and .False. for DBF access, you can use this: If UsingSQL Cmd = E_SQL_Select_Convert(OriginalSelectCmd) IF SQLEXEC(connection_id, cmd, alias) <= 0 * Error message display here... ENDIF ELSE &OriginalSelectCmd ENDIF You can certainly do the same by hand; however, a tool that does all of these things, and does them correctly the first time will probably pay for itself pretty quickly. See HTML manual included for more information.
|
 |
|
|
|
Author: Pinter Consulting | License: Freeware
Version: 1 | Size: 58 KB | Platform: Win98,WinME,WinNT 4.x,Windows2000,WinXP,Windows2003
Date Released: 05-01-2005
Homepage | Download
|
|
- EasySQL4Fox - If you're a FoxPro developer who's tried to use MS SQL, you've undoubtedly discovered that SQL's syntax is different from that of the FoxPro implementation of SQL.
- CDBFinfo - The CDBFinfo Shell extension allows you to view brief information about a DBF file without opening it. The CDBFinfo Shell extension supports dBase III, dB...
- SwisSQL - SQL Server to Oracle Migration Tool - SwisSQL- SQL Server to Oracle Edition is an Automated Migration tool to convert Microsoft SQL Server Transact SQL stored procedures to Oracle PL/SQL equivalent code.
- CDBF Shell - The CDBF Shell extension allows you to view content or structure of DBF files in the Properties window without opening them. The CDBF Shell extension supp...
- AdventNet SwisSQL - Oracle to SQL Server - SwisSQL - Oracle to SQL Server Edition is an Automated Migration tool to convert Oracle PL/SQL stored procedures into equivalent Microsoft SQL Server Transact SQL code.
- SwisSQL - Sybase to Oracle Migration Tool - SwisSQL - Sybase to Oracle Edition is an automated migration tool to convert stored procedures implemented in Sybase Adaptive Server Transact SQL into equivalent PL/ SQL code.
- Arisesoft Winsyntax - Arisesoft Winsyntax - is a free PHP-code editor, with the context help..
|
|
|
Universal Explorer
Powerful windows explorer file manager and viewer.
Disk Size Manager
Analyses hard disk space and collects statistics.
Web Data Extractor
Email marketing software to extract specific contact.
 ListMotor
Email List Manager, operates with email stored in simple text files or csv files.
|
New