: Wednesday, January 11, 2017 9:02 AM
To: firebird-support@yahoogroups.com
Subject: [SPAM] Re: [firebird-support] Firebird : find strign in all database
Hi thanks for your reply
i have this code but something gone wrong
SET TERM !;
EXECUTE BLOCK
RETURNS (DANSTABLE CHAR(31), DANSCOLONNE CHAR
On 11-1-2017 10:35, startx252...@yahoo.fr [firebird-support] wrote:
>
>
> i mean taht i have no result (it's empty) and i am sure my string existe
> in one table
That is probably because you are using
' WHERE '||:DANSCOLONNE||' = ?'
instead of
' WHERE '||:DANSCOLONNE||' = ''%'' || ? || ''%'''
i mean taht i have no result (it's empty) and i am sure my string existe in one
table
On 11-1-2017 10:02, startx252...@yahoo.fr [firebird-support] wrote:
> i have this code but something gone wrong
Please be more specific than "something gone wrong"
Mark
--
Mark Rotteveel
Hi thanks for your reply
i have this code but something gone wrong
SET TERM !;
EXECUTE BLOCK
RETURNS (DANSTABLE CHAR(31), DANSCOLONNE CHAR(31) )
AS
DECLARE VARIABLE STMT VARCHAR(250);
DECLARE VARIABLE CHAINE VARCHAR(50);
DECLARE VARIABLE RESULT SMALLINT;
BEGIN
@yahoogroups.com
Subject: [SPAM] [firebird-support] Firebird : find strign in all database
Hi all,
I am looking for a procedure or a function to find a stirng in my database
I have a DB with 200 tables and want to find a specific string (record) in a my
DB
I don't know the name of table
Hi,
rather simple operation but can take very long time if database is big.
You can write stored procedure - or EXECUTE BLOCK
and inside iterate by system tables RDB$RELATIONS and RDB$RELATION_FIELDS
and do EXECUTE STATEMENT with where condition
and return back sum of fields '||' and table name
Hi all,
I am looking for a procedure or a function to find a stirng in my database
I have a DB with 200 tables and want to find a specific string (record) in a
my DB
I don't know the name of table / field.
Thanks for any help