Visual FoxPro And FirebirdSQL

FirebirdSQL is a great open-source SQL database that works great with Visual Foxpro. Feel free to read and contribute!

i know, i know, my next post was supposed to be about connecting to firebirdsql database tables via an odbc connection. i promise it is coming, but in the meantime, i had an epiphany the other day and i wanted to share it.

the elite foxpro programmers out there will probably think this is a silly thing to write about and something that i probably should have known all along, but i really think what i learned by accident points to something bigger that everyone should take the time and think about. but before i get to the moral of… Continue reading

ok, in the last post, i explained how to install firebirdsql with the basic (and perfectly acceptable) default settings. when i first decided to start working with firebird, i was intimidated because i really didn't know that much about sql and working with the included isql.exe command prompt seemed a bit cryptic to me. if you've been working with sql commands for a while, maybe you'd feel differently, but i needed a way to visually work with the tables, triggers, and domains like i've become used to in foxpro.

after initially trying a freely available product called marathon, i ran across a program called ems sql manager for interbase/firebird… Continue reading

i described in a previous post some of the work we've done with firebirdsql and now it is time to get to work. firebirdsql is a relational database that runs on linux, windows and many different unix platforms. it was originally developed in 1981 and has existed under various names and incarnations since that time. before being released as open source, it was a commercial product published by borland as interbase. on the firebirdsql (http://www.firebirdsql.org) website you will still find many references to interbase and even some links into the existing interbase community. as firebird moves forward, it… Continue reading

in 2006, i was approached by my client using the agenttrax sales management system that i began working on in 2000, because they wanted a web-based front-end to allow their agents (at the time numbering around 8,000 active agents) to contract online as well as to have a place for active agents to enter their sales production and distribute that workload out to the agents making the sales. having sold a pre-packaged app using firebirdsql as the database, we had a little bit of experience with firebirdsql so it was an easy step to decide to use it as our database as well. after… Continue reading

having just returned from foxforward 2007, i can say that the recovery process may never be over. i saw more things that i want to implement than i have time to implement, but i'm making a solemn promise to try get them all done. foxforward 2007 for me was simply one of the best experiences and i highly recommend the conference to anyone wanting to learn more about vfp as well as many other technologies as well.

meeting people from all over with different backgrounds and experiences always can help broaden your horizons and when each person you meet… Continue reading