Dear Helen,
Thanks for your advice.
I will try it all with your detail steps.
Best regards,
James
From: Helen Borrie hele...@iinet.net.au [firebird-support]
Date: 2017-01-10 17:02
To: firebird-support
Subject: Re: [firebird-support] FB 2.5 migrate to 3.0
> Thanks for your answer. I think
I knew it!
Never alone :)
I´m following your ticket, Mark.
Thanks.
2017-01-11 10:35 GMT-02:00 Mark Rotteveel m...@lawinegevaar.nl
[firebird-support] :
>
>
> On 11-1-2017 12:00, hamacker sirhamac...@gmail.com [firebird-support]
> wrote:
> > Colums identity in FB3, I love it!
> >
> > But there is
On 11-1-2017 12:00, hamacker sirhamac...@gmail.com [firebird-support] wrote:
> Colums identity in FB3, I love it!
>
> But there is one thing missing.
>
> I would like to know, if exists a verb to supply identity value to not
> assume a literal value. Ex:
>
> create table test (
>id integer gene
Hi, All.
Colums identity in FB3, I love it!
But there is one thing missing.
I would like to know, if exists a verb to supply identity value to not
assume a literal value. Ex:
create table test (
id integer generated by default as identity primary key,
name varchar(15) );
insert into test
yes it's just a one time search, without option, juste a string
What you’ve written is a valiant effort, but shows why I think it’s better to
use external programming to generate the SQL needed. Programming languages
like c, c++, pascal etc., give far more fine control in doing such a task, have
well-defined control statements, and are able to be debugged s
Hello,
out of curiosity: Is this a one time search or should it happen regulary? If
ist regulary – maybe the design should be reviewed?
What are the requirements to run such a search? Is fulltextsearch an option?
Niko
Von: firebird-support@yahoogroups.com [mailto:firebird-support@
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
CHAINE='ACHERCHER';
I think you would probably have to provide some external programming to solve
this. I can't see a way of putting a SQL solution together.
Using external programming (any of the usual development systems) you can get a
list of tables, together with a list of fields they contain, and the data typ
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 w
On 10-1-2017 18:10, startx252...@yahoo.fr [firebird-support] wrote:
> 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.
There are no ready-m
14 matches
Mail list logo