Hi all,
My application is executed fine but when I try to execute an SP I get
that message above
the SP do some works to clean the db at app first installation
before it worked fine for two years and did not make changes the code
since today and now it cannot be executed
Thanks for help
This i
Sorry I found a solution I cancel this topic .
Hi All,
I have many stored procedures and I'd like to include the code below in each
one for doing parameters comparisons between a ps parameters and another table
which contains user input settings for each parameter in a ps. I'd like to know
please, if such code below will not reduce performa
Because I need to know if compiled views are cached in memory a the sp
I mean through the system tables I have FB 3
Hi All,
Is it possible please to see by sql what is cached in FB memory some DBMS does
it.
Thanks
Yes this happen when I omit the field the default value is not applied.
I do this insert part into a stored procedure with other SQL statement for
other tables.
INTITULE_SALAIRE='N-'||F_GET_MONTH_NAME(:MOIS)||' '||:ANNEE;
INSERT INTO SALAIRES (EMPLOYEUR_ID, EMPLOYE_ID, UNITE_ID, MOIS,
ANNEE
My FB version is Firebird-3.0.3.32900_0_Win32 under XP PRO SP3
Hi all,
I build tables under IBEXPERT and define some fields with default value
FIELD_NAME INTEGER DEFAULT 0
I except 0 as value but has always NULL
Any idea ?
Thanks
>Guessing that you installed the Fb service with a non-default service
>name - "FirebirdServerfirebird3" - because you have another version of
>Firebird running on the same host machine and you want to call instsvc
>from your application to check the status of the Fb3 server process...
Yes I had a
Thanks Mark
<>
It is my case I have "FirebirdServerfirebird3" on XP pro
It means that when I install Firebird3 for the first time without having older
FB version on my machine the service name will be
"FirebirdServerDefaultInstance" in all windows version ?
If having installed older FB version the serv
Thank you for answer,
Yes the service is present in Local Services and the file executable file in
the area is C:\Firebird\Firebird_3_0\firebird.exe -s firebird3
anyway I have no problem with managing service to access my application but I
don't know if it is correct firebird.exe instead of in
Hello,
I am using Firebird-3.0.3.32900_0_Win32.exe on XP when I try to start service
in installed FB folder with C:\Firebird\Firebird_3_0>instsvc sta or instsvc sto
I get that message
"Error occured during OpenService"
The specified service doens't exists as installed service (sorry I had to
t
Thank you very much to all
Hello,
I need to know please, what is the limit of record in a table with more than a
hundred fields in FB 3 without reaching the 64 KB maximum row size. How many
records my table must contains ?
Sorry if my question seems lazy.
Thanks
Simply !! I didn't thought really to that.
I've just test it. I am very confused.
Thank you very much Dimitry !
In the transaction I use tpConcurrency, tpWait,tpWrite parameters
Hi all,
Two users access at the same record. The first delete it and the second update
the delete record after the first user. The second who update the record must
obtains something like :
Statement failed, SQLCODE = -901
cannot update erased record
In my case I don't obtain that message m
Hello,
Is it
I know there is one field description to comment the table, I need to know
please if it is possible to add another varchar field ?
Thanks
Hi All,
I need to resize fields data type (numeric length and scale) of certain tables
but I cannot do it du to dependencies (views and stored procedures). Is there a
way please, to do it through system tables using a stored procedure which
allows to modify data type in the table and in other
Hi all,
I get the following message when create and compiling a view under IBEXPERT :
violation of PRIMARY or UNIQUE KEY constraint "RDB$INDEX_15" on table
"RDB$RELATION_FIELDS".
Problematic key value is ("RDB$FIELD_NAME" = 'COMMUNE_ID', "RDB$RELATION_NAME"
= 'VW_EMPLOYE_FULL_LISTE').
Hi all,
I am not sure if my post was sent anyway my problem is solved about the
violation primary key in constraint
Thanks
Hi all,
I need to know please If I can use CAST one time for all fields in a
calculation in order to get 2 digits.
For example :
SUM(CAST((CL.QUANTITE *
CL.PRIX_UNITAIRE*(1.0-COALESCE(CL.TAUX_REMISE,0)/100.0)
*(1+COALESCE(CL.TAUX_TVA,0)/100.0)) AS NUMERIC(9,2))) AS MONTANT_NET
When I
My problem is solved I used a view instead of SP.
Many thanks to all and for advises too and sorry for my many posts
The sample I posted is selecting from a view which join four tables no problem
I can call it directly without the SP. But my real problem is in another query
which is complex and that I could not build a simply view. I meet problem
when I build it in a only a view so I had to build firstly the
Heres is a sample code of the SP
BEGIN
FOR SELECT O.ORDRE_ID, O.UNITE_ID, O.NUM_ORDRE, O.PREFIXE, O.DATE_ORDRE,
O.MOTIF_ORDRE, O.STRUCTURE_ID, O.PROJET_ID, O.BESOIN_NECESSAIRE,
O.COMMANDE_TRANSMISE, O.UTILISATEUR, O.LAST_UPDATE, O.INTITULE_UNITE,
O.INTITULE_STRUCTURE, O.NOM_PROJET, O.FILE_EXT
Hi all,
Selecting fields of stored procedure build with FOR SELECT from a delphi app
with where clause is not bad a a method ? Thanks
I use FOR SELECT in some part of the DB but the problem is when I use multiple
criteria for example for the same table order order_date, order_no, etc...
then I had to use execute statement to build query for each criteria. According
to your advise, do I need to build the SP with FOR SELECT and
Anyway, as it solved thanks to all
Now with
V1=:V1 || ' WHERE CF.DATE_COMMANDE'||' BETWEEN '''||:FROM_DATE||''' AND
'''||:TO_DATE||;
It works for me and I tried with
V1=:V1 || ' WHERE CF.DATE_COMMANDE>='''||:FROM_DATE||''' AND
CF.DATE_COMMANDE<='''||:TO_DATE||;
It works too. In which case this isn't the
Thanks but adding a quote at the end doesn't work. In fact adding double quote
because with one the SP will not be compiled
Hi all,
I am using FB 3 and IBExpert and with the DDL below I get message and it
works when I remove the where clause. I think the problem is with the between
command. Can you please help me ?
create or alter procedure test_commande (
from_date date,
to_date date)
returns (
Yes it was that Thanks sab
Sorry, it was an SQL and not FB problem
Thanks Karol
Hi all,
SELECT
CAST( COALESCE(CL.QUANTITE * CL.PRIX_UNITAIRE,0) AS NUMERIC(9,2)) AS TOTAL_HT,
SUM(CAST(CL.QUANTITE * CL.PRIX_UNITAIRE *( COALESCE(CL.TAUX_REMISE,0)/100.0)
AS NUMERIC(9,2))) AS TOTAL_REMISE, SUM((CL.QUANTITE * CL.PRIX_UNITAIRE) -
CL.QUANTITE * CL.PRIX_UNITAIRE * (COALESCE(CL.
Thank you. Another question please: are the views cached as the stored
procedure ?
Hi all,
I created a view where I join 6 tables and 2 other views that contains 3 or 4
tables joined each one. Can you please, tell me if is this correct to join
mutliple tables and views and will not be slow when the server processes this
view ? and what will be the result when I will transf
Hello,
I need to know please, If there is a difference of perfomance between an
execute statement query in a stored procedure and without execute statement for
the same SQL query .
Thank you
Yes exactly and thanks again !
I am only using some functions from the ib_udf.dll which is installed in the
\Firebird\Firebird_3_0\UDF and have built a little functions calling functions
of that dll there is no problem I suppose ?
I am already under FB3 and I am only planning in case I will move to 64 bits
server
Thank you very much for these informations
Hello,
I would like to know please, if we can use a DB in win64 but built under win32
. The client app is built with delphi 32 bits so the clients will connect to
that DB in 64 bits. Is it possible ? Thanks
Thank you very much
Thanks for the answers
All fields contained in the PK are updated is that mean by operations
affected ?
Thanks for explanation but if case of decreasing does we need to reindex table
manually ?
Hello,
I need to know please if it is allowed that a primary key has multiple integer
fields ? and only that. For example a PK that has seven integer fields will it
decrease the performance table ? I am using FB 3. Thanks
It's ok for me I understand now Thank you very much
Thank you
In the client I use the port number 3050 in the connection string. Is FB use
multiple port as the same time ?
Is there a document which explains that ?
Thanks
Hello,
Can you please, tell what mean the second part number of the IP (2711) after
the slash when I select MON$REMOTE_ADDRESS FROM MON$ATTACHMENTS ?
192.168.1.20/2711
Thank you.
I am sorry and I am confused.
I registered event with 'DISCONNECT_USER' instead of 'DISCONNECT_USER]' I
forgot the bracket and now it works for the 1st scenario and not for the second
because I was wrong with using 'DISCONNECT_USER]'||:USR in the PS and
certaintly doesn't work but It give me a
Hello,
Yes in my delphi application I registered the event name
I tried POST_EVENT in a stored procedure but without DELETE FROM
MON$ATTACHMENTS statement
sometimes it is fired sometimes not. I didn't understand why
When I write the event name like this :
1-POST_EVENT 'DISCONNECT_US
Hello,
I am deleting user connected with:
DELETE FROM MON$ATTACHMENTS WHERE MON$ATTACHMENT_ID = :ID_CONNECTION;
I need to use POST_EVENT in order to notify user that he has been disconnected
but don't found a trigger for MON$ATTACHMENTS to do it. Can you please help me
?
Thanks
Thank you very much Sean
Thanks Sean for your suggestion but which way do I create my own project ?
Sorry I did not explained the whole context. In innosetup script I include FB
executable file with my app with the line below and change the SYSDBA password
too:
Filename: "{app}\firebird\Firebird-3.0.1.32609_0_Win32.ex
Hello,
I need to know please if I can hide the password step when installing my app
with Firebird 3 within innosetup.
With FB 2 I can use the following parameter :
/SYSDBAPASSWORD,
/SP- /VERYSILENT,
/NOGDS32,
/NOCANCEL,
LOG
We can only assign password in the SYSDBA step and don
Hello,
When happen the following message:
"arithmetic exception, numeric overflow, or string truncation string right
truncation"
I am wondering if it is possible to the Firebird team to add in the message
the field name which is concerned by the error. It is not a problem for people
who ha
57 matches
Mail list logo