Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Downloads
Add
Search: 
Search

OLE DB Library for Visual FoxPro (beta version)
Alexander Golovlev, Epam Systems
OLE DB Library for Visual FoxPro provides an access to remote data sources using OLE DB data providers and retrieving query results directly into VFP cursors. It includes also object which performs conversion between ADO recordsets and VFP cursors. Data Source object provides read-write access to data in any opened cursor in VFP application and can be used as OLEDB data provider or as data source for data bound ActiveX controls.
Created on
22 years ago
Downloads
3324
File type
Rating
4.71/5.00
General information
URL:
OleDbFox.zip
Rating:
4.71/5.00 (7 rates) Rate this item
Description
OLEDB library for Visual FoxPro provides SQL Pass Through functionality with relation to OLEDB data providers. This library based on direct work with OLEDB and FoxAPI, and offers the fastest possible way of retrieving remote data from OLE DB providers into native VFP cursors. This library doesn't require ADO, but you can use ADO recordsets by means of provided RsToCursor and CursorToRs methods. Unlike VFPCOM it properly handles NULL values, supports long field names, BLOB and General fields, and works considerably faster. Installation. Unpack zip file somewhere and run "regsvr32 OleDbFox.dll". You may place msvcrt.dll into system directory. Workind with OLEDB datasources. 1. Create object: oConn = CreateObject("OleDbFox.Connection") 2. Open connection from UDL file: oConn.Open("mysource.udl") or from connection string: oConn.StringOpen(lcConnStr) 3. Execute SQL query with no result set: oConn.Execute("INSERT INTO Authors ...") to return result set into FoxPro cursor: oConn.Execute("SELECT * FROM Authors", "MyCursor") to return content of table into cursor: oConn.OpenTable("Authors", "MyCursor") 4. Close connection: oConn.Close() Workind with ADO recordsets. 1. Converting cursor into ADO recorset and back: oOleDb = CreateObject("OleDbFox.Utils") oRS = CreateObject("ADODB.Recordset") oOleDb.CursorToRs(oRS) ... oOleDb.RsToCursor(oRS, 'newcursor') 2. Converting cursor into XML and back: oOleDb = CreateObject("OleDbFox.Utils") oRS = CreateObject("ADODB.Recordset") oOleDb.CursorToRs(oRS) oRS.Save("result.xml", 1) oRS.Close() ... oRS.Open("result.xml") oOleDb.RsToCursor(oRS, 'newcursor') How to connect DSObject to data bound ActiveX control: USE employee IN 0 ds = CreateObject("OleDbFox.DSObject") da = CreateObject("DBADAPT.DataAdapter") da.Object = ds This.OleDataGrid.DataMember = "employee" This.OleDataGrid.DataSource = da How to use DSObject as OLEDB provider: * Initializing the OleDbFox library o = CreateObject("OleDbFox.Utils") USE employee IN 0 oRS = CreateObject("ADODB.Recordset") oRS.ActiveConnection = "Provider=MSDAOSP;Data Source=OleDbFox.DSObject;" oRS.Open("employee") Samples. The samples provided work with MDB databases in VB98 directory of Microsoft Visual Studio and SQL Server NorthWind database. In order to use other datasources you need to change connection strings in code. Utilities. This file includes DBImport utility which can be used for importing data from OLEDB datasources into VFP databases. Notes. This is a beta version. VFP7 is supported now. Async mode, parameterized queries and some other features will be added later. Any comments, suggestions and bug reports are welcome.
Created by
Alexander Golovlev, Epam Systems
Visual C++, ATL/WTL, C#, ASP.NET, WinForms, MS SQL

Comments
Add a comment
More downloads created from this member
GDI+ image class
Alexander Golovlev, Epam Systems
GDI+ Image class is a VFP class to load, save and transform BMP, JPEG, GIF, PNG and TIFF images. It provides also creating thumbnails, resizing, cropping and rotating, conversion to/from Picture object, copying to/from clipboard, capturing of screen or any window.
Created on
20 years ago
Downloads
6508
File type
Freeware
Rating
4.89/5.00
Decimal COM library
Alexander Golovlev, Epam Systems
This COM library performs arithmetic operations with 28 digits of precision using Decimal arithmetic system functions. The Decimal value type is appropriate for financial and monetary calculations requiring no round-off errors. Version 1.1 includes also basic mathematical functions (Sqrt, Exp, Log, ...
Created on
22 years ago
Downloads
969
File type
Rating
3.00/5.00
FastXtab
Alexander Golovlev, Epam Systems
This is a further development of Cross Tab Query sample. Now it made as VFP custom class that supports all input data types and can be used as a VFPXTAB replacement. And, of course, it still works with a large resulting datasets a hundred times faster than VFPXTAB. Test application included.
Created on
22 years ago
Downloads
4896
File type
Rating
5.00/5.00
Rename keys
Alexander Golovlev, Epam Systems
This sample demonstrates how to copy and rename keys in registry using WinAPI.
Created on
22 years ago
Downloads
706
File type