foxpro

"Parameter is incorrect" error when invoking .NET assembly via COM component

Hello all! I have a .NET assembly that lives in the GAC. It is registered correctly so that it can be invoked by COM components. This .NET assembly contains a method and an overload to the method: public void Foo(string sValString, out string sOutString, string sOverloadString) { if( sOverloadString == string.Empty ) // d...

How to unload the default .NET AppDomain from an unmanaged application

Is there a way to unload the default .NET AppDomain from an unmanaged application? I'm using a third party tool called .NET Extender for using .NET assemblies from within Visual FoxPro which allows me to host .NET controls and also make use of .NET classes and methods from within a FoxPro environment. The problem I'm having is that whe...

FoxPro and .NET COM without registration

I use Unmanaged Exports to create a native .dll from .NET .dll so I can access .NET code from Delphi without COM registration. For example I have this .NET assembly: using System; using System.Collections.Generic; using System.Text; using RGiesecke.DllExport; using System.Runtime.InteropServices; namespace DelphiNET { [ComVisible(t...

VFPODBC very slow

I'm using an MS Access 2003 front end to access the data on a network drive owned by a Visual Foxpro 9 application via odbc, and it seems to be unbelievably slow - there's about 1400 records in one particular table, and it takes a good minute to load up on the Access interface, although when using a basic DBF viewer, or the application t...

how to open .d01 foxpro file

hey all, I am building a basic POS app for my cousin's pharmacy store so that he can dump the software he is currently using and save on license cost.All the medicines name which he has painfully entered into the software have been stored in a file with .d01 extension. What i want is a way to read the contents of the .d01 file programmat...

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

foxpro to pdf and pdf to foxpro

how will i convert pdf database converted from foxpro back to foxpro ...

How do I get the intellisense in FoxPro 8 to work with .net COM objects?

Hi, I'm at my wit's end with this. What I'm doing is making a C# dll file that needs to have some methods exposed to FoxPro 8. This guy here http://www.west-wind.com/presentations/VfpDotNetInterop/DotNetFromVFP.asp says that you can put [ClassInterface(ClassInterfaceType.AutoDual)] in front of the (C# in my case) class, and then intell...

How do I combine 3 date columns from 3 tables in Foxpro sql?

I am writing a foxpro sql & need to combine three date columns from three different tables into a new date column. As an example if the three tables are A,B,& C and the date Columns are Adate, Bdate and Cdate, how do I combine them as distinct and separate dates into a column called TransDate and in the SQL? I would appreciate samples of...

How to migrate data from FoxPro to MySQL

I am having a database in .dbf (FoxPro) format. How to retrieve data from FoxPro using Java? If the data can be migrated to MySQL, How to do the conversion? ...

Repair FoxPro Database - recommended tools?

Hi there - I know zilch about FoxPro, but we're using a product that has a FoxPro DB that we suspect has errors in it. Any recommended tools for analyzing/repairing? Someone mentioned DBFDoctor. Suggestions sought. Thanks! ...

FoxPro to WPF porting help?

hi friends, I am porting an application based on foxpro to WPF C# but i stuck in this window & i need your help. here is a screen shot of window Click Here. this is basically a wine shop billing part which allows to bill upto 99 items. Code col. allows to input item code and all description will come up. I am looking for something si...

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

Documents stored in SQL table

I have a legacy FoxPro application which stores documents in an SQL table in a field with the image datatype. FoxPro accesses the image datatype as a "General" field which can be used to store various files. I have a FoxPro control which interfaces with the General field for modifying/viewing the document that was stored. I need to migra...

Sub-total and total columns

In Visual Foxpro 9 I am trying to write an sql with a product "subtotal" column and a report "total" column. The sql code that works is as follows, but when I insert the commented out "Case" code I get errors that seem to increase as I correct the preceeding error. Can any one tell me in which place I should insert the "case" and what is...

Activate a (COM Interop based) ActiveX contol using registration free com

I have a (COM Interop based) ActiveX contol that I am trying to use with registration free com. When the control loads the control is inactive (does not responds to events, control not fully rendered etc). After much search I discovered that COM objects using reg-free-com use the miscStatus attribute to set the initial state to get corr...

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