[firebird-support] is distinct from - not indexed

Hello, If I select some fields from mytable with ,where field = XX' or ,where field > XX', the indexed fields were read indexed (displayed from IBExpert). But If I select some fileds from mytable with 'where field is distinct from XX', the read is not indexed. It is already okay? Thank

AW: [firebird-support] is distinct from - not indexed

Hi SET, >> cannot compare IS DISTINCT FROM with equality or greater than, rather, IS DISTINCT FROM is comparable to difference. Hence, I'd say --- Yes, I know. I just wanted to show the comparison between indexed read (<, >, =) and non-indexed read (is distinct.., and (thanks Thomas) also <> and

AW: [firebird-support] is distinct from - not indexed

Hello Thomas, again thanks a lot for your help! Best regards and a nice weekend. Olaf > If I select some fields from mytable with ,where field = XX' or ,where field >> XX', the indexed fields were read indexed (displayed from IBExpert). But > If I select some fileds from mytable with

[firebird-support] Timer in firebird?

Hello, I would like to send all 30 seconds an event to the connected client to confirm the connection. How can I realize that? There are different clients connected, for each I need this function. Thank you. Best regards. Olaf [Non-text portions of this message have been removed]

AW: [firebird-support] Timer in firebird?

Hi, I need to check the connectivity to our plc. A little tool is between database an plc. If the plc is down or the tool, I cannot see the connectivity. The visualization is also connected to our database, but not to the plc. Now I would show the connectivity in the visualization to our da

AW: AW: [firebird-support] Timer in firebird?

Hello Em 13/9/2011 02:19, Olaf Kluge escreveu: > Hi, > > > > I need to check the connectivity to our plc. A little tool is between > database an plc. If the plc is down or the tool, I cannot see the > connectivity. > > > > The visualization is also connected to

AW: AW: [firebird-support] Timer in firebird?

Hello, I have found. Thank you. with best regards Olaf Kluge Hello Em 13/9/2011 02:19, Olaf Kluge escreveu: > Hi, > > > > I need to check the connectivity to our plc. A little tool is between > database an plc. If the plc is down or the tool, I cannot see

[firebird-support] special question view

