Validating identity on windows xp
Regards;candice There is no way you can do this by looking at the number itself - there is no 'allocated flag' or any data built into the number.The only way is to use the Home Affairs link at the top of this post.This is a worrying situation, especially with the recent corruption reports that we get regarding the Home Affairs Department.Concerned Norman Nosi Hi Kats, All the old and new ID numbers that I tested worked - but that included less than 100 old ID numbers...Regards, Willem Hi Guys, I tried to find a SQL Implementation of this function but Google failed me but I still know one exists. Let me know what you think:-- =============================================-- Author: Craig Peacock-- Create date: 08/10/2007-- Description: This will validate a SA ID Number-- =============================================ALTER PROCEDURE [dbo].[VAL_S01_Validate SAIDNumber] @IDNumber VARCHAR (13)ASBEGIN /* This function was created from the function posted at: DECLARE @A INT -- ~Holds Negative Index numbers DECLARE @B INT -- ~Holds Positive Index numbers DECLARE @C INT DECLARE @D INT -- ~The check digit DECLARE @I INT -- ~Counter Variable SET @D = -1 SET @A = 0 SET @B = 0 BEGIN TRY PRINT 'Getting Negative Numbers____________________' SET @I = 0 WHILE (@I 0) BEGIN SET @C = @C @B % 10 SET @B = @B / 10 END --WHILE SET @C = @C @A SET @D = 10 - (@C % 10) IF (@D = 10) SET @D = 0 IF (CAST(SUBSTRING(@IDNumber, 13, 1) AS INT) = @D) RETURN 1 ELSE RETURN 0 END TRY BEGIN CATCH RETURN 0 END CATCH RETURN 0END Willem and Craig, I tried the SQL previously on the blog and it worked (old and new numbers).
Recently (probably because elections are passed) the site stopped supplying names, but only confimed whether registered or not... Did you know: The current SA ID Number algorithm was created by my uncle Pieter den Boer (ex Q-Data, Brainware...) while working at IBM in the 1980's.
Probably, only the Department of Home Affairs can answer your question.
If you are looking for a test to discern the old numbers from the new numbers, this isn't it!
He passed away last week - I attended his funeral this morning.
A great mathematical mind an Business man will sorely be missed. I assume that if there are SA citizens with an ID from the year 1900, that this would use the same year number: '00'. However, I am not sure if you can distinguish a '1900' ID from a '2000' ID etc.
NET webservice to validate South African Person ID numbers.