| Bill Dilmore 2006-10-04, 7:29 pm |
| I resolved my problem. When all else fails, check the tables...
empName widths did not match.
Thanks for the help,
Bill
Bill Dilmore Wrote:
> Here's the code for my DMD and Form
>
> Any help is greatly appreciated
>
> Thanks,
> Bill
>
> DMD
>
> class workQrderDATAMODULE of DATAMODULE
> with (this)
> left = -1.0
> top = -1.0
> endwith
>
> this.WORKDATAENTRY1 = new DATABASE()
> this.WORKDATAENTRY1.parent = this
> with (this.WORKDATAENTRY1)
> left = 19.0
> top = 135.0
> width = 115.0
> height = 112.0
> databaseName = \"workDataEntry\"
> active = true
> endwith
>
> this.WORKPART1 = new QUERY()
> this.WORKPART1.parent = this
> with (this.WORKPART1)
> left = 125.0
> top = 255.0
> width = 114.0
> height = 129.0
> database = form.workdataentry1
> sql = 'Select * from \"WORKPART\"'
> active = true
> endwith
>
> this.WORKORDER1 = new QUERY()
> this.WORKORDER1.parent = this
> with (this.WORKORDER1)
> left = 232.0
> top = 43.0
> width = 114.0
> height = 111.0
> database = form.workdataentry1
> sql = 'Select * from \"workOrder\"'
> active = true
> endwith
>
> with (this.WORKORDER1.rowset)
> indexName = \"JOBNO\"
> endwith
>
> this.EMPWORK1 = new QUERY()
> this.EMPWORK1.parent = this
> with (this.EMPWORK1)
> left = 358.0
> top = 101.0
> width = 114.0
> height = 114.0
> database = form.workdataentry1
> sql = 'Select * from \"empWork\"'
> active = true
> endwith
>
> with (this.EMPWORK1.rowset)
> indexName = \"JOBNO\"
> masterRowset = form.workorder1.rowset
> endwith
>
> this.EMPLOYEE1 = new QUERY()
> this.EMPLOYEE1.parent = this
> with (this.EMPLOYEE1)
> left = 512.0
> top = 101.0
> width = 114.0
> height = 114.0
> database = form.workdataentry1
> sql = 'Select * from \"employee\"'
> active = true
> endwith
>
> with (this.EMPLOYEE1.rowset)
> indexName = \"EMPNAME\"
> masterRowset = form.empwork1.rowset
> masterFields = \"empName\"
> endwith
>
>
> endclass
>
>
>
>
>
> and the form
> class workentryForm of FORM
> set procedure to workQrder.dmd additive
> with (this)
> height = 17.5909
> left = 25.7143
> top = 0.0909
> width = 87.4286
> text = \"Workorder\"
> escExit = false
> scrollBar = 2 // Auto
> endwith
>
> this.WORKQRDERDATAMODULE1 = new WORKQRDERDATAMODULE()
> this.WORKQRDERDATAMODULE1.parent = this
> with (this.WORKQRDERDATAMODULE1)
> left = 72.0
> top = 15.5
> endwith
>
> with (this.WORKQRDERDATAMODULE1.WORKORDER1.rowset)
> indexName = \"JOBNO\"
> masterRowset = Null
> masterFields = \"jobNo\"
> endwith
>
> with (this.WORKQRDERDATAMODULE1.EMPWORK1.rowset)
> indexName = \"JOBNO\"
> masterFields = \"jobNo\"
> navigateByMaster = false
> endwith
>
> this.ENTRYFIELDJOBNO1 = new ENTRYFIELD(this)
> with (this.ENTRYFIELDJOBNO1)
> dataLink = form.workqrderdatamodule1.workorder1.rowset.fields[\"jobno\"]
> enabled = false
> height = 1.0
> left = 7.0
> top = 2.0
> width = 8.0
> tabStop = false
> endwith
>
> this.SPINBOXJOBDATE1 = new SPINBOX(this)
> with (this.SPINBOXJOBDATE1)
> dataLink = form.workqrderdatamodule1.workorder1.rowset.fields[\"jobdate\"]
> enabled = false
> height = 1.0
> left = 25.0
> top = 2.0
> width = 14.0
> rangeMax = {05/04/2005}
> rangeMin = {01/24/2005}
> tabStop = false
> endwith
>
> this.EDITORJOBDESCR1 = new EDITOR(this)
> with (this.EDITORJOBDESCR1)
> height = 2.5
> left = 7.0
> top = 5.0
> width = 73.0
> dataLink = form.workqrderdatamodule1.workorder1.rowset.fields[\"jobdescr\"]
> endwith
>
> this.GRID1 = new GRID(this)
> with (this.GRID1)
> dataLink = form.workqrderdatamodule1.empwork1.rowset
> columns[\"COLUMN1\"] = new GRIDCOLUMN(form.GRID1)
> columns[\"COLUMN1\"].dataLink = form.workqrderdatamodule1.empwork1.rowset.fields[\"jobno\"]
> columns[\"COLUMN1\"].editorType = 1 // EntryField
> columns[\"COLUMN1\"].width = 8.5714
> columns[\"COLUMN2\"] = new GRIDCOLUMN(form.GRID1)
> columns[\"COLUMN2\"].dataLink = form.workqrderdatamodule1.empwork1.rowset.fields[\"empname\"]
> columns[\"COLUMN2\"].editorType = 1 // EntryField
> columns[\"COLUMN2\"].width = 28.5714
> columns[\"COLUMN3\"] = new GRIDCOLUMN(form.GRID1)
> columns[\"COLUMN3\"].dataLink = form.workqrderdatamodule1.empwork1.rowset.fields[\"emptime\"]
> columns[\"COLUMN3\"].editorType = 1 // EntryField
> columns[\"COLUMN3\"].width = 10.0
> columns[\"COLUMN4\"] = new GRIDCOLUMN(form.GRID1)
> columns[\"COLUMN4\"].dataLink = form.workqrderdatamodule1.employee1.rowset.fields[\"emprate\"]
> columns[\"COLUMN4\"].editorType = 1 // EntryField
> columns[\"COLUMN4\"].width = 10.0
> with (columns[\"COLUMN1\"].headingControl)
> value = \"jobNo\"
> endwith
>
> with (columns[\"COLUMN2\"].headingControl)
> value = \"empName\"
> endwith
>
> with (columns[\"COLUMN3\"].headingControl)
> value = \"empTime\"
> endwith
>
> with (columns[\"COLUMN4\"].headingControl)
> value = \"empRate\"
> endwith
>
> height = 4.0
> left = 4.0
> top = 9.0
> width = 77.0
> endwith
>
> this.TEXTJOBNO1 = new TEXT(this)
> with (this.TEXTJOBNO1)
> height = 1.0
> left = 7.0
> top = 1.0
> width = 5.7143
> wrap = false
> alignVertical = 2 // Bottom
> text = \"jobNo\"
> endwith
>
> this.TEXTJOBDATE1 = new TEXT(this)
> with (this.TEXTJOBDATE1)
> height = 1.0
> left = 25.0
> top = 1.0
> width = 7.2857
> wrap = false
> alignVertical = 2 // Bottom
> text = \"jobDate\"
> endwith
>
> this.TEXTJOBDESCR1 = new TEXT(this)
> with (this.TEXTJOBDESCR1)
> height = 1.0
> left = 7.0
> top = 4.0
> width = 8.2857
> wrap = false
> alignVertical = 2 // Bottom
> text = \"jobDescr\"
> endwith
>
>
> endclass
>
>
>
>
>
>
>
>
>
>
>
> Geoff Wass [dBVIPS] Wrote:
>
reguardless of where the empWork table is.[vbcol=seagreen]
>
|