Hello, I can realize the following with a procedure, but with a view too? We select some records in some tables and joins. In one Table, there are two records with different values. So I have by grouping this two records every time. It is possible?: Select a.field, b.field, (c.fiel

Re: [firebird-support] special question view

Hello Markus, that's great! Thank you very much. Best regards. Olaf

[firebird-support] problem trigger after insert and generator

Hello, I would like to delete records if a determined count of record is reached. One trigger counts a generator for the primery key of the table named a. on before insert. One trigger after insert counts a second generator like this: AS declare variable ist integer ; begin ist=GEN_I

AW: [firebird-support] problem trigger after insert and generator

Hello, I think not, it will be delete if the second generator >= 30: AS declare variable ist integer ; begin ist=GEN_ID(TILOG_ALLG_ID_DEL, 1); //The generator adding up (+1) if(ist >= 30) then // if the generator = 30 then begin begin ist = gen_id(TILOG_ALLG_ID_DEL, -10); // set

AW: [firebird-support] problem trigger after insert and generator

Sorry, I have not read correctly your answer. Is there no chance to deleting records in my case (interval) Thanks --- Hello, I think not, it will be delete if the second generator >= 30: AS declare variable ist integer ; begin ist=GEN_ID(TILOG_ALLG_ID_DEL, 1); //The generator a

[firebird-support] Two complicated questions firebird 2.5 cs

Hello, we are using firebird 2.5 classic server 64 bit on windows server 2008 standard 64 bit. My first question. Is the last line possible? (iif(select condition = true,'where field = value','where field = value2) select first (1) a.fachnr, a.le from tfachzuordnung

[firebird-support] save pictures into firebird database

Hello, one qestion. How can I save pictures into the firebird database? It is possible to create a windows-file (*.jpg) with a stored procedure into the filesystem? Thank you very much. Best regards. Olaf [Non-text portions of this message have been removed]

AW: [firebird-support] save pictures into firebird database

Thank you. Afternoon Olaf, > one qestion. How can I save pictures into the firebird database? It is > possible to create a windows-file (*.jpg) with a stored procedure into the > filesystem? This link might help a little, maybe. http://www.firebirdfaq.org/faq122/ Cheers, Norm. -- Norman D

[firebird-support] Execute Statement problem with timestamp

Hello, I've a little problem with a sql statement: s_stmmain = 'insert into ' || :s_stmtable || '(kd_id, fnr, fbeginn, fende) values (' || :t_timestamp || ',' || cast(:i_fnr as varchar(4)) || ',' || '' || ',' || '' || ')'; execute statement s_stmmain; t_time

AW: [firebird-support] Execute Statement problem with timestamp

Hello Helen, Thank you very much. Best regards. Olaf >I've a little problem with a sql statement: > >s_stmmain = 'insert into ' || :s_stmtable || '(kd_id, fnr, fbeginn, fende) >values (' > > || :t_timestamp || ',' || cast(:i_fnr as varchar(4)) || ',' > > || '' || ',' || '' ||

[firebird-support] question about copyright law

Hello everybody, one of our customer has no confidence in the Copyright Law of the firebird-database. Is there a certificate for confirmation? We need to confirm all copyright claims to take over! Thank your for your help! Best regards Olaf

Re: [firebird-support] question about copyright law

On Wed, 14 Dec 2011 19:32:39 +0100, olaf.kl...@satron.de wrote: > Hello everybody, > > one of our customer has no confidence in the Copyright Law of the > firebird-database. Is there a certificate for confirmation? We need to > confirm all copyright claims to take over! > > Thank your for your he

[firebird-support] character set

Hallo, we have some problems by inserting data into an table. In our case, the customer inserts characters in a field varchar(XX) with special character “°”. This little ° with character set iso8859_1 and collation de_de by inserting generates a gds-exception error: 335544321 arithmetic excepti

AW: [firebird-support] character set

Hello, > we have some problems by inserting data into an table. In our case, the > customer inserts characters in a field varchar(XX) with special character > “°”. This little ° with character set iso8859_1 and collation de_de by > inserting generates a gds-exception error: 335544321 arithm

[firebird-support] Question about better performance Query

Hello, at this time I have create an statement: select first 1 a.pfad from t_pictures a where status <> 6 and (select count(*) from t_pictures where status < 5 and kd_id = a.kd_id and li_id = a.li_id) = 0 into :pfad; pfad = path for an file Now we have thousands of record

AW: [firebird-support] Question about better performance Query

e any record in the set as you have no "order by") Nick Upson On 21 March 2012 15:07, Olaf Kluge wrote: > ** > > > Hello, > > at this time I have create an statement: > > select first 1 a.pfad > > from t_pictures a where status <> 6 and >

AW: [firebird-support] Question about better performance Query

Hello Set, the picture-path can be the status 1 (inserted), status 5 (storage-time has expired and picture can be deleted) and status 6 (release to delete). A NIO-Ray-image will be deleted after 2 month, a IO-ray-image after 72 hours. If all pictures are deleted, I can delete the entire folder

AW: [firebird-support] Question about better performance Query

Hello, another hint. All table-filds which are read are indicated. Each call of the stored procedure get one result, the pc-program delete the folder and report it to the database (other stored procedure). .until there is no other folder to delete. Thanks. Hello Set, the picture-pa

AW: [firebird-support] Question about better performance Query

Hello again, for all users with the same "problem": I have created an update-trigger: AS begin if(new.status = 5) then begin if (not exists (select 1 from t_pictures where status < 5 and kd_id = new.kd_id and li_id = new.li_id)) then update t_pictures set status =

[firebird-support] select column

Hello, it is possible to select the column by column-number? For example: Column1=ID, column2 = name, column3 = address. And now: "select column(2), column(3) from table". Orderby column-number is already possible. Thank you. Best regards. Olaf [Non-text portions of this messa

AW: [firebird-support] select column

Hello again, we have some workstations. Every ws need to show some fields of an table. Now I thought, I can configure that with the numbers of the column. I also could write down the column-Names in a configuration table, but sql statements should be slower. Thanks for helping. Olaf

AW: AW: [firebird-support] select column

Hello, I have read this in this group, but I max have it misunderstood. Thanks for your help. On 11-4-2012 14:48, Olaf Kluge wrote: > Hello again, > we have some workstations. Every ws need to show some fields of an table. > Now I thought, I can configure that with the numbe

AW: [firebird-support] select column

Hello set, Thank you very much! I will test it this week. Best regards. Olaf WITH TMP(FieldName, FieldPos) AS (SELECT RDB$FIELD_NAME, RDB$FIELD_POSITION+1 FROM RDB$RELATION_FIELDS WHERE RDB$RELATION_NAME = :MyTableName ORDER BY RDB$FIELD_POSITION) SELECT 'SELECT ' || LIST(FieldNam

[firebird-support] performance question

Hello, from the plc I get every cycle of production a record with some information. Each record (a car) includes 300 Bytes with alphanumeric characters. For example char1 to char4 is the line number, char 5 to char x the model etc. I store the information in a firebird 2.5 cs db. The client

AW: [firebird-support] performance question

Hi Mark, thank you. I will try the first solution. Best regards. Olaf Your second solution would amount to you creating a database in a database. It also means that on every request Firebird will have to retrieve the string as is, and then split that every time. I assume that using Fi

AW: [firebird-support] performance question

Hello Set, Best thanks for your detailed reply. Yes, in my table exists fiest a primary key with a integer value generated by a trigger and a generator. All values can be alphanumeric, so that I must save all data in separate character-fields (approx. 100 columns). I could create a separate table

[firebird-support] Generator

Hello, I need the last ID from a table. Now I can get this with select max(id) from table into :maxlnr. I thought, it is a better way to read the last generator-id with maxlnr = gen_id(gen_t_dt_id,0); This results a not indexed read of my table. Now I have read the following in firebird faq

AW: [firebird-support] Generator

Hello Martijn Hello Olaf, > I need the last ID from a table. Now I can get this with select max(id) > from > table into :maxlnr. I thought, it is a better way to read the last > generator-id with maxlnr = gen_id(gen_t_dt_id,0); This results a not > indexed > read of my table. > > > > Now I ha

AW: AW: [firebird-support] Generator

Hello On Tue, 8 May 2012 15:09:34 +0200, "Olaf Kluge" mailto:olaf.kluge%40satron.de> > wrote: > my description was not good. > > I need the value in a stored procedure, not by inserting the data! By > inserting I have a trigger. new.id = gen_id(generator,1); &

AW: AW: AW: [firebird-support] Generator

Hello Mark, >Could you look into the way your mailprogram is quoting lines? It is very >confusing the have my own text not quoted in your emailmessage. >Checkout the manual for ROWS: >http://www.firebirdsql.org/refdocs/langrefupd25-select.html#langrefupd25-select-rows >In other words: ROWS 5 TO 1

[firebird-support] converting mssql to firebird

Hello dear helper, I should convert an existing mssql stored procedure into firebird. Perhaps anybody can help me. The database was not created by me. The structure of the procedure is slightly different. Select. into . from. I don't understand about the union with identical queries, this g

[firebird-support] select first and skip

Hello dear people, in a Table I'm looking for the right 5 records for each workplace on a conveyor track (max-id of the records - offset for the workplace) but ascending sorted. For example, the max ID is 200 (last record). The Offset is 10. If I select first 5 skip 10 fields from table ord

AW: [firebird-support] select first and skip

Hello Mark. >Use a subquery or CTE to retrieve the rows you want, and then sort them >again with the outer query. >Mark >-- >Mark Rotteveel Many Thanks [Non-text portions of this message have been removed]

AW: [firebird-support] select first and skip

Hello Martijn, >You could use a client side sorting method, eg via a TClientDataset. >Alternatively, use a selectable stored procedure that returns the set of >records and sort ASC when selecting from the stored procedure. >Or use a Derived Table: >select * >from (select first 5 skip 10 ... or

AW: [firebird-support] select first and skip

Hello Thomas, >select * from ( >select first 5 skip 10 fields from table order by id desc >) >order by ... asc >-- >With regards, >Thomas Steinmaurer (^TS^) >Firebird Technology Evangelist > http://www.upscene.com/ Many Thanks [Non-text portions of this message

AW: [firebird-support] select first and skip

>At least we all agree. >*g* >With regards, >Martijn Tonies >Upscene Productions > http://www.upscene.com Thanks to you all, here is my solution with a statement (each ap has an different offset and other columns) Stored procedure. Returns.. stmtxt = 'select lnr,

[firebird-support] statement and composite variable names

Hello, In a stored procedure there are 6 Input Parameters F1 to F6. This varchar variables contains table-field-names and I verify this. Now I thought I can use a statement like this: i = 0; while (i < 7) do begin idexists = 0; stmtxt = 'select 1 from rdb$databa

AW: [firebird-support] statement and composite variable names

Hello, Is there no option to use internal variables (composite) in a statement? Thank your. - Hello, In a stored procedure there are 6 Input Parameters F1 to F6. This varchar variables contains table-field-names and I verify this. Now I thought I can use a statement lik

AW: AW: [firebird-support] statement and composite variable names

Hello Thomas, I have 6 input variables in a stored procedure, named F1, F2, F3, F4, F5, F6. In each variable it is entered a name of a column from a table. (F1 = column1, etc.) Now I need to check if the name in F1 to F6 is correct. I need the content of my input-variables, and I would the var

AW: [firebird-support] statement and composite variable names

Hello Helen, >... >declare variable fname varchar(31); >... >i = 1; >while (i< 7) do >begin >fname = 'F' || cast (i as char); >idexists = 0; >stmtxt = 'select 1 from rdb$database where exists(SELECT * FROM >RDB$RELATION_FIELDS >WHERE RDB$RELATION_NAME = T_DT >and RDB$FIELD_NAME = ' || fname; >

AW: [firebird-support] statement and composite variable names

Thank you helen. Now I have the real content. One question about the string: and RDB$FIELD_NAME = ''' || fname || ; results: field_name = ''COLUMNNAME''' and returns a sql exception. and RDB$FIELD_NAME = ''' || fname || '''; (your example) goes wrong. All other text after is mar

[firebird-support] String with added string-variable

Hello, Unfortunately I have not yet found a solution to the problem. I use a String and would like to add a string-variable to the string. I need before and after the string the little ' ..and RDB$FIELD_NAME = ''' || fname || ; results: field_name = ''COLUMNNAME''' and returns a sql

R: [firebird-support] String with added string-variable

Hello, I have test it now. stmtxt = 'select 1 from rdb$database where exists(SELECT * FROM RDB$RELATION_FIELDS WHERE RDB$RELATION_NAME = T_DT and RDB$FIELD_NAME = ' || fname || ''; execute statement stmtxt into :idexists; The stmtxt is '..._Name = '''COLUMNAME and I

AW: [firebird-support] String with added string-variable

Hello Helen, Unfortunately, I have no success. and RDB$FIELD_NAME = ' || '"' || fname || '"'; string: NAME = "COLUMNNAME" ' result: Invalid token. Dynamic SQL Error. SQL error code = -104. Unexpected end of command - line 4, column 22. and RDB$FIELD_NAME = ' || || fname || ;

[firebird-support] create a table every year

Hello, I would like to save the old records in a separate table every year. On the end of the year I would Copy the empty main-table to an new table named like "Backup" and the old year for example. The new backup table needs no triggers. How can I realize this? Thanks. Best regards

AW: [firebird-support] create a table every year

Hello, > > Hello, > > > > I would like to save the old records in a separate table every year. > > On the > > end of the year I would Copy the empty main-table to an new table > > named like "Backup" and the old year for example. The new backup table > > needs no triggers. > > > > How can I realize

AW: AW: [firebird-support] create a table every year

Hi Thomas, >>> Hello, >>> >>> I would like to save the old records in a separate table every year. >>> On the >>> end of the year I would Copy the empty main-table to an new table >>> named like "Backup" and the old year for example. The new backup table >>> needs no triggers. >>> >>> How can I re

AW: [firebird-support] create a table every year

Hello Mark, >If it is just for backup, why not just create a single backup table and >move all records into that table at year end. Then there is no need to >create a table per year (and it is easier to provide a unified view on >’archived' records). > >Mark my apprehension is that the querie

[firebird-support] not EM goal, but question about firebird statement

le where condition… Thank you. Best regards. Olaf Mit freundlichen Grüßen / with best regards Olaf Kluge S A T R O N Sachsen Steuerungstechnik GmbH Johann-Gottlob-Pfaff Straße 7 D-09405 Zschopau Tel: +49 (0) 3725 / 3506-31 Fax:+49 (0) 3725 / 3506-12 Mob

AW: [firebird-support] not EM goal, but question about firebird statement

dition… Thank you. Best regards. Olaf Mit freundlichen Grüßen / with best regards Olaf Kluge S A T R O N Sachsen Steuerungstechnik GmbH Johann-Gottlob-Pfaff Straße 7 D-09405 Zschopau Tel: +49 (0) 3725 / 3506-31 Fax: +49 (0) 3725 / 3506-12 Mobil: +49 (0) 170 / 9292375 E-Mail: mailto:olaf.k

AW: AW: [firebird-support] not EM goal, but question about firebird statement

Hello Thomas. If I create a stored procedure with autonomous transaction, it works fine! But if I call these stored procedure in a table-trigger, it works not. The trigger probably uses only one transaction. But the trigger isn't the right place for the stored procedure-code. Is there a possibili

AW: AW: AW: [firebird-support] not EM goal, but question about firebird statement

I create a stored procedure with autonomous transaction, it works fine! > But if I call these stored procedure in a table-trigger, it works not. The > trigger probably uses only one transaction. But the trigger isn't the right > place for the stored procedure-code. > > Is there a possibility to use

[firebird-support] begin-end with different conditions

Hello, is the following scenario possible (without a statement)? If inputvariable A is null then For select b, c, d from table a Else For select b, c, d from table b (same fields like table a but different informations (data)) Begin End The Block begin-and have the same code. I

AW: [firebird-support] begin-end with different conditions

Hello SET, thank you! >>Hello, >> >>is the following scenario possible (without a statement)? >> >>If inputvariable A is null then >>For select b, c, d from table a >>Else >>For select b, c, d from table b (same fields like table a but different >>informations (data)) >> >>Begin >> >>End >>

[firebird-support] Simple Question?

Hello everybody, today perhaps I have a simple question. In a table there are the following fields: Partnumber; quantity; price ABC; 1; 115€ ABC; 10; 100€ ABC; 20; 80€ Now I would like one sql-query-result, the price for the greatest quantity. I have the following: SELECT

AW: [firebird-support] Simple Question?

Sorry, where teilenr = a.teilenr of course… Hello everybody, today perhaps I have a simple question. In a table there are the following fields: Partnumber; quantity; price ABC; 1; 115€ ABC; 10; 100€ ABC; 20; 80€ Now I would like one sql-query-result, the price for the greatest qua

AW: [firebird-support] Simple Question?

Hello, thank you! It can be/it is so simple. Best regards Olaf Am 18.10.2012 12:57, schrieb Olaf Kluge: > Sorry, > > > > where teilenr = a.teilenr of course… > > > > > > Hello everybody, > > today perhaps I have a simple question. > &

[firebird-support] value exceeds the range for valid timestamps

Hello, today I have created some records in a table. Everything works fine. Now, I have open the table again and now I get some error messages while open the records. Timestamps until 2007xxx works fine, bit values after works not. The same error I get with gbak. Now I have deleted the

AW: [firebird-support] value exceeds the range for valid timestamps

Hi Sean, Olaf, > today I have created some records in a table. Everything works fine. Now, I > have open the table again and now I get some error messages while open > the records. Timestamps until 2007xxx works fine, bit values after works not. >>Have you recently altered the datatype of th

[firebird-support] restore a firebird 2.1 gbk in firebird 2.5

Hello, I have trouble. If I restore a fb 2.1 database-backup, I get the following error: gbak: error: value exceeds the range for valid timestamps gbak: error: gds_$send failed fbak: Exiting before completion due to errors The same Problem I had with a other database. How can I fi

Re: [firebird-support] restore a firebird 2.1 gbk in firebird 2.5

Is there anything I can do? Thanks Olaf Kluge schrieb: >Hello, > > > >I have trouble. If I restore a fb 2.1 database-backup, I get the >following >error: > > > >gbak: error: value exceeds the range for valid timestamps > >gbak: error: gds_$send failed

AW: [firebird-support] restore a firebird 2.1 gbk in firebird 2.5

In Firebird 2.1 I can restore this backup successfully. What has changed in 2.5 that the timestamp cannot be restored? Thanks. Olaf Kluge <mailto:olaf.kluge%40satron.de> olaf.kl...@satron.de> schrieb: >Hello, > > > >I have trouble. If I restore a fb 2.1 da

AW: [firebird-support] restore a firebird 2.1 gbk in firebird 2.5

I am the first and only firbird user with this issue? What can I do? Thanks. In Firebird 2.1 I can restore this backup successfully. What has changed in 2.5 that the timestamp cannot be restored? Thanks. Olaf Kluge olaf.kl...@satron.de <mailto:olaf.kluge%40satron.de> > schrieb

AW: AW: [firebird-support] restore a firebird 2.1 gbk in firebird 2.5

Hi > I am the first and only firbird user with this issue? What can I do? > > > > Thanks. I think no. ;-) In example: http://sourceforge.net/mailarchive/message.php?msg_id=23092682 Gabor Thank you!

AW: [firebird-support] Re: restore a firebird 2.1 gbk in firebird 2.5

Hello, >Hi, >View the following: > http://paulbeachsblog.blogspot.com.ar/2011/07/firebird-v21-error-value-excee ds-range.html >Regards. >-Christian- Thank you! [Non-text portions of this message

[firebird-support] special question Win 7 fb odbc

Perhaps I can get a little help in this group, the odbc devel does not insert my question at the time. I get no response. Hello, I use firebird 2.1 32 Bit cs on Server 2008. On my pc (Win 7 64 Bit) I have installed Access 2010 32 Bit and the Firebird ODBC Driver 32 Bit. The Firebird Tab

AW: [firebird-support] Using Firebird with MS Access

Hi, .. Hello all, I had previously posted about ODBC drivers, but I didn't understand how to solve the problem, so trying it again. I have Windows 7 64 bit, MS Office 32 bit version installed on 64 bit machine. I want to data from a database with extension .gdb into to MS Access. I am t

[firebird-support] sql query in firebird

Hello, fb 2.1 cs is running Now I have four tables: Persons: ID Name EMAIL ORDER: ProjectID PERSON_WHO_GET (references ID from Persons) STATUS Projects: ProjectID Manager (references ID from Persons) ProjectSEND: ProjectID PERSON_WHO_GET_INFO (references ID from Pe

AW: [firebird-support] Using Firebird with MS Access

on the Firebird webpage 2. use the Odbcad32.exe to make a System-DSN entry for your firebird database 3. in Access you can then connect to this database best regards Gerhard Am 11.02.2013 12:46, schrieb Olaf Kluge: > > Hi, > > .. > > Hello all, > I had previously post

AW: [firebird-support] sql query in firebird

Hello Sean Thanks a lot! Unfortunately the gemini interbase odbc driver works not with this union query. Even not if I create 3 single queries and call this in a union query. Is there an easy way to put them into a stored procedure without duplicates? Then I can get the return values by cal

AW: [firebird-support] sql query in firebird

Hello again, now I have test it with a pass through query and it works! Thanks! Hello Sean Thanks a lot! Unfortunately the gemini interbase odbc driver works not with this union query. Even not if I create 3 single queries and call this in a union query. Is there an easy way to put th

[firebird-support] special string question

Hello everybody, I would check a input string and change some character. For example: a or A = A Ä = [ Now I have create a table with all possible characters and the exchange character. Is there an simpler way than this? While count < strlength Character = substring(input from

RE: [firebird-support] special string question

Hello Sean. Always yes. I would create files for the data medium exchange procedure dtaus-files (bank transactions) and only some characters are allowed. All possible chars are saved in my table with translation upper and so on. Now I would like to check each character. At the time I have creat

[firebird-support] sql error

Hello, with this code I get an sql error, but it works until today perfect :o( with wgetnextprio as (select prio, count(*) as kount from tfachzuordnung where le is null and gesperrt = 0 and elementtyp = 1 and paltyp = :paltyp_anfrage group by prio) select first 1 prio from wge

AW: [firebird-support] sql error

Hi, Thanks you and Paul. I think it's a problem of ibexpert Version 2009. Although I can select the fb 2.5 version, but while debugging I get this error. If I execute the sp, it works. Before I check the count of any Prio, I have a look for any free storage compartments. Thank you

[firebird-support] question table numbers in select

Hello, I would like to assign a element-group to an table. For example group valve - table t_valve. Now I can realize this with an statement, but perhaps I can assign the table not by its name, rather with its table ID? Maybe I can select the ID and. "select * from TABLEID where xxx"? It is

AW: [firebird-support] question table numbers in select

Hello Ann, >On Wed, May 8, 2013 at 10:31 AM, Olaf Kluge < <mailto:olaf.kluge%40satron.de> olaf.kl...@satron.de> wrote: >> >> I would like to assign a element-group to an table. For example group valve >> - table t_valve. Now I can realize this with an statemen

AW: [firebird-support] question table numbers in select

Hello Set, >> I would like to assign a element-group to an table. For example group >> perhaps I can assign the table not by its name, rather with its table >> ID? Maybe I can select the ID and. "select * from TABLEID where xxx"? > >Is there a possible way to select/insert records in a table wher

AW: [firebird-support] question table numbers in select

Hi Set >>Now I get the tablename from tcategory and I would like to update the record in the right table. >>Your suggestion is a viable way. It does not seem to be possible without a statement? >I don't think I understand, in order to do an update, I always use an UPDATE statement, in order

AW: [firebird-support] question table numbers in select

Hi Set. I think the 2nd Way ist the better. In the first, I must integrate each new table. The solution with views is great. Hitherto I wanted to implement this on the table-level for a better clarity. Thanks for your great thought for thought :o) Have a nice weekend. Best reg

[firebird-support] Litte question about indexes

Hello, in a table A there is a primary key, one column named ID. The second table B uses a single Field named ID_TableA, it references to the Table A (foreign key) and this field is the primary key too. (1 to 1 relation). Now I have two indexes for one Table-Column. Is this an problem? Than

AW: [firebird-support] Litte question about indexes

Thank you Ann. On Fri, May 31, 2013 at 2:50 AM, Olaf Kluge mailto:olaf.kluge%40satron.de> > wrote: > > in a table A there is a primary key, one column named ID. The second table > B > uses a single Field named ID_TableA, it references to the Table A (foreign > key)

[firebird-support] firebird sql alias for condition

Hello, I did the following: select first 1 cast(d_ein || ' ' || z_ein as timestamp) as tmp from t_zeitschaltuhr order by tmp into :tmp_next_e; select first 1 cast(d_aus || ' ' || z_aus as timestamp) as tmp from t_zeitschaltuhr order by tmp into :tmp_next_a; d_ein is a date, z_ein a ti

AW: [firebird-support] firebird sql alias for condition

Hello, thanks @ all. I just have one question. One dataset includes a date + time to switch on and a date + time to switch off. I would like to get the timestamp next time on and next time off. In the simplest case both times from one dataset are in the future. Now it can be, that the

AW: [firebird-support] Check previous records in the table before table update

Hello Kukiejko. You mean that you can only update a dataset with time is not null? First, you should not use a column-name like "time". In this case you mean ID 233 is possible and ID 234 not? If you use a trigger, you'll never can update the time-column because it is never possible if the old

AW: [firebird-support] firebird sql alias for condition

Thank you Set :o) >One dataset includes a date + time to switch on and a date + time to switch >off. I would like to get the timestamp next time on and next time off. In >the simplest case both times from one dataset are in the future. Now it can >be, that the next time to switch on listed

[firebird-support] NOT in Firebird

Hello, for example there are two variables. Var1 = 0 Now I would like to negate the Var1 to Var2. If var1 = 0, then should Var2 = 1 and in the other direction. Ist it possible Var2 = invert(var1)?? Thank you. Best regards. Olaf [Non-text portions of this message have

AW: [firebird-support] NOT in Firebird

Hello Mark, great, exactly what I was looking for. Only 1 and 0 is possible. Thank you. Olaf On Thu, 4 Jul 2013 10:34:21 +0200, "Olaf Kluge" < <mailto:olaf.kluge%40satron.de> olaf.kl...@satron.de> wrote: > for example there are two variables. > > Va

[firebird-support] Cannot transliterate character between character sets.

Hello. In a Table-Field with character set ISO8859_1 there is a record with invalid content. If I select all records, then I get the following Error Message with IBExpert: Cannot transliterate character between character sets. How can I find simply the wrong record? Thanks in advance.

AW: [firebird-support] Cannot transliterate character between character sets.

Hello Tomasz, I have created a stroed procedure to find the records. There are some with the mm² (²) (pow) and I get the error messeage with ibexpert. But I was wondering, our Java (jaybird) application displays me all records, also the problematic. The charset is in every case ISO8859_1. What

AW: AW: [firebird-support] Cannot transliterate character between character sets.

Hello @ll, The connection from IBExpert is set to ISO8859_1, I don't know the configuration of jaybird (Application is not mine and can only READ this data). A external company writes us data in our import tables (exactly same ISO-charset) and a Trigger import this into the main table. But why

AW: AW: [firebird-support] Cannot transliterate character between character sets.

The character ² is integrated in ISO8859_1. http://de.wikipedia.org/wiki/ISO_8859-1 Oh Sorry, I just realized that I set the character set from ibexpert of my database to iso 8859_2 and there is the character missing. My mistake. Best regards. --- Hello @ll, The connection from IBExpert

[firebird-support] view and computation

Hello, in a view, the following expression is possible : .(a.eingangsdatum+coalesce(c.zahldauer,0)) as FAE,. But how can I take the current date in relation? For example: cast((current_date - (a.eingangsdatum+coalesce(c.zahldauer,0))) as integer) as FIN I would like to calculate when the pay

  1   2   >