vfp

VFP .NET OLEdb provider does not work in Win 64-Bits. Help

I wrote a windows service using VB that read some legacy data from Visual Foxpro Databases to be inserted in SQL 2005. The problem is this use to run fine in Windows server 2003 32-Bits, but the client recently moved to Windows 2003 64-Bits and now the service won't work. I'm getting a message the the VFP .NET OLEdb provider is not found...

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 ...

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...

Migrating From Visual FoxPro

I work for a company that had a large number of applications based on Visual FoxPro. The company is now looking for a migration strategy away from VFP to another language for its desktop applications (and web applications using west-wind). There are two consideration to be made in the coming years (support for VFP from Microsoft will ...

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...

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...

Sql Server x64 and x86 Linked Server

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...

Custom development with "out of the box" Sharepoint

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...

Force messagebox to foreground

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...

Synchronisation between SQL Server 2008 Express and VFP tables

I'm looking for advices and suggestions on how to synchronise data between two databases. The first database is a SQL Server 2008 Express that run on disconnected laptops (no network or internet access). The second database (main) is a VFP 9.0 that run on a server. When the user connect their laptop on the network, I want the synchroni...

ARM processors implementing ARMv5TE and VFPv1?

Do there exist any ARM processors that implement the architecture version ARMv5TE (or ARMv5TEJ) yet also implement VFPv1 (as opposed to VFPv2)? I am writing some assembly code for ARMv5TE and I would like to assume that if a VFP is present, it is VFPv2. Were there ever any processors shipped with this combination? ...

Visual Foxpro modify general field

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...

VFP insert, index updating

So the main program is in C#. Inserting new records into a VFP database table. It was taking too long to generate the next ID for the record via select max(id)+1 from table , so I put that code into a compile dll in VFP and am calling that COM object through C#. The COM object returns the new ID in about 250ms. I then just do an ...

float to integer conversion using iPhones SIMD float unit

I am currently trying to optimize some DSP related code with Shark and found that I am wasting a lot of time in a float to integer conversion: SInt16 nextInt = nextFloat * 32768.0f + 0.5f; As the iPhone seems to have an ARM11 FP co-processor, I am wondering if I can replace my code with the FTOSI instruction. There is some documentati...

Calling a FoxPro Report from .Net

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...

SVN and Visual Foxpro Databases

Has anyone tried including Visual Foxpro Databases (ver 7) in SVN? What were the advantages/disadvantages of including it in? What is the best approach to handle VFP Db in SCM when there are rows that needs to be included in the source control? ...