Advertisement
fahmihilmansyah

Untitled

Nov 26th, 2013
121
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
Delphi 1.22 KB | None | 0 0
  1. procedure TfrmLogin.FormCreate(Sender: TObject);
  2. begin
  3. try
  4.   Frmdmdb.DBKonek.Host:=frmMain.DBHOST;
  5.   Frmdmdb.DBKonek.UserName:=frmMain.DBUSER;
  6.   Frmdmdb.DBKonek.UserPassword:=frmMain.DBPASS;
  7.   Frmdmdb.DBKonek.DatabaseName:=frmMain.DBNAME;
  8.   //ShowMessage('berhasil konek 1');
  9.  
  10.   Frmdmdb.DBKonekBackUp.Host:=frmMain.DBHOST1;
  11.   Frmdmdb.DBKonekBackUp.UserName:=frmMain.DBUSER1;
  12.   Frmdmdb.DBKonekBackUp.UserPassword:=frmMain.DBPASS1;
  13.   Frmdmdb.DBKonekBackUp.DatabaseName:=frmMain.DBNAME1;
  14.   //ShowMessage('berhasil konek 2');
  15.  
  16. with Frmdmdb do
  17. begin
  18.   qrySearch.Close;
  19.   qrySearch.SQL.Clear;
  20.   qrySearch.SQL.Add('SELECT * FROM tb_user');
  21.   qrySearch.Open;
  22. end;
  23. finally
  24.     with frmMain do
  25.     begin
  26.       exSQLData.SQL.Clear;
  27.       exSQLData.SQL.Add( 'CREATE DATABASE /*!32312 IF NOT EXISTS*/ `db_histori`;USE `db_histori`;'+
  28. 'DROP TABLE IF EXISTS `tb_user`;'+
  29. 'CREATE TABLE `tb_user` ('+
  30. '  `id_user` int(11) NOT NULL AUTO_INCREMENT,'+
  31. '  `user` text NOT NULL,'+
  32. '  `namauser` text NOT NULL,'+
  33. '  `password` text NOT NULL,'+
  34. '  PRIMARY KEY (`id_user`)'+
  35. ') ENGINE=InnoDB AUTO_INCREMENT=4 DEFAULT CHARSET=latin1;'+
  36. 'INSERT INTO `tb_user` VALUES(1,"admin","admin","admin");'
  37.      );
  38.       exSQLData.ExecSQL;
  39.     end;
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement