Converting VFP to VB/VBA/VB.NET/C#/C++?

[kjv1611]

thread1254-962816 is an example of something I would REALLY like to do, but I would prefer to start with VBA if possible, say within an Access Database, and then later move it out on it's on to a C# application or VB/VB.Net.

Does anyone have any suggestions/references that might be helpful for this type idea?

Thanks ahead for any info/suggestions.

--

"If to err is human, then I must be some kind of human!" -Me

 

[bborissov]

If you would like the code to be in VBA or C# why not ask in appropriate forum?

Borislav Borissov
VFP9 SP1, SQL Server 2000/2005.
MVP VFP

 

[kjv1611]

Well, I just thought that since this particular code was in VFP, and it was posted previously in this forum, this would be the place to start. Not to mention that if someone does program in VFP, then I would think there is a chance they would be aware of a conversion method/application for converting from VFP to another language, or at least a possibility.

It is not that I am asking how to program necessarily in a different language, but rather transfer what is programmed in VFP over to another, or possibly even another to VFP - I'd be willing to try either direction.

My initial desire on the matter, however, would be to convert this code over to VB in order to more easily adapt it into an existing Access database within the VBA code.

It may not even be a possibility, but it sure would be nice to tinker with if it were.

Any suggestions? Hopefully this is a little more accurate of a description.

--

"If to err is human, then I must be some kind of human!" -Me

 

[craigber]

You won't be happy with the results. Access is designed to be a "desktop database" for one to just a few users. Performance is slow (when using the Jet database) compared to VFP. If you convert to Access, you'll have to convert again to .Net. If you really want/need to convert, just do it once to .Net and be done with it.

Craig Berntson
MCSD, Visual FoxPro MVP,

http://www.craigberntson.com

Author, CrysDev: A Developer's Guide to Integrating Crystal Reports"

 

[kjv1611]

So, if the database is only used by 1 person at a time, would the performance difference still be an issue, in your opinion? At least, at this point, the application would only be used by one person at a time.

--

"If to err is human, then I must be some kind of human!" -Me

 

[craigber]

Performance also depends on the number of records. The Jet Database (commonly called an Access database) tends to break down at only a few thousand records.

Craig Berntson
MCSD, Visual FoxPro MVP,

http://www.craigberntson.com

Author, CrysDev: A Developer's Guide to Integrating Crystal Reports"

 

[pthalacker]

Well, I just thought that since this particular code was in VFP, and it was posted previously in this forum, this would be the place to start. Not to mention that if someone does program in VFP, then I would think there is a chance they would be aware of a conversion method/application for converting from VFP to another language, or at least a possibility.

I actually find the opposite to be true. It is much easier for me to translate from a language with which I am not familiar to one with which I am than vice-versa. So while it is relatively easy for me to translate VB to VFP, it is much more difficult to translate VFP to VB. I would go with Borislav's suggestion and bring the example code to a forum of experts in the desired target language.

pamela

 

[kjv1611]

pthallacker, thanks for that "spin" on the idea. I really do not have experience translating/converting between languages, so I'm only sorta guessing at who would best know the conversion process.

With some knowledge in VB, a little in C++, and some other various little things, how hard would it be for me to learn VFP well enough to use that? I have Microsoft Visual Studio 6.0 at home, the full version, including foxpro. Would that be what I would need to tinker with this VFP app?

--

"If to err is human, then I must be some kind of human!" -Me

 

[pthalacker]

I have Microsoft Visual Studio 6.0 at home, the full version, including foxpro. Would that be what I would need to tinker with this VFP app?

All you would need is the source code for the application. But I would upgrade to VFP9, especially if I were going to do much SQL.

pamela