Pinter Consulting

Publisher: "Pinter Consulting"

	EasySQL4Fox License: Freeware
	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\| Date: 05-01-2005 \| Size: 58 KB \| Download
	-