borland.sql.dataset.QueryDataSet

From: Bo Christensen <bo_christensen_at_saxotech.com>
Date: Tue, 04 May 1999 16:03:47 +0200
Message-ID: <372EFE42.F50E8C3C_at_saxotech.com>

Hello, can anyone help me, I need some examples, in using borland.sql.dataset.QueryDataSet

I'm having problems when I save my QueryDataSet
I get this exception :
Error: borland.jbcl.dataset.DataSetException: Cannot be saved.  Specify TableName property on DataSet.
Note: For QueryDataSets you need to disable metaDataUpdate.TABLENAME in the MetaDataUpdate property, in addition to setting the Tablename property.

My database connection looks like this:

public synchronized QueryDataSet sendSQL(String sqlStr)
 {
  try {
      dataset = new QueryDataSet();
       if (dataset.isOpen()) dataset.close();
       dataset.setQuery(new QueryDescriptor(database,sqlStr, null,true,false));
       dataset.setEnableInsert(true);
       dataset.setEnableUpdate(true);
       dataset.setEditable(true);
       dataset.setEnableDelete(true);
       dataset.setMetaDataUpdate(borland.jbcl.dataset.MetaDataUpdate.TABLENAME);
       dataset.setColumns(new Column[] {(Column)columnID.clone()});
       dataset.setSchemaName("SAXO_QUERY");
       dataset.open();
       dataset.first();
   return dataset;
  } catch (Exception e) {
   System.out.println(" ERROR IN "+ e.getMessage());
   return null;
  }

Please help

Best Regards
Bo Christensen Received on Tue May 04 1999 - 16:03:47 CEST