Please find below the requested turnkey.
The turnkey uses the fish table in dbasesamples database,
but before you test the code below you should set the
default for the 'Length CM' field to 0.
This bug is only present when you set the cacheUpdates to
true. Whilst testing this code, I also noticed the 'ID'
field, which is an autoincrement field, shows zero when
cacheupdate is set to true and empty field when set to
false.
Removing the "cacheUpdates = true" line will allow default
values.
I hope the info amd turnkey are sufficient for your test.
Mark.i
**** Please copy/paste code below ****
** END HEADER -- do not remove this line
//
// Generated on 22/02/2004
//
class fishdmDATAMODULE of DATAMODULE
with (this)
left = -1.0
top = -1.0
endwith
this.DBASESAMPLES1 = new DATABASE()
this.DBASESAMPLES1.parent = this
with (this.DBASESAMPLES1)
left = 19.0
top = 135.0
cacheUpdates = true
databaseName = "dBASESamples"
active = true
endwith
this.FISH1 = new QUERY()
this.FISH1.parent = this
with (this.FISH1)
left = 294.0
top = 89.0
width = 114.0
height = 127.0
database = form.dbasesamples1
sql = 'Select * from "fish"'
active = true
endwith
endclass