visual-foxpro

Looking for a SQL-based RDBMS with a Windows GUI

I have an application I developed 20 years ago with INFORMIX-SQL version 2.10 for MS-DOS 5.0. I have it working on MS-DOS 6.22, within Microsoft Virtual PC 2007, under Windows Vista, but I would like to re-write this application with a WINDOWS-based RDBMS. I'm looking for a product, similar in functionality to informix-sql, but for wind...

How easy is it to convert an application from Visual Foxpro 6 to Visual Foxpro 9?

Are there any problems converting a Visual Foxpro 6 application to Visual Foxpro 9; or is this straight forward? Any gotchas that I should watch out for during the process? ...

SQL Join Problem

Table one contains ID|Name 1 Mary 2 John Table two contains ID|Color 1 Red 2 Blue 2 Green 2 Black I want to end up with is ID|Name|Red|Blue|Green|Black 1 Mary Y Y 2 John Y Y Y Thanks for any help. ...

SQL Joining on a one-to-many relationship

Ok, here was my original question; Table one contains ID|Name 1 Mary 2 John Table two contains ID|Color 1 Red 1 Blue 2 Blue 2 Green 2 Black I want to end up with is ID|Name|Red|Blue|Green|Black 1 Mary Y Y 2 John Y Y Y It seems that because there are 11 unique values for color and 100...

Analysing a Visual Foxpro application to derive requirements. Tools/approaches/practices?

Hello. In an upcoming project I am supposed to re-engineer a huge Visual Foxpro application into a web-application. The target platform is .Net. The application from the end-users' perspective is very complex (complex forms, reports, navigation, etc). The sorry state is that there are no documents available from which I can derive, busi...

Does VBA have an equivalent of "Text To" from Visual FoxPro

Visual FoxPro supports syntax such as the following: Text To VariableName TEXTMERGE noshow select * from..... EndText This assigns the value of all text between "Text To" and "EndText" to the variable. It eliminates the need for multi line statements separateed by "+ ;" Does VBA have something similar? ...

Updating Visual FoxPro from SQL Server

I'm trying to update some simple Visual FoxPro tables with SQL Server. I've created a linked server with the following: sp_addlinkedserver @server = 'UTIL', @srvproduct = 'VFP', @provider = 'VFPOLEDB', @datasrc = 'L:\M2MDATA\Util\util.dbc' GO And the following works: select * from UTIL...utcomp However, I cannot use the following...

How To Get A Field Value Based On The Max Of Another Field In VFP v8.0

So, I have a table and I want to get the value from one field in the record with the greatest DateTime() value in another field and where still another field is equal to a certain value. Example data: Balance Created MeterNumber 7924.252 02/02/2010 10:31:48 AM 2743800 7924.243 02/02/2010 11:01:37 AM...

jQuery AJAX converting variable string to html styled text

I've got an AJAX transmission of a variable string in my primary coding language (Visual FoxPro 9) that looks like this: AjaxResponse = CREATEOBJECT("Custom") lcMessage = "<li class='hello'>Hello</li>" AjaxResponse.AddProperty("Reply", lcMessage) Response.ContentType = "text/html" Response.Write(AjaxResponse.Rep...

ActiveX control loading but not activating correctly (only when using in Reg Free COM)

I have an ActiveX control (created using C#) that I am adding to a form in Visual FoxPro using late binding. It works without problems when I register the control. I want to use reg free COM and created necessary manifest files. Now it load and displays in an inactive state until I double click or programatically activate it. I don't t...

How to automate a build for a Visual FoxPro project?

I'm interested in figuring out how to automate a build from Visual FoxPro similar to how we can build .NET projects from the command line using MSBuild. It seems that it is possible to pass command line arguments to VFP.exe which may include the ability to specify some initial startup prg that runs however it is unclear how well starti...

Visual foxpro DBF update using php

I am using php to update some tables under VFP 9.0 using ADO COM. I am able to select and update the DBF until i specify any Where clause. The moment i add a where clause to the query, it simply returns or updates 0 rows. $conn = new COM("ADODB.Connection"); $conn->Open('Provider=VFPOLEDB.1;Data Source="C:\\testDB.dbc";'); $query = "...

Error in ADS OleDB when inserting data into VFP Database???

Hi! I need some help with the ADS OleDB Provider for Visual FoxPro. I'm trying to insert data from an 64-Bit .net-Application into a FoxPro Database. The table in which the data will be inserted has about 130'000 records, 139 fields and 11 indexes. Every time I run my sample application i get an error which says that the indexes are co...

Adding new record to a VFP data table in VB.NET with ADO recordsets

I am trying to add a new record to a Visual FoxPro data table using an ADO dataset with no luck. The code runs fine with no exceptions but when I check the dbf after the fact there is no new record. The mDataPath variable shown in the code snippet is the path to the .dbc file for the entire database. A note about the For loop at the ...

Hanging visual foxpro app - can I use userdump/windbg?

I have a visual foxpro 6 application which is hanging (100% CPU). Process explorer etc don't indicate any activity, so it is obviously in some kind of loop. For a .net or C app I would take a dump of the process when it is hung, and identify which method is causing the problem. Can a similar technique be done using foxpro, or any advi...

Visual Foxpro Array [] or ( )

Dear all, In a Visual Foxpro application one of the users get an error (the rest doesn't). And i believe its because arrays are used in the form of arr(number) instead of arr[number] . Does anyone know what causes this strange behavior at a single user? Thanks! ...

INSERT IN FOXPRO

I HAVE iNSERT TO TABLE AG_MAS IN fOXPRO FOLLOW: private void button1_Click(object sender, EventArgs e) { OleDbConnection connect = new OleDbConnection("Provider=VFPOLEDB.1;Data Source=pl_prov.dbf"); try { connect.Open(); string strSQL = "insert into ag_mas"; strSQL += "(ag_...

Visual Fox Pro, ODBC - I can't see .DBF tables in Visual Studio 2010

Greetings I'm making integration with application that is using ODBC Data Source - Visual Fox Pro Driver. In its dirrectory structure I've got two dirrectories (DANE and TRANS) which contains .DBF files. When I am using Visual Studio 2010 Server Explorer -> Data Connections to connect to DATA .DBF files, everything work fine. The proble...

visual foxpro connection string

hello, i have to extract some data from a foxpro database. I found a sample app that extracts data from a sql server db and stores the connection string in the app.config file in the following format - <connectionStrings> <add name="test" connectionString="Data Source=localhost\SQLExpress;Initial Catalog=test;Integrated Sec...

How do I read a Foxpro 8.0 database from c#?

I need to import tables from foxpro 8.0 to sql server. How do I read the tables & schema from a foxpro directory/files in C# so I can create the tables in SQL Server and copy the data over? ...