On 07.10.2011 10:44, sir_wally_lewis wrote:
> Has anyone successfully written a pascal UDF
> to pass timestamps/strings without using
> the ibobjects library?
Yes, what problems do you face?
mit freundlichen Grüßen
Frank Schlottmann-Gödde
--
"Fascinating creatures, phoenixes,
On 07.10.2011 18:32, sir_wally_lewis wrote:
>
> as far as i can see to do the task.
> i must import isc_decode_date/isc_encode_date from fbclient library
>
> however as soon as i call a function that connects to these methods the
> connection crashes.
>
> also a major hurdle is no real way of debu
of(ISC_QUAD));
isc_encode_date(@tm_date,result);
end;
exports
fbdatetopascaldate name 'dt_topas',
pascaldatetofbdate name 'dt_tofb';
end.
<----------->
mit freundlichen Grüßen
Frank Schlottmann-Gödde
--
"Fascinatin
On 11.10.2011 15:43, Frank Schlottmann-Gödde wrote:
> On 11.10.2011 09:22, sir_wally_lewis wrote:
> {
> /*Converts a Firebird datetime value to a pascal tdatetime*/
> DECLARE EXTERNAL FUNCTION dt_topas
> date.
> RETURNS double precision by value
>
On 26.10.2011 02:49, sir_wally_lewis wrote:
> Thanks for the fixes to my C library Tomasz and for your help.
>
> All my C Library is originally extracted from FreeUDFLibC and I added extra
> functions.
>
> There were errors in the C Code that I was unaware of.
>
> Amazing that the same unaltere
nd
on disconnecting the client.
I will create a simplified testcase and add it to the tracker asap.
mit freundlichen Grüßen
Frank Schlottmann-Gödde
--
"Fascinating creatures, phoenixes, they can carry immensely heavy loads,
their tears have healing powers and they make highly faithful pets."
- J.K. Rowling
Am 26.10.2011 02:49, schrieb sir_wally_lewis:
the same unaltered code works under CenTos 64 bit in 2.1 though.
>
> Still do not understand why my freepascal UDF is crashing.
I have added an issue to the tracker
http://tracker.firebirdsql.org/browse/CORE-3651
cheers
FSG
--
"Fascinating creature
Am 07.11.2011 16:27, schrieb Tomasz Tyrakowski:
> Hi,
>
> One small improvement.
>
> Instead of
>
> execute statement :loc_sql into :out_fecha;
>
> I'd recommend
>
> for execute statement :loc_sql into :out_fecha do suspend;
and additional take a look at
http://www.firebirdsql.org/file/documen
On 30.12.2011 13:39, cartonace wrote:
> I am trying to migrate to 2.5 from 1.5. I am updating a c program that writes
> data to a table. When I try to run the program I get the following error:
>
> Your user name and password are not defined. Ask your database administrator
> to set up a Firebi
-BEGIN PGP SIGNED MESSAGE-
Hash: SHA1
On 31/12/11 16:18, cartonace wrote:
> Hello Frank
>
> Thanks for the swift reply but the environment variables were/are
> already set and it still prompted me for a user name and password. I
> think the security has been beefed up somewhere between
On 23.02.2012 19:23, Sergio Garcia wrote:
> Hi. We created a DB with UTF8 as Default character set (SS v2.5.1.26351). In
> FlameRobin we see the data correctly ("Canadá"), however from the Delphi (v6),
> using native controls at palette Interbase, the data is not displayed
> correctly ("Canadá").
On 07/12/2012 03:17 PM, peixinhosdalua wrote:
> Regarding your suggestions, i need to make a search by '%word%' not 'word%'.
> For example, most companies have a commercial name or brand that they use and
> these are different from the juridic name. It is the juridic name that is
> inserted in
On 07/12/2012 06:17 PM, K Z wrote:
> Hello,
>
>
> Does anyone knows where i can find a full reference manual of the
> FB2.5?
>
> For example, i tried to search the command SOUNDEX in the FB site and
> inside the documents mentioned at
> http://www.firebirdsql.org/en/reference-manuals/ (Reference Ma
On 13.07.2012 14:22, Tupy... nambá wrote:
> Wenn man die Vorschlage aus Herrn Gödde folgen wird, man kann ein
> "Googler" bauen. d.h., wenn man "insert" oder "update" macht,
> dann eine Tabelle mit Suchwörte und Index wird aktualiziert..
> stimmt das ?
Genau, but don't forget the "delete"
On 11/08/2012 07:20 PM, Marsha wrote:
> Hi all,
>
> Can anyone recommend some introductory tutorials, online courses,
> and/or prerequisite information I need to learn before diving into
> Firebird?
http://www.firebirdfaq.org/faq324/
is a good starting point
and if all else fails
http://www.ib-aid
On 11/30/2012 10:47 AM, Brian Dunstan wrote:
> Hi,
>
> Where can I learn about using trusted authentication?
>
> Thanks in advance,
> Brian
Firebird release notes:
http://firebirdsql.org/rlsnotesh/rlsnotes210.html#rnfb210-wintrusted
hth
Frank
--
"Fascinating creatures, phoenixes, they can carry
Am 08.03.2013 16:52, schrieb Sergio:
> Hello I have all my apps in Delphi with the IBX components and
> ClientDataSets to conect with a FB Database. Since long time ago IBX
> creator says it doesn't support FB. So far I can work with very
> simple queries fine. But now I'd like to use a component w
Am 25.03.2013 22:49, schrieb Frank Schlottmann-Gödde:
> Am 08.03.2013 16:52, schrieb Sergio:
>> Hello I have all my apps in Delphi with the IBX components and
>> ClientDataSets to conect with a FB Database. Since long time ago IBX
>> creator says it doesn't support FB. S
Am 30.04.2013 14:18, schrieb Lepage, Pierre:
> Hi,
>
> We are using Firebird Client 1.0 on one or a lot of computers in the
> company.
>
> Actually, we analyze the situation because we plan to migrate every
> computers in the company from Windows XP to Windows7 64bits.
>
> We need to know if Firebi
On 30.07.2013 23:29, Kevin E wrote:
> When running a COBOL code through gpre:
>
>
> EXEC SQL
> SET DATABASE DB2 = "/Db/Iccb/a1.db";
> USER '**' PASSWORD ''
> END-EXEC.
> EXEC SQL
> DECLARE C CURSOR FOR
>
On 16.08.2013 11:50, greatdaydan wrote:
> I have just started using Python and have discovered FDB. Super-duper! Now I
> can create a web interface for one of my applications.
>
> I am using the FDB 1.4 documentation to learn how to use FDB.
>
> A 'select * from table' returns all but the first re
On 17.08.2013 16:06, Wolfgang Kluge wrote:
> Good evening.
>
> I will greatly appreciate if somebody could help me with this.
>
> The Delphi 5 source code:
>
> procedure T_main.LoadForm( FormClass: TFormClass; FormName: String; Splash:
> Boolean );
> var
> ChildForm : TForm;
> nReturn :
Am 10.02.2014 08:31, schrieb nkd...@gmail.com:
>
>
> I am creating a project windows runtime component with c# , I want to
> create a embedded DB so i am using "Firebird-2.5.2.26540-0_x64_embed"
> and .net provider "NETProvider-2.5.2-CF" .
>
> every time i am getting same error: " An unhandl
On 04/24/2014 01:32 PM, Mags Phangisa wrote:
>
>
> Thanks Thomas. Blobs are seldom accessed.
As a compromise, I would suggest to place your blobs into a separate
table, it will increase the size of your main database, but will also
speed up the acccess to your blobs without interfering with eve
dle3 = nullptr;
for (const rel_field_t* rf = rel_fields; rf->relation; ++rf)
{
/*FOR (REQUEST_HANDLE req_handle3)
FIRST 1 X2 IN RDB$RELATION_FIELDS
WITH X2.RDB$RELATION_NAME = rf->relation
AND X2.RDB$FIELD_NAME = rf->field
AND X2.RDB$SYSTEM_FLAG = 1*/
{
for (int retries = 0; retries < 2; ++retries)
{
if (!req_handle3 && DB)
req_handle3 = DB->compileRequest(fbStatus,
sizeof(fb_0), fb_0);
isc_vtov ((const char*) rf->relation, (char*) fb_1.fb_2,
1009);
isc_vtov ((const char*) rf->field, (char*) fb_1.fb_3, 1009);
if (req_handle3)
req_handle3->startAndSend(fbStatus, fbTrans, 0,
0, 2018, CAST_CONST_MSG(&fb_1));
if (fbStatus->getErrors()[1] == isc_bad_req_handle)
{ req_handle3->release(); req_handle3 = NULL; }
else break;
}
if (!(fbStatus->getState() & Firebird::IStatus::STATE_ERRORS)) {
while (1)
{
req_handle3->receive (fbStatus, 0, 1, 2,
CAST_MSG(&fb_4));
if (!fb_4.fb_5 || (fbStatus->getState() &
Firebird::IStatus::STATE_ERRORS)) break;
if (tdgbl->runtimeODS < rf->ods_version)
tdgbl->runtimeODS = rf->ods_version;
/*END_FOR;*/
}
};
/*ON_ERROR*/
if (fbStatus->getState() & Firebird::IStatus::STATE_ERRORS)
{
general_on_error();
/*END_ERROR;*/
}
}
}
MISC_release_request_silent(req_handle3);
}
namespace
{
// copy/paste from backup.epp
void general_on_error()
{
/**
*
* g e n e r a l _ o n _ e r r o r
*
**
*
* Functional description
* Handle any general ON_ERROR clause during ODS level detection.
*
**/
BurpGlobals* tdgbl = BurpGlobals::getSpecific();
BURP_print_status(true, isc_status);
BURP_abort();
}
}
On 13.02.19 17:39, Robert Tulloch tult...@hughes.net [firebird-support]
wrote:
>
>
> Anyone have an example of embedded SQL code and the GPRE result?
>
> Thanks
>
> Best regards
>
>
>
mit freundlichen Grüßen
Frank Schlottmann-Gödde
--
Oldenburger Str. 34, 23743 Grömitz, Tel.: 04562/266984
isn’t working and what changes I need to make to the
FireDAC config in order to get embedded to work?
mit freundlichen Grüßen
Frank Schlottmann-Gödde
--
Oldenburger Str. 34, 23743 Grömitz, Tel.: 04562/266984
ion.
http://docwiki.embarcadero.com/RADStudio/Rio/en/Configuring_Drivers_(FireDAC)
mit freundlichen Grüßen
Frank Schlottmann-Gödde
Am 16.05.19 um 10:49 schrieb sbai...@mutualconsultants.ltd.uk
[firebird-support]:
>
> Maybe this question is also off-topic, but can you tell me which group
> I should use for posting questions about FB4 Beta 1?
This would be
https://lists.sourceforge.net/lists/listinfo/firebird-devel
hth
fsg
Am 28.05.2014 11:38, schrieb Mike Ro miker...@gmail.com [firebird-support]:
>
>
> I am sorry to bump this, but has anyone else got experience of using
> blobs on Linux?
Yes, of course, but I never felt the need to time the operations, we
are using a udf s.th. like:
void EXPORT fn_b_load ( cha
On 04.06.2014 00:08, Mike Ro miker...@gmail.com [firebird-support] wrote:
> Unfortunately I haven't had any success in trying this because
> blob_put_segment() is causing Firebird embedded to throw an instance of
> "Firebird::status_exception" followed by a core dump that I really can't
> get to t
On 06.06.2014 15:11, Mike Ro miker...@gmail.com [firebird-support] wrote:
> Frank, thank you for taking the time to do this. It confirms that there is
> definitely something wrong with my setup (are you using Firebird version
> 2.5.2?).
No, its LI-T3.0.0.31151 Firebird 3.0 Alpha 2, but that sho
On 09.06.2014 15:51, Mike Ro miker...@gmail.com [firebird-support] wrote:
> So the only mystery (for me!) remaining is why the UDF is so much faster
> when it is writing 4096 bytes at time with forced writes on?
Usually it is faster to let the server do the dirty work, but I'm not
sure that it i
Am 04.08.2014 17:51, schrieb g80r...@gmail.com [firebird-support]:
>
>
> I just wonder.
>
What about:
http://www.firebirdsql.org/en/case-studies/
hth
Frank
--
"Fascinating creatures, phoenixes, they can carry immensely heavy loads,
their tears have healing powers and they make highly faith
On 01.10.2014 14:28, Mathias Stucki mathias.stu...@fasnacht.biz
[firebird-support] wrote:
>
>
> Hello,
>
> I am trying to compile Firebird-2.5.3 with ptxdist-2014.09.0, using
> OSELAS.Toolchain-2013.12.2.
>
> Unfortunately I’m getting a lot of compile errors:
Well, the build process for FB2.5 isn
On 05.12.2014 17:19, Tim Ward t...@telensa.com [firebird-support] wrote:
> Anyone done any of this?
>
> Testing a stored procedure involves
>
> - set up test data
> - run the procedure
> - check and report on results
> - any clean up needed (remove or restore output data, reset generators,
> ect ec
35 matches
Mail list logo
