Re: [firebird-support] How to do a join delete with Flamerobin V 0.9.2.1851

2013-03-19 Thread Helen Borrie
At 02:08 a.m. 20/03/2013, rosssmith55 wrote: >Hello! I am fairly new to learning SQL, I am attempting to learn how to do a >Join > Delete using flamerobin and was told this is a great place to learn >good stuff :) Any way this is what i got so far. > >SELECT a.INV_PARTNUMBER, a.INV_ALTPARTNUMBER,

RE: [firebird-support] special string question

2013-03-19 Thread Leyne, Sean
Olaf, > 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 create

RE: [firebird-support] special string question

2013-03-19 Thread Olaf Kluge
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

Re: [firebird-support] Path to aliases.conf?

2013-03-19 Thread Helen Borrie
At 06:51 a.m. 20/03/2013, Jacob Havkrog wrote: >Hi > >Where does gstat (gbak, gfix) look for the aliases.conf file? A client application doesn't need to know where aliases.conf is. It is a component of the server, not of a client. The purpose of database aliasing is to make the location of the

[firebird-support] Path to aliases.conf?

2013-03-19 Thread Jacob Havkrog
Hi Where does gstat (gbak, gfix) look for the aliases.conf file? In the directory above? (.\..\aliases.conf relative to the location of gstat.exe) ? C:\Program Files\Firebird\Firebird_2_5\? (depending on installation directory of the FB server) But what if there's no server installed? I'd li

[firebird-support] How to do a join delete with Flamerobin V 0.9.2.1851

2013-03-19 Thread rosssmith55
Hello! I am fairly new to learning SQL, I am attempting to learn how to do a Join > Delete using flamerobin and was told this is a great place to learn good stuff :) Any way this is what i got so far. SELECT a.INV_PARTNUMBER, a.INV_ALTPARTNUMBER, b.INVSUP_SUPPNUM, a.INV_DESCRIPTION1, a.INV_DESC

RE: [firebird-support] special string question

2013-03-19 Thread Leyne, Sean
Olaf, > Is there an simpler way than this? > > While count < strlength > > Character = substring(input from count for 1) > > Select exchangecharakter from table where inputcharacter = character into > :newcharacter > > Newstring = newstring || newcharacter; Is the character mapping "user defi

[firebird-support] special string question

2013-03-19 Thread Olaf Kluge
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