🚀 go-pugleaf

>In Query designer or on navigator, if i execute a query a message of
>read-only rowset appears.

Read-only rowsets usually result from a SQL join that cannot return anything
*but* a read-only rowset. If you're using native tables, try linking them
using the data objects' properties designed for the purpose. See the help on
the indexName, masterRowset, and masterFields properties, as used in this
example:

----------
You can link a set of native tables (.DBF and .DB) using the relevant
properties of the rowset objects of the tables' query objects. Here follows
an example of a datamodule comprised of three related tables from \Visual
dBASE\Samples\Mugs\Tables:

** END HEADER -- do not remove this line
//
// Generated on 12/26/1997
//
class demoDataModule of DATAMODULE

   this.CUSTOMER1 = new QUERY()
   this.CUSTOMER1.parent = this
   with (this.CUSTOMER1)
      left = 1.4286
      top = 0.3182
      sql = 'select * from "Customer.dbf"'
      active = true
   endwith

   with (this.CUSTOMER1.rowset)
      indexName = "LAST NAME"
   endwith

   this.INVOICE1 = new QUERY()
   this.INVOICE1.parent = this
   with (this.INVOICE1)
      left = 6.2857
      top = 1.8182
      sql = 'select * from "Invoice.dbf"'
      active = true
   endwith

   with (this.INVOICE1.rowset)
      indexName = "CUSTOMER ID"
      masterRowset = parent.parent.customer1.rowset
      masterFields = "Customer ID"
   endwith

   this.LINEITEM1 = new QUERY()
   this.LINEITEM1.parent = this
   with (this.LINEITEM1)
      left = 11.2857
      top = 3.3182
      sql = 'select * from "Lineitem.dbf"'
      active = true
   endwith

   with (this.LINEITEM1.rowset)
      indexName = "INVOICE ID"
      masterRowset = parent.parent.invoice1.rowset
      masterFields = "Invoice ID"
   endwith

   this.rowset = this.customer1.rowset
endclass
----------
__
Bowen Moursund (TeamB)
bowen.NOSPAM@nerds.com
http://www.mindspring.com/~bowenm/datatech.htm