🚀 go-pugleaf

>Why JOIN query generate read-only rowset ?

See the online help topic 'local sql,restrictions'.

>And i can resolve this problem ?

You can link a set of native tables (.DBF and .DB) using the indexName,
masterRowset, and masterFields 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)
bowenNOSPAM@nerds.com
http://www.mindspring.com/~bowenm/datatech.htm

  Try these help resources:
  http://forumsearch.borland.com:88
  http://www.dejanews.com/home_ps.shtml