Groups | Search | Server Info | Keyboard shortcuts | Login | Register [http] [https] [nntp] [nntps]
Groups > comp.lang.clipper.visual-objects > #3769
| From | "Arne Ortlinghaus" <Arne.Ortlinghaus@acs.it> |
|---|---|
| Newsgroups | comp.lang.clipper.visual-objects |
| Subject | Re: Mod() function and large numbers |
| Date | 2012-07-13 17:37 +0200 |
| Organization | A noiseless patient Spider |
| Message-ID | <jtpfbu$rh4$1@dont-email.me> (permalink) |
| References | <a7fd55fb-41b1-41bb-86d4-5c264caad5e3@googlegroups.com> <j8RLr.803269$S84.238223@fx23.am4> <6cRLr.803270$S84.659476@fx23.am4> |
I can also offer some IBAN Check code using the arithmetic of an Oracle
database.
Arne Ortlinghaus
ACS Data Systems
method ValidateIBAN(cIBANChar as string) class clsIBAN
local cIBANTmp1, cIBANTmp2, cChar, cSql as string
local iPos as dword
local nChDig as usual
if ascan(_aLaender,left(cIBANChar,2)) == 0
return true
end if
cIBANChar := AllTrim(cIBANChar) // Todo 66425 AO 12.07.2012 Runtimefehler
bei IBAN-Prüfung im Falle von falschen Zeichen
cIBANTmp1 := substr(cIBANChar,5)+left(cIBANChar,4)
cIBANTmp2 := ""
for iPos := 1 to slen(cIBANTmp1)
cChar := substr(cIBANTmp1,iPos,1)
if ! isdigit(string2psz(cChar))
cChar := str(asc(cChar)-55,2)
end if
cIBANTmp2 += cChar
next
if !Empty(Val(cIBANTmp2)) // Todo 63367 Fehlermeldung bei Import IBAN in
Kunden/Lieferanten
cSql := 'SELECT MOD('+SQLValue2SQLString(cIBANTmp2)+',97) "Modulus" FROM
DUAL'
nChDig := GetSQLValueFast(cSql, "N", 10, 0, 0, null_object, true)
else
nChDig := 0
endif
//msginfo(cIBANChar+chr(13)+chr(10)+cIBANTmp1+chr(13)+chr(10)+cIBANTmp2+chr(13)+chr(10)+cSql+chr(13)+chr(10)+typevalue2string(nChDig))
return nChDig == 1
method Init(oOwner, oServer) class clsIBAN
_oOwner := oOwner
_oServer := oServer
_aLaender := ArrayCreate(18)
_aLaengen := ArrayCreate(18)
_aLaender[1] := "IT"
_aLaengen[1] := 27
_aLaender[2] := "AT"
_aLaengen[2] := 20
_aLaender[3] := "BE"
_aLaengen[3] := 16
_aLaender[4] := "CH"
_aLaengen[4] := 21
_aLaender[5] := "DE"
_aLaengen[5] := 22
_aLaender[6] := "DK"
_aLaengen[6] := 18
_aLaender[7] := "ES"
_aLaengen[7] := 24
_aLaender[8] := "FI"
_aLaengen[8] := 18
_aLaender[9] := "FR"
_aLaengen[9] := 27
_aLaender[10] := "GB"
_aLaengen[10] := 22
_aLaender[11] := "IE"
_aLaengen[11] := 22
_aLaender[12] := "IS"
_aLaengen[13] := 26
_aLaender[13] := "LU"
_aLaengen[13] := 20
_aLaender[14] := "NL"
_aLaengen[14] := 18
_aLaender[15] := "NO"
_aLaengen[15] := 15
_aLaender[16] := "PT"
_aLaengen[16] := 25
_aLaender[17] := "SE"
_aLaengen[17] := 24
_aLaender[18] := "SM"
_aLaengen[18] := 27
return self
class clsIBAN
protect _oOwner as object
protect _oServer as object
protect _aLaender as array
protect _aLaengen as array
declare method ValidateIBAN
Back to comp.lang.clipper.visual-objects | Previous | Next — Previous in thread | Next in thread | Find similar | Unroll thread
Mod() function and large numbers Milun Vasilijevic <milun.vasilijevic@gmail.com> - 2012-07-12 18:36 -0700
Re: Mod() function and large numbers "Stephen Quinn" <stevejqNO@bigpondSPAM.net.au> - 2012-07-13 15:50 +1000
Re: Mod() function and large numbers Sherlock <sherlock@sherlock.com.au> - 2015-08-01 17:15 -0700
Re: Mod() function and large numbers Norbert Kolb <n.kolb_entferne_dies@aon.at> - 2012-07-13 10:36 +0200
Re: Mod() function and large numbers Norbert Kolb <n.kolb_entferne_dies@aon.at> - 2012-07-13 10:45 +0200
Re: Mod() function and large numbers Paulo Oliveira <paulo@clipinfor.com> - 2012-07-13 04:20 -0700
Re: Mod() function and large numbers Norbert Kolb <n.kolb_entferne_dies@aon.at> - 2012-07-13 16:59 +0200
Re: Mod() function and large numbers Milun Vasilijevic <milun.vasilijevic@gmail.com> - 2012-07-14 11:40 -0700
Re: Mod() function and large numbers Milun Vasilijevic <milun.vasilijevic@gmail.com> - 2012-07-14 11:43 -0700
Re: Mod() function and large numbers Malcolm G <malcolm-news2012delete@delete.jobstream.com> - 2012-07-13 09:38 +0100
Re: Mod() function and large numbers Malcolm G <malcolm-news2012delete@delete.jobstream.com> - 2012-07-13 09:42 +0100
Re: Mod() function and large numbers "Arne Ortlinghaus" <Arne.Ortlinghaus@acs.it> - 2012-07-13 17:37 +0200
Re: Mod() function and large numbers jamesvdb@lavabit.com - 2015-08-01 08:12 -0700
csiph-web