vfp

"wait window nowait" in .NET

Is there something similar to "wait window nowait" in Windows Forms (.NET VS2008) ? This is a commonly used sentence in Visual FoxPro for debugging purposes and "quick and dirty" thermometers. ...

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

Is it possible to get the client process ID of an application that runs on SQL server?

Hi all, For my VFP application, i have a program to check currently who is accessing the server (by using sp_who2), also another progam to check who is currently locking which table. But i wish to know which options my users is accessing at the moment. Am thinking if i can write a SP to get the current connected process ID for a spec...

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

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

How can i preserve column order in a .dbf table created in c#?

Hi I am trying to create a .dbf table using visual c# because i need it to import data to another application. For that purpose I need the column order to be exactly right otherwise that application won't accept the table. It's been working fine so far, but recently I had to make some changes to the structure of the table, and I have ad...

How to avoid ODBC parameterization for the question mark character ? within literals and comments?

I'm running into an issue where I have question mark characters '?' within my SQL scripts inside comments is causing problems. When I run these statements through an ODBC connection using the Visual FoxPro SQLEXEC function these characters are being seen as parameters and VFP prompts for values. What are my options for dealing with ques...

Foxpro: Check whether table exists via vfpoledb

I access data in .dbf files via System.Data.OleDb (vfpoledb.dll). How can I find out whether table exists via SQL command? Something similar to the following on SQL server: IF (EXISTS (SELECT * FROM INFORMATION_SCHEMA.TABLES WHERE TABLE_NAME = 'TheTable')) BEGIN --Do Stuff END ...

ADO OleDB Visual Foxpro

Hi. Specific question: Does VARCHARMAPPING=True work on Ado OleDB connections for Visual FoxPro? and if so how should the connectionstring look like? We're developing a Delphi application that uses parts of an old visual foxpro database as a base. This morning I had a working connection to the database that for all intents and purposes...

How to cast System.Object[*] to System.Object[]

When I Tried to return a Array in VFP9 languaje COM/DLL to my .net c# project I received a System.Object[*] array and I can not cast to System.Object[] (Without asterisk). ...

dotnet json webservice for vfp program to pass data as solution?

I am searching for a solution to pass a large dataset from visual foxpro(vfp) to a .net web service. The data is personal information such as names, address, phone numbers, etc. with 7 more columns containing id's and other parameters. We tried cursor to xml dataset but the file size is very large. So my idea is to pass json formatted...