foxpro

What FoxPro data tools can I use to find corrupted data?

I have some SQL Server DTS packages that import data from a FoxPro database. This was working fine until recently. Now the script that imports data from one of the FoxPro tables bombs out about 470,000 records into the import. I'm just pulling the data into a table with nullable varchar fields so I'm thinking it must be a weird/corrup...

Anyone programming in Visual Foxpro out there?

Is anyone programming in Visual Foxpro out there? I'm stuck supporting a legacy foxpro system. Wanted to know who else is out there is using Foxpro. Added 9/11/2008: Thanks to all of you who responded! ...

What's the easiest way to read a FoxPro DBF file from Python?

I've got a bunch of FoxPro (VFP9) DBF files on my Ubuntu system, is there a library to open these in Python? I only need to read them, and would preferably have access to the memo fields too. Update: Thanks @cnu, I used Yusdi Santoso's dbf.py and it works nicely. One gotcha: The memo file name extension must be lower case, i.e. .fpt, ...

Automatically floating all fields in a VFP report?

I want to set all the fields and labels on a VFP7 report to "Float" and "Stretch with overflow". I tried USEing the .frx file and doing the following REPLACE but it didn't work. Is there some other field I need to change too? REPLACE float WITH .T. FOR objtype = 8 ...

How to import a DBF file in SQL Server

How can you import a foxpro DBF file in SQL Server? ...

Foxpro App and removable drives problem

I have a foxpro app, that contains hard coded path for icons and bitmaps. That's how foxpro does it and there is no way around it. And this works fine, except that when a removable drive has been used but is not connected, and when is connected windows assigns the same letter as hard coded path, when opening any form that contains such p...

What problems do you encounter with VFP apps in a 64 bit environment?

I know that there are issues with the VFP OLEDB provider on 64 bit machines. ... but what issues do you encounter while actually running a VFP application - on a 64 bit machine? Has anyone had any experience in this area? My first thought was that it would just run as a 32bit app, without making use of the 64 bit power. However, I ran i...

Vertical Scrolling Marquee for foxpro

Anyone could point me to some code/give me ideas on how to create a smooth scrolling vertical marquee for VFP 8,9 Any help is appreciated. Nelson Marmol ...

.dbc --> .csv

I have a little utility that converts .dbc files to .csv files, trouble is, somewhere in the conversion some data is lost/destroyed/whatever. I input a.dbc into converter, it produces a.csv. I delete a.dbc,and then run a.csv back through the converter, and I come back with a "slightly" different .dbc file then I had started with. Does a...

How do I set a source control plug in default for Visual Studio 2008?

We recently installed Team Foundation Server 2008 and we are using it for both Visual Studio 2008 code and Visual FoxPro 9 code that we are still migrating to .Net. I had to install the TFS MSSCCI provider to get connectivity from the VFP9 IDE. That works fine, but Visual Studio now seems to get confused about which source control plug i...

FoxPro 9 compatibility with Windows Vista

What compatibility issues have you found when developing with Visual FoxPro 9 on Windows Vista? ...

What is the best way today to maintain clipper 5.3 code?

Are there any successor products on DOS, Windows or Linux? ...

LINQ with FoxPro?

Is there a reasonable way to access FoxPro databases using LINQ? ...

Visual FoxPro Compact Index File Format

I am trying to understand the file format of a Visual FoxPro compact index (*.IDX). I am currently referring to Microsoft's documentation for guidance. The index is a B-tree of 512-byte nodes. Each leaf ("exterior") node contains multiple entries. Each entry consists of four pieces of data: Row number [FIXED LENGTH] Duplicate byte cou...

How can you fix an error 1958 when using SET PRINTER TO on Vista 64bit in VFP 8

Our VFP 8 application is returning error 1958, which is "Error loading printer driver" when executing the following line of code SET PRINTER TO HP1200 on a customers Vista Business 64bit laptop. The HP1200 is a HP business ink jet model 1200. The customer removed and reinstalled the printer using the latest 64bit driver from HP. We...

Open FoxPro Table in VB.net 2005

I need to open foxpro free tables in vb.net using the oledb connection. But... i only need to get the column names. I don't really need to 'select' anything. I am trying to dynamically browse through all our free tables and set up a listing of every column from every file and xref that to another free table that contains a description o...

Losing ODBC connection with SQL Server 2005 Database

One of our clients has an application (FoxPro 9) running on top of a SQL Server 2005 backend. Intermittently, they are losing their ODBC connection with the SQL Server database. Below is the intial error information: Err Msg: Connectivity error: [Microsoft][ODBC SQL Server Driver][DBNETLIB]ConnectionRead (recv()). ODBC Err Msg: [Micros...

How do I extract the data in a FoxPro memo field using .NET?

I'm writing a C# program to convert a FoxPro database to XML, and everything works except the memo field is blank. Is there something I'm missing to convert that bit? I'm using C# .Net 3.5 SP1, Visual FoxPro 9 SP 1 OLE DB Driver. Connection string is okay, as all other data is being pulled properly. When I converted the FoxPro database...

Is a VFP uniqueidentifier the same as a Guid?

Hi I'm converting a foxpro database to SQL Server and some of the keys are VFP-generated unique identifiers - GUIDs I assume. Are these valid uniqueidentifiers? Can I just use the bytes and convert them easily into a uniqueidentifier in SQL Server? Thanks, Craig ...

Can I extract a file from a foxpro general field?

I'm porting a VFP 9 application to SQL Server. The VFP app has some tables with "general" fields in them. I get a byte array when query the field, and when I save it to disk, I can look inside and see it's a word document, or a Paint BMP, etc. From reading around, I've found that the general field is a proprietary format and contains a...