... Mike, I would personnally NOT use a db to store images. I would store path to them & save them on your good old hard drive with a calculated set of ...
Hi nice groups :) I like to ask some basic questions about the embed firebird. Typical embedded DB engines permit to check the consistence of the tables, ...
Hi all, Are there programs around that are able to produce a graphical view of Interbase Tables / relations ? And which of them support Firebird ? And which of...
Hi, ... Someone posted just recently that it works, but the connection time seems to be slower than on Win2000 Server. The person didn't mention about the...
Hi, ... In FB 1.5, I know that there are indices added to the system table and a boolean type that was added. Other than that I don't remember. -- Best...
Hi, ... The automatic minor ODS version upgrade upon the first connect was the behaviour in Alpha and Beta(?), but it definitely isn't in RC1. Regards, Thomas...
Hi Can I revoke on all tables at one time ? I know I can do this: Revoke all on MyTable from public But can I do something like Revoke all on "AllTables" from...
Hi Michael, ... No, you really should use a GUI tool to do that. With regards, Martijn Tonies Database Workbench - the developer tool for InterBase & Firebird ...
Hi, ... PS: What you CAN do, however, is something like this: SELECT 'REVOKE <stuff> ON ' || RDB$RELATION_NAME || ' FROM PUBLIC;' FROM RDB$RELATIONS WHERE...
Hi All, AFAIK, Firebird 1.0 must use multiple database file when database file size reaching 4 Gb. IB 6.5 or later doesn't need it anymore. Does Firebird 1.5...
Michael, ... You can't, but you can generate a proper SQL script with the following query. select 'REVOKE ALL ON ' || rdb$relation_name || ' FROM PUBLIC;' from...
Ari, ... False. Firebird 1.0 already supports 64bit I/O. The max. file size also depends on the used file system and kernel (under Linux), but the engine...
Hi I have been able to get all the table names in a DB using (interBaseExpress): .GetTableNames Also for each table I can get the fields using: .GetFieldName ...
Hi, ... Thanks for the info. I probably picked up the Boolean information on Firebird-devel and didn't notice that it wasn't added. My mistake. Planned for...
Hi, ... Roles aren't defined on a server level, but on the database level. They are listed in RDB$ROLES. It seems you're pretty busy with the system tables -...
Michael, ... Roles are database specific and not server-wide like FB users. ... don't know if there is an IBX-way, but the following query works always. select...
... From the InstallNotes.txt of FB 1.5 RC1... ... <snip> 1.6. Compatibility with previous versions Name of the local IPC port is no longer compatible, i.e. ...
Thanks for the explanation Pavel, most of it was as I expected it to be. It surprised me that Fb chose to use an index for the smaller table if it can choose...
Dear Guys, I place before you an unbelievable job offer because earlier I could not believe this and now I am earning handsome income from this Home Based Job...
Set, ... You are absolutely right, whatever your choice look like ;-). For your information. Part I is targeted to people who are *new* or who want to...
