... It may be not relevant, but must TIMESTAMP be released with FREE_IT ? I see you are calling it as var param. Regards Boguslaw...
98774
Kjell Rilbe
krilbe
Dec 1, 2008 8:47 am
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...
98775
Milan Babuskov
mbabuskov
Dec 1, 2008 9:43 am
... select fff from ttt where cast( SUBSTRING(fff from 1 for STRPOS(',', fff) - 1)||'.'|| SUBSTRING(fff from strpos(',', fff)+1 ) as float) > 100 -- Milan...
98776
Kjell Rilbe
krilbe
Dec 1, 2008 9:56 am
... In Firebird 2.1 you can use replace(str, oldstr, newstr), e.g. replace("EmailAddress", '@', ' at ') will produce e-mail addresses slightly more difficult...
98777
Milan Babuskov
mbabuskov
Dec 1, 2008 10:02 am
... 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...
98778
ulrickebester
Dec 1, 2008 10:29 am
I get 'QSQLDA index out of range' when I try to make my queries active. What is causing this? Thank you, Uli...
98779
André Knappstein, ...
Knappstein@...
Dec 1, 2008 10:50 am
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...
98780
André Knappstein, ...
Knappstein@...
Dec 1, 2008 10:53 am
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...
98781
vahrokh
Dec 1, 2008 11:02 am
<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...
98782
Dan Fisher
dan_2474
Dec 1, 2008 11:36 am
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...
98783
ulrickebester
Dec 1, 2008 1:04 pm
... active. ... active....
98784
Paul Hope
paulphope
Dec 1, 2008 1:08 pm
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...
98785
Dan Fisher
dan_2474
Dec 1, 2008 1:51 pm
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...
98786
Tommi Prami
tprami
Dec 1, 2008 1:52 pm
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...
98787
Ivan Prenosil
iprenosil
Dec 1, 2008 5:41 pm
... Memory for the result must be allocated using: function ib_util_malloc(size: LongWord): Pointer; external 'ib_util.dll'; Ivan...
98788
Dalton Calford
daltoncalford
Dec 1, 2008 7:44 pm
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...
98789
Dmitry Yemanov
dimitr_ex
Dec 1, 2008 7:56 pm
... for SELECT first (:RowCount) skip (:StartRow) ... Dmitry...
98790
Dmitry Yemanov
dimitr_ex
Dec 1, 2008 7:57 pm
... What tool do you use when trying to drop a table? Do you have any simultaneous connections accessing that table? Dmitry...
98791
Dalton Calford
daltoncalford
Dec 1, 2008 8:02 pm
Thanks! ... [Non-text portions of this message have been removed]...
98792
Kjell Rilbe
krilbe
Dec 1, 2008 9:35 pm
... 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...
98793
Helen Borrie
helebor
Dec 1, 2008 10:47 pm
... 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...
98794
Adam
s3057043
Dec 1, 2008 10:49 pm
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...
98795
Adam
s3057043
Dec 1, 2008 10:57 pm
... 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,...
98796
Adam
s3057043
Dec 1, 2008 11:39 pm
... 'ib_util.dll'; ... Hello Ivan, Do you mean something like: .... function FB_AddMins(var DT: ISC_TIMESTAMP; var Minutes: Integer): PISC_TIMESTAMP; cdecl; ...
98797
Myles Wakeham
vladman992000
Dec 2, 2008 4:00 am
... 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,...
98798
johnkhoo65
Dec 2, 2008 7:05 am
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....
98799
Thomas Steinmaurer
iblogmanager
Dec 2, 2008 7:08 am
... cast(mydatetime as date) -- Best Regards, Thomas Steinmaurer LogManager Series - Logging/Auditing Suites supporting InterBase, Firebird, Advantage...
98800
Helen Borrie
helebor
Dec 2, 2008 7:08 am
... cast (myTimestampColumn as date) or (short form) date myTimestamp ./heLen...
98801
Joe Martinez
jmartine3
Dec 2, 2008 8:00 am
Alexandre, What do you mean by "Use CS"? The server uses all of the defaults and has not been modified from the default settings. -Joe...
