Page 1 of 1

:sorry: Database Connect Component is not Assigned delphi 7

Posted: 23.03.2011, 13:33
by azrael11
I connect with the database successfully
When i try to make some tables with this code in the Conf.ZQuery.ExecSQL; i get the above error

Code: Select all

cs := 'CREATE TABLE MainProgram'+
        '(Name TEXT(50),'+
        'NameExe TEXT(50),'+
        'Path TEXT(250),'+
        'Ver Text(50),'+
        'V1 Text(100),'+
        'V2 Text(100),'+
        'V3 Text(100),'+
        'V4 Text(100),'+
        'V5 Text(100),'+
        'V6 Text(100),'+
        'V7 Text(100),'+
        'V8 Text(100),'+
        'V9 Text(100),'+
        'V10 TEXT(100))';
  Conf.ZQuery.SQL.Clear;
  Conf.ZQuery.SQL.Add(cs);
  Conf.ZQuery.ExecSQL;

Please help

Posted: 23.03.2011, 15:10
by azrael11
So silly i forgot to make a connection of zquery and zconnection

Case Closed....

Posted: 24.03.2011, 12:49
by jeremicm
Adding Conf.ZQuery.Close on top is good idea...