... It may be not relevant, but must TIMESTAMP be released with FREE_IT ? I see you are calling it as var param. Regards Boguslaw...
Bogusław Brandys
brandys@...
Dec 1, 2008 8:44 am
98774
When trying to drop a table I now and then get "Object XXX is in use" when trying to commit. This is with FB WI-V2.1.0.17798. The only way I've found to...
... select fff from ttt where cast( SUBSTRING(fff from 1 for STRPOS(',', fff) - 1)||'.'|| SUBSTRING(fff from strpos(',', fff)+1 ) as float) > 100 -- Milan...
... In Firebird 2.1 you can use replace(str, oldstr, newstr), e.g. replace("EmailAddress", '@', ' at ') will produce e-mail addresses slightly more difficult...
... This looks like a bug. Which version of FlameRobin? Please follow up on flamerobin-devel for this... ... It is actually the best way to use it. That...
In addition to the answer you received, in a similar situation you can also do a left outer join and specify the missing parent (= null) in the where clause. I...
André Knappstein, ...
Knappstein@...
Dec 1, 2008 10:50 am
98780
Hello, in addition to Helen's answer, in a similar situation (sporadic cleanup, not a periodical housekeeping), it could be faster to copy the records you want...
André Knappstein, ...
Knappstein@...
Dec 1, 2008 10:53 am
98781
<Snip> ... to ... and he ... OFF, ... No, I finally found the "culprit". Another programmer read a page on the Firebird site stating how by setting that value...
Thanks for your input, Helen. ... a prerequisite to a job like this... If backup and restore really *is* the only way, it suggests that you might have started...
Hi Adam Cant pretend to know what it all means but my udf procedure declarations end in 'cdecl; export;' could there be something there? Regards Paul...
OK I think I've answered my own question (though I'm not sure I fully understand what's going on): The dll which runs the scripts checks whether any DDL...
all current release versions of fbclient.dll and gds32.dll (32bit and 64bit versions), in some sane directory structure. and maybe current beta/rc versions...
Hi All, Due to the size of a result-set, I need to breakdown a process into a series of steps, but unfortunately, none of the natural data breaks are small...
... Tool = FlameRobin 0.9.1.1787 Unicode Windows This is a snapshot build. No other activity on the database at all. This is on a test/development machine and...
... This is similar to saying "I had a pet flea. It has escaped. Have you seen it?" It sounds like a Delphi array error and "make my queries active" is a...
Hello Boguslaw, ... According to something I read on one of the (many) sites that google returned, timestamps should be declared this way. That said, I can not...
... declarations end ... Hello Paul, Maybe. The function is explicitly exported in the dpr, and I do use cdecl for the calling convention for *MY* functions,...
... 'ib_util.dll'; ... Hello Ivan, Do you mean something like: .... function FB_AddMins(var DT: ISC_TIMESTAMP; var Minutes: Integer): PISC_TIMESTAMP; cdecl; ...
... Before you go too far with this, I think you might encounter the same problem with this that I have. The problem is that although you can use a FIRST,...
I have a field which contains the date and time of the entry. How do I extract the date portion from it? I do not want the time, just the date only....
... cast(mydatetime as date) -- Best Regards, Thomas Steinmaurer LogManager Series - Logging/Auditing Suites supporting InterBase, Firebird, Advantage...
Having problems with message search?
Fill out this form to ensure your group is one of the first to be migrated to the new message search system.
