Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
VFP and FireBird
Message
 
To
04/12/2003 02:23:42
Dorin Vasilescu
ALL Trans Romania
Arad, Romania
General information
Forum:
Visual FoxPro
Category:
Databases,Tables, Views, Indexing and SQL syntax
Miscellaneous
Thread ID:
00855416
Message ID:
00855798
Views:
77
Dorin
So far i found your prg to move tables to FireBird, and also a way of creating a new Firebird database using API.
As a matter of fact, i am willing to test VFP with one of the Open Source databases, and in a recent poll in Builder.com or devx, users voted for FireBird, so that was my first natural choice.
I wouldn't mind testing Postgre or MySql if people here would recommend it.

Jaime

>Hi
>I searched myself for something like this in the past, but no luck.
>Firebird is well known in Delphi world because its compatibility with Interbase but I didn't found much informations about its use with Foxpro.
>Fortunately, all things regarding the use of VFP with a database server applies here.
>We have an application ported to use it as database server and currently I work on another project.
>
>Dorin
>
>>Thanks Esparta. I am also looking for specific samples or case studies of VFP with FireBird...
>>
>>Jaime
>>
>>>If do you want documentation about HOWTO: VFP+< YourServer > you will not get it in the Help of the product, luckyly VFP doesn't care about wich batabase server are you using, it only need a ODBC Driver (to work with Remote Views and SQL Pass Through -SPT-) or an OLEDB Provier (to work with ADO+RecordSets), or any of both if you are planning to use the CursorAdapter.
>>>So, you only need a to see VFP Help about the topics Client-Server or a generic HOWTO:VFP+RemoteView, HOWTO:VFP+SPT or HOWTO:VFP+ADO to solve this issue:
>>>
>>>--- Client-Server and VFP ---
>>>http://www.tedroche.com/Present/1999/E-CTECDoc.htm
>>>
>>>--- ADO JumpStart for VFP Developers ---
>>>http://msdn.microsoft.com/library/default.asp?url=/library/en-us/dnfoxgen/html/adojump.asp
>>>
>>>http://fox.wikis.com/wc.dll?Wiki~CategoryClient/Server
>>>http://fox.wikis.com/wc.dll?Wiki~ProgrammaticallyCreatingDSNs
>>>
>>>--- Why You Should Do Client-Server Development ---
>>>http://www.advisor.com/Articles.nsf/aid/FALIJ01
>>>
>>>--- Migrating Your Visual FoxPro Application to a Client/Server Platform ---
>>>http://www.eps-cs.com/pdf/whitepaper_migrating.pdf
>>>
>>>Of course, you will need to learn how your Database Server deal with internal stuffs like Stored Procedures, Integrity Rules, ANSI-SQL 92, etc.
>>>
>>>HTH.
>>>
>>>
>>>>Hi All
>>>>I am playing with the idea of tighting these two together. I saw some threads from Dorin, but i would appreciate some information about ways of implementing this.
Why do programs stop working correctly as soon as you leave the Fox?
Previous
Next
Reply
Map
View

Click here to load this message in the networking platform