Hi I would like to extract records that contain certain words in varchar fields e.g. I would like to filter messages that contain "bad" words. I have tried...
... select <whatever> from <table> where <field> containing <searchphrase> ... Magnus...
Magnus Titho
magnus.titho@...
Feb 1, 2005 8:44 am
54721
Helen, debtor for the aid. I am facing difficulties to insert long texts in fields blob in firebird using with IBExpert interface, that is limiting the size of...
Hi Diego! How many records (and fields) does this query return? And does it take longer returning the entire result set in the second case compared to the...
... a ... fine. ... would ... find the ... have ... code is ... installation ... application) ... gsec is ... process ... Hmmm. It appears that when switching...
... You should not try to insert text longer than 32,765 bytes into a blob using a string as input. If IBExpert lets you insert longer strings, then IBExpert...
At 11:07 AM 1/02/2005 +0000, you wrote: [lots and lots of reposting] You have a screwed-up installation. Two things you need to do are: 1) Go into your...
Hi all, Ihave a select statement that looks like this. Can someone help me on configuring indexes (and PLAN statement) to boost performance. SELECT S1.MAG_ID,...
Hi ... I do not understand this. What is blob subtype text then for? If not for long strings? How should we handle those? I do not want to transform my texts...
... He is talking about passing a string to a blob, I believe. Don't confuse a string with a blob - they are different types altogether. A "text blob" just...
... The problem depends on your interface TO the blob. Some of the client tools allow strings in the tool loaded from the blob, but they impose the limits...
Hello! I have a database in FirebirdSS-1.0.3.972-0 when i tried to restore this database, i cannot restore, one foreign key violation error is coming, but the...
... You should include the optimizers adapted plan, and information about what indices are there in your database. Regards, Alex...
Alexander Gräf
graef@...
Feb 1, 2005 12:54 pm
54732
Indeed. My installation is definitely screwed up. However, it appears that Firebird is using some mechanism other than the "Startup" folder to start a new...
Sorry, I found it. It's in the registry. Strange that the registry removal program didn't fix that... So, to summarize: With Firebird running as a service I am...
Does Windows start it as an service? ... -- Ag0nY <ag0ny@...>...
Ag0nY
ag0ny@...
Feb 1, 2005 1:24 pm
54735
Hi, My name is Ilir Gashi and I am Research Student at the Centre for Software Reliability, City University, London. I found a (possible) bug in Firebird 1.0...
... Firebird won't let you insert or update data that will break a foreign key relationship; but possibly the foreign key constraint was added to a nullable...
Maybe I don't understand basics, but here is my question. I have database with certain number of tables (let's say A, B, C, D, E) and make following ROLE's: ...
No, I loged in just as an user. How can I log with role if my USERA and USERB, both, use two roles? I believe roles work as logical OR... meaning if I have few...
... A role is not a group. It is a set of privileges. Grant the ROLE to the USER, and then, when the USER logs in with that ROLE, he has that set of ...
Hello, I have a customer with Firebird 1.5. Their hard disk ran out of space and they are getting a message saying that the database is corrupted. I tried to...
... Do you by chance have self joined tables (i.e. tables referencing itself)? For example you can have a table with words and one field referencing another...
I don't know if this helps, but this is what I do (btw, I'm a Firebird newbie). I use gsec and isql and import my commands from a test file. # gsec code to...
If you want to move a FB database between two Win32 machines (both running same Version of FB), can you not just shut down the DB, copy file, and start it up...
... A running database will get corrupted if copied, so GBAK is mainly a tool to bypass the need to shutdown the database while doing a backup. However, as...
Alexander Gräf
graef@...
Feb 1, 2005 6:06 pm
54748
... Some addition: If you move a DB file between two machines with different byte ordering (little endian vs. big endian), you need to use GBAK. Cheers, Alex...
