AW: [firebird-support] string difficulty

Hello, but this ist almost realized in my code, isn't it? >From right until there is no * present Von: firebird-support@yahoogroups.com [mailto:firebird-support@yahoogroups.com] Gesendet: Montag, 7. Dezember 2015 23:28 An: firebird-support@yahoogroups.com Betreff: RE:

AW: [firebird-support] string difficulty

Thank you Set :) Von: firebird-support@yahoogroups.com [mailto:firebird-support@yahoogroups.com] Gesendet: Montag, 7. Dezember 2015 20:59 An: firebird-support@yahoogroups.com Betreff: Re: [firebird-support] string difficulty Den 07.12.2015 13:55, skrev 'checkmail'

Re: [firebird-support] string difficulty

How can I get ABC*DEFG, leave the * between C*D, delete all * from right? SET TERM ^ ;CREATE PROCEDURE DEL_CHAR (    M_SIR varchar(500),    M_CHAR varchar(10) )RETURNS (    M_STR varchar(500) )AS    declare ii smallint;     declare iy smallint;BEGIN    m_str='';    iy=char_length(m_sir);   

AW: [firebird-support] string difficulty

Hi, first, thank you! But it should only delete the right * For example, the ID is ABCDEFG, the interface will tell me ABCDEFG*01 In this case, from right, all * should deleted. But If the ID is ABC*DEFG, I get ABC*DEFG01 and in this case only all * from right

[firebird-support] string difficulty

Hello @ll, I have an input string ABCDEFG, filled with * to 16 chars, ABCDEFG*, followed with zwo digits, f. e. 01 ABCDEFG*01 01 can I cut for an other function, now I have ABCDEFG* The filled * I can delete for my real ID (ABCDEFG) left(:str, position('*' in

Re: [firebird-support] string difficulty

Hi, using your code, how about left(:str, position('**' in :str)-1)); select left(:str, position('**' in :str)-1)) from yourtable However, to make things easier for future users, think about changing the single '*' to e.g. '-' and then you can keep your existing select statements and not have

AW: [firebird-support] string difficulty

Hi, it is a sub-function an I get a string, I dont select it from a table. Our customer should not use the * in the id, but he did. In the interface to the cheer is set to it with filling *. Thank you -Ursprüngliche Nachricht- Von: firebird-support@yahoogroups.com

Re: AW: [firebird-support] string difficulty

a quick answer : m_char='**' On Monday, December 7, 2015 12:12 PM, "'checkmail' check_m...@satron.de [firebird-support]" wrote: But If the ID is ABC*DEFG, I get ABC*DEFG01 and in this case only all * from right should be deleted.  I have

Re: AW: [firebird-support] string difficulty

sorry, wrong response :( On Monday, December 7, 2015 12:22 PM, "Virna Constantin costel...@yahoo.com [firebird-support]" wrote: #yiv0072394990 #yiv0072394990 -- #yiv0072394990

Re: AW: [firebird-support] string difficulty

select replace('ABC*DEFG01','**','') from RDB$DATABASE On Monday, December 7, 2015 12:26 PM, "Virna Constantin costel...@yahoo.com [firebird-support]" wrote: #yiv7701085015 #yiv7701085015 -- #yiv7701085015

[firebird-support] FB lock files

I noticed our biggest data server have a lot of hard disk activity creating fb_lock files. Firebird 2.5.4, superclassic My changed lock configurations are : #LockMemSize = 1048576 LockMemSize = 10097152 #LockHashSlots = 1009 LockHashSlots = 60589 Should I try to set them higher? If

AW: AW: [firebird-support] string difficulty

But in this case The comparision should be for two chars while (ii<=iy) do begin if (position(substring(m_sir from ii for 2),m_char)=0) then m_str=m_str||substring(m_sir from ii for 1); ii=ii+1; end But, if the original ID like TEIL***ABC Then

AW: AW: [firebird-support] string difficulty

.. and if the ID has the length of 15 chars and only the las * is for filling out to 16, i get a wrong result too. Can I compact my code? if(char_length(str)>16) then begin str = left(:str,16); while (k = 1) do begin if(right(str, 1) = '*') then begin

Re: [firebird-support] string difficulty

Den 07.12.2015 13:55, skrev 'checkmail' check_m...@satron.de [firebird-support]: > .. and if the ID has the length of 15 chars and only the las * is for filling out to 16, i get a wrong result too. > > Can I compact my code? > > if(char_length(str)>16) then > begin > str =

RE: [firebird-support] string difficulty

How about working backwards through the string? Andrew Zenz From: firebird-support@yahoogroups.com [mailto:firebird-support@yahoogroups.com] Sent: Tuesday, 8 December 2015 6:59 AM To: firebird-support@yahoogroups.com Subject: Re: [firebird-support] string

[firebird-support] Alternative to Java Zebedee

Hi guys, Since Zebedee for Java is a beta ver. and not maintain again, are there any alternative to this program? Thanks in advance. Regards, Anto

RE: [firebird-support] Alternative to Java Zebedee

Hi guys, Since Zebedee for Java is a beta ver. and not maintain again, are there any alternative to this program? Thanks in advance. Regards, Anto Linux or pc?

RE: [firebird-support] Alternative to Java Zebedee

I need a Java jar file, so it can run on Linux or Windows.