🚀 go-pugleaf

>I have a very long sql statement opening several files, several joins,
>conditional statements, etc.  The grid comes out great with all the correct
>relations etc.  However, when I try to edit a field, I just get a "beep"
>and I cannot perform an update.

Joins in VdB are very often read only. You can instead 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://lonestar.texas.net/~moursund/
Try this help resource:
 http://www.dejanews.com/home_ps.shtml