Subject | Re: QT and embedded FireBird database creation |
---|---|
Author | certfb |
Post date | 2011-02-04T10:22:48Z |
Like Peter, we also create the empty database first rather than in the application. Would be interested to know if you succeed though.
Sorry if I am teaching my grandmother to suck eggs, but a couple of hints for using Qt...
1. We found very little performance benefit by using the QIbase driver's transaction / commit commands;
2. If you are using QSqlRelationalModel then make sure you have your primary and foreign keys set up;
3. Again with QSqlRelationalModel if you update the foreign table, you need to commit and reselect the relationship (I forget the exact sequence of commands) if you don't then any inserts or updates will fail;
4. Again with QSqlRelationalModel! if you want to use ::filter() then you need to use Qt's strange naming mechanism for the filtered fields (sorry this probably isn't clear but if you run into trouble let me know and I will look up the exact actions);
5. Don't forget to use canFetchMore() and fetchMore();
On the whole though Qt works very well with Firebird indeed. For me the combination has a learning curve only about double that of Access and is 100x more useful. Really interested to hear other Qt/Fb users.
Sorry if I am teaching my grandmother to suck eggs, but a couple of hints for using Qt...
1. We found very little performance benefit by using the QIbase driver's transaction / commit commands;
2. If you are using QSqlRelationalModel then make sure you have your primary and foreign keys set up;
3. Again with QSqlRelationalModel if you update the foreign table, you need to commit and reselect the relationship (I forget the exact sequence of commands) if you don't then any inserts or updates will fail;
4. Again with QSqlRelationalModel! if you want to use ::filter() then you need to use Qt's strange naming mechanism for the filtered fields (sorry this probably isn't clear but if you run into trouble let me know and I will look up the exact actions);
5. Don't forget to use canFetchMore() and fetchMore();
On the whole though Qt works very well with Firebird indeed. For me the combination has a learning curve only about double that of Access and is 100x more useful. Really interested to hear other Qt/Fb users.
--- In firebird-support@yahoogroups.com, Peter Lee <ptle@...> wrote:
>
> No... but haven't really tried all that hard. We ship our applications
> with an 'empty' database that has tables, indexes etc (for each
> platform) and then use that. We create databases with both ISQL and
> IBPP during our build process.
>
> Regards,
>
> Peter Lee
>
> On 2/02/2011 8:58 PM, seasoned_geek wrote:
> > Has anyone managed to create a database with the embedded version of Firebird and Qt WITHOUT having to use the Firebird API?
> >
> >
> >
> > ------------------------------------
> >
> > ++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++
> >
> > Visithttp://www.firebirdsql.org and click the Resources item
> > on the main (top) menu. Try Knowledgebase and FAQ links !
> >
> > Also search the knowledgebases athttp://www.ibphoenix.com
> >
> > ++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++
> > Yahoo! Groups Links
> >
> >
> >
> >
>
> --
> Peter Leeptle@...
> -----------------------------------------------------------------------
> Rising Software Australia Pty. Ltd.http://www.risingsoftware.com/
> Publishers of 'Auralia' - Ear Training and 'Musition' - Theory Training
> Ph: +61 3 9481 3320 FAX: +61 3 9481 3380 USA Freecall: 1 888 667 7839
>