Re: Re: [firebird-support] FB 2.5 migrate to 3.0

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

Re: [firebird-support] There is a verb to supply identity columns?

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

Re: [firebird-support] There is a verb to supply identity columns?

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

[firebird-support] There is a verb to supply identity columns?

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

Re: AW: [firebird-support] find a string records in all my tables

yes it's just a one time search, without option, juste a string

Re: [SPAM] Re: [firebird-support] Firebird : find strign in all database

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

AW: [firebird-support] find a string records in all my tables

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

Re: [firebird-support] Firebird : find strign in all database

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||' = ''%'' || ? || ''%'''

Re: [firebird-support] Firebird : find strign in all database

i mean taht i have no result (it's empty) and i am sure my string existe in one table

Re: [firebird-support] Firebird : find strign in all database

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

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(31) ) AS DECLARE VARIABLE STMT VARCHAR(250); DECLARE VARIABLE CHAINE VARCHAR(50); DECLARE VARIABLE RESULT SMALLINT; BEGIN

Re: [SPAM] [firebird-support] Firebird : find strign in all database

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

Re: [firebird-support] Firebird : find strign in all database

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

Re: [firebird-support] find a string records in all my tables

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