Hi, any one knows if there is a activex dll that can create VFP DBF files? I mean im writing app with 1C:Enterprise 8.2 language, and i need to export some datas into VFP DBF. And i can only use activex dlls in this language. Would be perfect to get free dll, but i can pay also if there is anything good. ...
hi all, can we connecting a dbase/foxpro .dbf file on linux using jdbc? thanks ...
I'm using NHibernate with Burrow and Fluent to shuttle data from SQLServer2005 into a directory full of FoxPro 7 dbf's. When I try to save a new record through Burrow's GenericDAO, I get an exception that boils down to "Field XXX does not accept null values," where field XXX is a NOT NULL field that is not being mapped at all because it...
I have to convert .DBF and .FPT files from Visual FoxPro to MySQL. Right now my script works for .DBF files, it opens and reads them with dbase_open() and dbase_get_record_with_names() and then executes the MySQL INSERT commands. However, some fields of these .DBF files are of type MEMO and therefore stored in a separate files ending in...
Hi! The files .fpt and .dbf(made in foxpro 8) have the text (readable for humans) which I need to get or at least to see. But I can't do that. MS excel sees not only the text but also a lot of symbols which make no sennse. So my question is how to extract the text from the files? Foxpro 9 can't open it saying that soandso.fpt is missin...
Hi How do i create a primary key index from two two or more columns in visual fox pro 9? The columns may be of different types ...
I've wrote a PHP script to export a Foxpro database to other formats by using ADODB (http://phplens.com/lens/adodb) library to access Foxpro OLE DB provider. Everything worked fine except the date fields are mangled and become like these: 11/17-/2-00 3/4/-20-08 By comparing to actual data I can guess that it is probably in the forma...
So I've recently had to create a report that emulates a Canadian customs form. The problem is that the report is printed on 11" x 14" paper, but uses a metric layout. As my FoxPro installation is on a machine with US-English units-of-measure, FoxPro tries to oblige by using an English ruler, and doing snap-to-grid on inch-based measure...
This is more of a general question about which direction would be a better investment for the company. Our company's core business application is written in Visual FoxPro and is about 9+ years old. The database is huge 15+ gigs and the core logic is complex and to make matters worse the data model is terrible. The two guys that built i...
I need to obtain a list of tables in a Visual Fox Pro database. (7.0) This is what I'm doing.... but it's not working or I'm not doing it right... DataFactory dataFactory = new DataFactory(); dataFactory.CreateOldStarbaseConnection(); dataFactory.OpenOldStarbaseConnection(); OleDbConnection oldStarbaseConnection = dataFactory.OldStarb...
Ok we have a WCF service running on one machine on IIS6 + server2003 r2 this service needs to write and read to/from a fox pro database that is located on another machine on the network - windows 2003 (probably r2). After playing with permissions (both on the fox pro file and impersonation in WCF) we have finally managed to read from i...
hi, I have a simple form with a grid where by the user enters data to save by a click event.Initially it worked well but after a while (and a few modifications later),when one hits the save button,it appears saved on the grid.But after closing the screen and re-opening,the data dosen't appear anymore.I tried looking at the tables and no...
This seems like such an easy problem, but I can't seem to find a solution anywhere. My co-worker and I are working on an application that makes use of the Foxpro xml dump facilities. It works great, but we're wishing to split the table into multiple files based on some size constraints. This seems like it should be the easy part: How...
Title says it all. It appears to be extremely difficult to design a generic test harness for Pro Series because of the way forms are invoked, etc. The problem I face is that while I can invoke each form, and the logic for the form is (generally speaking) logically separated in a different class, there is to my knowledge no way at this ...
I have an old school foxpro web app that I am trying to help limp along while I rewrite the system. Every day, multiple times, I get this following error message: The specified network name is no longer available. Does anyone have any suggestions how to troubleshoot this? Perhaps, prove to my IT guys that there really is a network iss...
Scenario: I need to pull information out of a Visual FoxPro database; however, running large queries against this has a tendency to lock the system up. To resolve this, we put limits in place that cancelled the query if it ran past a certain amount of time, and limited the number of rows it would return. Is there a way to have a query...
I am looking for a code snippet/library to read data from third party foxpro DB over the Net using php/Java from a Linux server. Is there any library available? Some people seem to be using Dbase library for php? Does that work? What parameters do i need from the Foxpro DB other than the default (databasename, username, password). DBF ...
Using a Visual FoxPro 9 executable file, (EXE), I need to be able to place data into the system keyboard buffer which is then to be picked up by another program, (non-FoxPro). I've already tried using the KEYBOARD command, however, that only seems to work with fields and controls within the FoxPro application! Does anyone have any ideas ...
I want to enter the data in FoxPro but save the data in .xls format. ...
Title says it all. Sample connection string Provider=Advantage.OLEDB.1;Data Source=c:\Bugtest;ServerType=ADS_LOCAL_SERVER; TableType=ADS_VFP_TABLE Thanks in advance. Cetin ...