Thank you David, I downloaded the UserGroupDB.sql and I'm going
to learn a lot from it.
I used IBExpert to open it and create database. IBExpert gave
error when I tried to execute the script. It complained that
'TIME' is not defined in 'Dialect 1'. I solved this by adding
'SET SQL DIALECT 3;' on top of script. And then it complained
that it cannot create UserGroupDB.GDB, so I changed its name
from .GDB to .FDB. Now it executed fine and I can play around
with the database using IBExpert, but when I put mouse over
database name then in a popup bubble it shows database name as
.GDB and Dialect 1. And using windows explorer I checked the
data directory and it showed both .gdb(836kb) and .fdb(.94MB) files.


--- In firebird-support@yahoogroups.com, "David Cornelius" <dev@c...>
wrote:

> "Employee" is a good test one. I also uploaded one to the Yahoo! Groups
> "files" page called, UserGroupDB.sql.
>
> --
> David Cornelius
> CorneliusConcepts.com
>
>
> ----- Original Message -----
> From: throwmail2000
> To: firebird-support@yahoogroups.com
> Sent: Wednesday, March 03, 2004 7:59 PM
> Subject: [firebird-support] Sample/example firebird databases
>
>
> Are there any freely available sample firebird databases.
> I'm new to firebird so want to get familiar with its
> design and syntax etc.
> So far I found two sample databases ibdemo.gdb and employee.fdb
>
>
>
> Yahoo! Groups Sponsor
> ADVERTISEMENT
>
>
>
>
>
>
> Yahoo! Groups Links
>
> To visit your group on the web, go to:
> http://groups.yahoo.com/group/firebird-support/
>
> To unsubscribe from this group, send an email to:
> firebird-support-unsubscribe@yahoogroups.com
>
> Your use of Yahoo! Groups is subject to the Yahoo! Terms of Service.