We have a bit of a messy database situation. Our main back-office system is written in Visual Fox Pro with local data (yes, I know!) In order to effectively work with the data in our websites, we have chosen to regularly export data to a SQL database. However the process that does this basically clears out the tables each time and does...
I have a Visual FoxPro table that I need to access from Sql Server. In Sql Server x86, I would just create a linked server. Unfortunately, there is no x64 driver for VFP - so Sql Server x64 can't create a linked server to it. So far, I've come up with following options - none of which I'm particularly fond of: Set up an x86 Sql Server...
As a newbie to FoxPro (but an old-hand at Clipper), I'm a bit at a loss to figure out how to return an array from the following OLEPUBLIC class. edit: I've modified the code belw to take into consideration the remarks made by @Stuart below. DEFINE CLASS db AS CUSTOM OLEPUBLIC DIMENSION ada(1) && public scope for later return FUNCTI...
I know very little about FoxPro but have a project that requires working with a third-party application, based on FoxPro, and a .fxp file. The thrid-party app is a point of sale system and the makers of the software have provided a .fxp file that allows us to export product information into an XML format. The problem that I am running ...
I have a small office, and I currently use a Visual Foxpro Application that I wrote to handle all the data. It is time to buy a new server. It seems that there are problems with VFP and 64 bit operating system. Should I make the move to 64 bit and try to deal with the problems that arise, or buy a new server running the older 32 bit...
I need to create unique record id's in VFP based on mailing information: zip5, address, lastname, firstname. Once created, relational tables will be loaded in SQL server 7 with the unique ID's. Any suggestinos? ...
I am attempting to pull ALOT of data from a fox pro database, work with it and insert it into a mysql db. It is too much to do all at once so want to do it in batches of say 10 000 records. What is the equivalent to LIMIT 5, 10 in Fox Pro SQL, would like a select statement like select name, address from people limit 5, 10; ie only ...
I'm currently working on moving a legacy Visual FoxPro app to the web. Our plans included purchasing an application framework such as Strataframe or MM .NET, both VFP friendly, and also some third-party controls to speed up development. Well, we recently heard that we're probably going to have to host this app using "out of the box" Sh...
I've got a VBScript that calls a Visual FoxPro Instance and runs a VFP program. Part of this program produces a messagebox. However, if my script is run from the Windows GUI (rather than a Command Prompt), then the message box produced doesn't necessarily come to the foreground. In VBScript I have the following code: Set oVFP = Creat...
I have a sql server 2005 table which has xml store in a text field. I am wondering if there is an easy way (using TSQL) of retrieving the a value from the xml data without doing a line by line parsing of the text? Doing a line-by-line parsing is a possibility because the amount of xml is pretty small. However, if possible I would like ...
Hello, I am trying to pull data from DBF files into my program using C#. I am using the Visual FoxPro OLE DB Provider. It works fine on my local machine but I want to package up my program into dll that clients can use. The problem is when they run the program from their machine it says that the Visual FoxPro OLE DB Provider isn't regi...
If I attempt to gain an exclusive table open in FoxPro, it generates a dialog box if access is denied. Since I'm targeting an non-interactive application, is there a way to detect whether the operation will succeed, or at least have it fail silently? ...
Hi, I'm writing a C# program to get FoxPro database into datatable everything works except the memo field is blank or some strange character. I'm using C# .Net 2.0. I tried the code posted by Jonathan Demarks dated Jan 12. I am able to get the index but i don't know how to use this index to fetch the data from memo file. Pleaese help m...
I have a DBF file on a network share that I'm trying to select into a SQL Server table. This query: SELECT * FROM OPENQUERY(MyLinkedServer, 'SELECT * FROM DP') ... throws this error: OLE DB provider "MSDASQL" for linked server "MyLinkedServer" returned message "[Microsoft][ODBC Visual FoxPro Driver]Not enough memory for file map.". ...
We have a problem, that client has Office 2007 with Latvian language pack. In that problem the same FOX PRO code that creates Excel report fails on creating PivotalTable. See failing code line below: oPivotTable = oPivotCache.CreatePivotTable("Sheet!R1C5", "PivotTableName", 1) Without installed language pack all works fine! ...
Firstly, I am not a VFP programmer, so what I'm doing wrong is probably something simple. I'm trying to extract some documents out of general fields in a VFP 9 database. I have a way of doing this by effectively copying and pasting the field into Word and then saving the Word document off to disk. I have this all working inside the fox...
Has anyone out there got experience of calling a Visual FoxPro report from a .net application? They want to both see the report and print it. I have to migrate a FoxPro application to .Net and the client would like to keep the FoxPro database + reports but place a new .Net front end on it. They have extensive Fox reports that they woul...
Hi im in the process of building a system that generates printed letters (around 1000 a day) that get sent to our customers and was wondering what are some good tools to use for this. So far i have looked into using Crystal reports and MS Fox pro reporting but find them frustrating to use. Anyone got any good suggestions? SQL repor...
I have a foxpro database that we are trying to write to using MS Access 2007 via a VFP ODBC driver (The driver is version 6.x) Are there limitations in doing this? No matter what we try we are not able to write to the foxpro data tables. We are using ODBC It is the MS VFP driver The Foxpro and access DBs are on the same system The OD...
Hi I'm writing an small software that will be part of an existing application which uses dbf foxpro tables. My application just reads 2 tables fill a dataset and closes the connection, pretty fast and simple. It works until one of those tables are being used or by foxpro itself (when the table is opened) or by the main application when ...