1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 32 33
| procedure TFullScreen.TablesCreate;
var
req : string;
PW: Integer;
begin
PW:= PeekGraphDLL_PassWordToInteger('admin');
ADOConnection1.ConnectionString := Format(_ConnString,[_UserName,_PassWord,MDBFile]);
ADOConnection1.LoginPrompt := False;
ADOCommand1.Connection := ADOConnection1;
//************************************************************* table DBUser
req:= 'CREATE TABLE DBUSER (' +
' USER_NO INTEGER NOT NULL DEFAULT 1, '+ // Clé primaire
' USER_DBTYPE BYTE NOT NULL DEFAULT '+IntToStr(_BD_LOCALE)+', ' +
' USER_PASS INTEGER NOT NULL DEFAULT '+IntToStr(PW)+', ' + // "admin" crypté
' USER_RIGHTS INTEGER NOT NULL DEFAULT 2147483647, ' + // all rights
' USER_CONVERSION BYTE NOT NULL DEFAULT '+IntToStr(_ADOBE_RGB_1998)+', ' +
' USER_ILLUMINANT BYTE NOT NULL DEFAULT '+IntToStr(Cie_Ill_D65)+', ' +
' USER_OBSERVER BYTE NOT NULL DEFAULT ' +IntToStr(Cie_Obs1931)+', ' +
' USER_NAME VARCHAR(32) NOT NULL DEFAULT "PEEK", ' +
' USER_USED BIT DEFAULT -1 '+
')';
ADOCommand1.CommandText := req;
ADOCommand1.Execute;
// ==================== Clé primaire
req := 'ALTER TABLE DBUSER ADD CONSTRAINT PK_OPERATOR PRIMARY KEY (USER_NO);';
ADOCommand1.CommandText := req;
ADOCommand1.Execute;
//===================== Procédure stockée pour ecrire un Utilisatezur
req:= 'CREATE PROC procUserAddItem(UserNo INTEGER, UserName VARCHAR(32) )'+
'AS INSERT INTO DBUSER (USER_NO, USER_NAME ) '+
'Values (UserNo, UserName);';
ADOCommand1.CommandText := req;
ADOCommand1.Execute; |
Partager