Evo test primera:
Code:
CREATE TABLE `komanda` (
`KomandaID` int(11) NOT NULL auto_increment,
`DatumVreme` datetime NOT NULL default '0000-00-00 00:00:00',
`Komanda` varchar(32) collate ascii_bin default NULL,
`Parametar` varchar(4096) collate ascii_bin default NULL,
PRIMARY KEY (`KomandaID`),
KEY `Komanda` (`Komanda`)
) ENGINE=InnoDB DEFAULT CHARSET=ascii COLLATE=ascii_bin;
INSERT INTO `komanda` (`KomandaID`, `DatumVreme`, `Komanda`, `Parametar`) VALUES
(NULL, '2007-10-07 09:06:03', 'SKINI_POKRENI', 'Integritet.rar'),
(NULL, '2007-12-13 12:04:41', 'SKINI_POKRENI', 'proslo.rar'),
(NULL, '2008-01-25 08:47:41', 'SKINI_POKRENI', 'pont.rar'),
(NULL, '2008-01-25 08:48:17', 'SKINI_POKRENI', 'ponk.rar'),
(NULL, '2008-02-15 22:05:41', 'SKINI_POKRENI', 'mail.rar');
Aplikacija je Delphi 7, koristi ADOConnection, sa ConnectString-om:
Provider=MSDASQL.1;Persist Security Info=False;Data Source=AppConn1;Extended Properties="DSN=AppConn1;"
Zašto ODBC? Tako nasledjeno...
Two beer or not two beer...