Groups | Search | Server Info | Keyboard shortcuts | Login | Register [http] [https] [nntp] [nntps]


Groups > comp.lang.clipper.visual-objects > #3769

Re: Mod() function and large numbers

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>

Show all headers | View raw


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


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