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
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
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,
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
Thanks Mark
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
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
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
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
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"
=
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
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
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,
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
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
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 *
Thank you. Another question please: are the views cached as the stored
procedure ?
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
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
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:
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
53 matches
Mail list logo
