Firebird Embedded VB.net 2008 Error

Andrew Gable

unread,

May 4, 2021, 6:46:13 PM5/4/21

to firebird-support

Hi Everyone,

I hope someone can help me I am new to using Firebird embedded

this is my problem

when my Software starts up I get the following error message

Dynamic SQL Error SQL error code = -804 Function unknown REPLACE

This is the following SQL Command I am using

Select

functiontype,

linenumber,

lineaglinment,

linefont,

replace(replace(linetext,',,',','),'''','''')

from rec_table

where functiontype='R'

Order by linenumber ASC

Can someone confirm for me if Embedded actually supports the replace command if not how would i do this function
(The above code works perfectly fine on my MySQL Database server)

liviuslivius

unread,

May 5, 2021, 1:50:40 AM5/5/21

to firebird...@googlegroups.com

Hi

Firebird support many functions and REPLACE too. All depends on Firebird version itself. Which Firebird version do you use? If i remember correctly it was introduced as builtin function in FB2.5. Previously you must use udf library.

Regards,

Karol Bieniaszewski

-------- Oryginalna wiadomość --------

Od: Andrew Gable <drewg...@gmail.com>

Data: 05.05.2021 00:46 (GMT+01:00)

Do: firebird-support <firebird...@googlegroups.com>

Temat: [firebird-support] Firebird Embedded VB.net 2008 Error

--
You received this message because you are subscribed to the Google Groups "firebird-support" group.
To unsubscribe from this group and stop receiving emails from it, send an email to firebird-suppo...@googlegroups.com.
To view this discussion on the web, visit https://groups.google.com/d/msgid/firebird-support/3339156e-71ff-4815-9679-9df506d82cc0n%40googlegroups.com.

P-Soft - Fabio Codebue

unread,

May 5, 2021, 3:34:48 AM5/5/21

to firebird...@googlegroups.com

We are migrating a database from mono-company to multi-company and so we need to drop PK and rebuild with company code into it

When we try to alter table and drop constraint PK. we receive back this error

unsuccessful metadata update ALTER TABLE aliquote_sub failed unknown ISC error 336068738

I don't found this error description, some ideas?

Fabio Codebue

P-SOFT di Codebue Fabio

Via Nuova n. 9 - 24060 Tavernola B.sca (BG)

P.I. 03624950162

C.F. CDBFBA72A11C618T

Mobile: +39.348.3515786

Fax: +39.030.5100306

Web: http://www.p-soft.biz

pec: amminis...@pec.p-soft.biz
cod.intermediario SDI: KRRH6B9

Andrew Gable

unread,

May 5, 2021, 4:06:06 AM5/5/21

to firebird...@googlegroups.com

How do I found out what version of the embedded database I am using?

On Wednesday, May 5, 2021, liviuslivius <livius...@poczta.onet.pl> wrote:

Hi

Firebird support many functions and REPLACE too. All depends on Firebird version itself. Which Firebird version do you use? If i remember correctly it was introduced as builtin function in FB2.5. Previously you must use udf library.

Regards,
Karol Bieniaszewski

-------- Oryginalna wiadomość --------
Od: Andrew Gable <drewg...@gmail.com>
Data: 05.05.2021 00:46 (GMT+01:00)

Do: firebird-support <firebird-support@googlegroups.com>

Temat: [firebird-support] Firebird Embedded VB.net 2008 Error

Hi Everyone,

I hope someone can help me I am new to using Firebird embedded
this is my problem

when my Software starts up I get the following error message

Dynamic SQL Error SQL error code = -804 Function unknown REPLACE

This is the following SQL Command I am using

Select
functiontype,
linenumber,
lineaglinment,
linefont,
replace(replace(linetext,',,',','),'''','''')
from rec_table
where functiontype='R'
Order by linenumber ASC

Can someone confirm for me if Embedded actually supports the replace command if not how would i do this function
(The above code works perfectly fine on my MySQL Database server)

--
You received this message because you are subscribed to the Google Groups "firebird-support" group.

To unsubscribe from this group and stop receiving emails from it, send an email to firebird-support+unsubscribe@googlegroups.com.

To view this discussion on the web, visit https://groups.google.com/d/msgid/firebird-support/3339156e-71ff-4815-9679-9df506d82cc0n%40googlegroups.com.

--

You received this message because you are subscribed to the Google Groups "firebird-support" group.

To unsubscribe from this group and stop receiving emails from it, send an email to firebird-support+unsubscribe@googlegroups.com.
To view this discussion on the web, visit https://groups.google.com/d/msgid/firebird-support/4FZm5h68ffz20JK%40smtp.poczta.onet.pl.

liviuslivius

unread,

May 5, 2021, 5:13:56 AM5/5/21

to firebird...@googlegroups.com

Check properties of dll which you use. Right click on it and go to properties.

Regards,

Karol Bieniaszewski

-------- Oryginalna wiadomość --------

Od: Andrew Gable <drewg...@gmail.com>

Data: 05.05.2021 10:06 (GMT+01:00)

Do: firebird...@googlegroups.com

Temat: Re: [firebird-support] Firebird Embedded VB.net 2008 Error

To unsubscribe from this group and stop receiving emails from it, send an email to firebird-suppo...@googlegroups.com.
To view this discussion on the web, visit https://groups.google.com/d/msgid/firebird-support/CAJrNeCdFSaYt1Ktty0GT7nKaUodv%2BHW38%2BwjKKbMrPwGq06A6A%40mail.gmail.com.

Dimitry Sibiryakov

unread,

May 5, 2021, 5:46:19 AM5/5/21

to firebird...@googlegroups.com

05.05.2021 09:34, P-Soft - Fabio Codebue wrote:
> When we try to alter table and drop constraint PK. we receive back this error
> unsuccessful metadata update ALTER TABLE aliquote_sub failed unknown ISC error 336068738
>
> I don't found this error description, some ideas?

First of all your installation is incorrect and wrong client version is used. You must
fix it before continue.
I recommend use UUID instead of composite PK.

--
WBR, SD.

Andrew Gable

unread,

May 5, 2021, 6:37:08 AM5/5/21

to firebird...@googlegroups.com

Hi Karol,

Thank-you for the advice from what I can see I am using a very old version of the embedded dll (1.5.2.4731) Could some one please point me in the right direction to download a newer version of the dll.

thanks

On Wed, May 5, 2021 at 10:13 AM liviuslivius <livius...@poczta.onet.pl> wrote:

Check properties of dll which you use. Right click on it and go to properties.

Regards,
Karol Bieniaszewski

-------- Oryginalna wiadomość --------
Od: Andrew Gable <drewg...@gmail.com>
Data: 05.05.2021 10:06 (GMT+01:00)
Do: firebird...@googlegroups.com
Temat: Re: [firebird-support] Firebird Embedded VB.net 2008 Error

How do I found out what version of the embedded database I am using?

On Wednesday, May 5, 2021, liviuslivius <livius...@poczta.onet.pl> wrote:

Hi

Firebird support many functions and REPLACE too. All depends on Firebird version itself. Which Firebird version do you use? If i remember correctly it was introduced as builtin function in FB2.5. Previously you must use udf library.

Regards,
Karol Bieniaszewski

-------- Oryginalna wiadomość --------
Od: Andrew Gable <drewg...@gmail.com>
Data: 05.05.2021 00:46 (GMT+01:00)

Do: firebird-support <firebird...@googlegroups.com>

Temat: [firebird-support] Firebird Embedded VB.net 2008 Error

Hi Everyone,

I hope someone can help me I am new to using Firebird embedded
this is my problem

when my Software starts up I get the following error message

Dynamic SQL Error SQL error code = -804 Function unknown REPLACE

This is the following SQL Command I am using

Select
functiontype,
linenumber,
lineaglinment,
linefont,
replace(replace(linetext,',,',','),'''','''')
from rec_table
where functiontype='R'
Order by linenumber ASC

Can someone confirm for me if Embedded actually supports the replace command if not how would i do this function
(The above code works perfectly fine on my MySQL Database server)

--
You received this message because you are subscribed to the Google Groups "firebird-support" group.

To unsubscribe from this group and stop receiving emails from it, send an email to firebird-suppo...@googlegroups.com.

To view this discussion on the web, visit https://groups.google.com/d/msgid/firebird-support/3339156e-71ff-4815-9679-9df506d82cc0n%40googlegroups.com.

--
You received this message because you are subscribed to the Google Groups "firebird-support" group.

To unsubscribe from this group and stop receiving emails from it, send an email to firebird-suppo...@googlegroups.com.
To view this discussion on the web, visit https://groups.google.com/d/msgid/firebird-support/4FZm5h68ffz20JK%40smtp.poczta.onet.pl.

--
You received this message because you are subscribed to the Google Groups "firebird-support" group.
To unsubscribe from this group and stop receiving emails from it, send an email to firebird-suppo...@googlegroups.com.
To view this discussion on the web, visit https://groups.google.com/d/msgid/firebird-support/CAJrNeCdFSaYt1Ktty0GT7nKaUodv%2BHW38%2BwjKKbMrPwGq06A6A%40mail.gmail.com.

--
You received this message because you are subscribed to a topic in the Google Groups "firebird-support" group.
To unsubscribe from this topic, visit https://groups.google.com/d/topic/firebird-support/vS5LvZCgGDQ/unsubscribe.
To unsubscribe from this group and all its topics, send an email to firebird-suppo...@googlegroups.com.
To view this discussion on the web, visit https://groups.google.com/d/msgid/firebird-support/4FZrcD5yRpzlgF7h%40smtp.poczta.onet.pl.

liviuslivius

unread,

May 5, 2021, 7:14:32 AM5/5/21

to firebird...@googlegroups.com

Firebird 3 do not have separate dll for it.

It is now same for embeded and regullar server. Simply download zip from the page.

You must do backup of the database on the current version and restore it on fb3 version

Regards,

Karol Bieniaszewski

-------- Oryginalna wiadomość --------

Od: Andrew Gable <drewg...@gmail.com>

Data: 05.05.2021 12:37 (GMT+01:00)

To view this discussion on the web, visit https://groups.google.com/d/msgid/firebird-support/CAJrNeCcZvNXbDGx07v-jf8eFBWe%2Bq6TaT72nDhqxgu5J0pnDDQ%40mail.gmail.com.

Mark Rotteveel

unread,

May 5, 2021, 8:08:24 AM5/5/21

to firebird...@googlegroups.com

On 2021-05-05 09:34, P-Soft - Fabio Codebue wrote:
> We are migrating a database from mono-company to multi-company and so
> we need to drop PK and rebuild with company code into it
>
> When we try to alter table and drop constraint PK. we receive back
> this error
>
> unsuccessful metadata update ALTER TABLE aliquote_sub failed unknown
> ISC error 336068738
>
> I don't found this error description, some ideas?

Error 336068738 is "CONSTRAINT {0} does not exist.". So either your
primary key doesn't exist, or you're using the wrong constraint name. It
also means that you're using an outdated fbclient.dll and/or
firebird.msg file.

Mark

Reply all

Reply to author

Forward