Hi
>
>I have 2 other names on the list MySQL and FireBird as backend dataabses any suggestions?
A year ago I choosed Firebird from same two options (Postgres hadn't Windows version at that time) . I have no regrets yet and I'm very pleased to work with Firebird. MySQL has a lot of table handlers and table types and lacks features that I can't work the way I need without.
OTOH, Firebird has a well designed database engine, with record versioning (this means no lock escalation or lock conflicts for both read or write transactions, easy online backup and automatic crash recovery) and very flexible trigger support (unlimited number of BEFORE or AFTER triggers and posibility to specify trigger execution order)
I've almost finished a services API wrapper class for Firebird (will work probably with Interbase too).
Using this class, one can easyly invoke database maintenace (backup/restore), get database statistics or set database properties, add or modify users in security database, all within VFP applications. I think that I can post the class in download section soon.
Dorin
>>In addition to WC and WS (Martin's suggestion), there is ActiveVFP (
http://www.activevfp.com/activevfp.asp). There are also some others listed on the link. I haven't used them so I can't intelligently comment on them.
>
>All these alternative will keep us with FoxPro as a database, right?
>
>I have 2 other names on the list MySQL and FireBird as backend dataabses any suggestions?