Data environment drag and drop

Hi,

I'm just starting to get into the DE, and I'll probably have a lot of other
dumb questions in the weeks to come.

I've setup a DE (about 10 tables), and then dropped the individual fields
into pages of a pageframe on a form. All good and easy for design. But how
do I bind the field to, for example, a subclassed textbox which is readonly
instead of the default one?

Another question. Which is the best buffermode/override property to use.
It's a sales entry system with a sales header (one-to-many on sales items
and payments tables, one-to-one on customer table), sales items (one-to-one
on stock tables), etc. I've read varying opinions, but I'm wondering what
the general consensus on Row vs Table and Pessimistic vs Optimistic
buffering is. Any ideas or articles on the subject would be appreciated.

Thanks,
Neil

John
Wed Jun 30 16:16:50 CDT 2004

In code...

thisform.MyPageFrame.MyTextBox.controlsource = "MyTable.field1"
If you have subclassed a VFP base class such as a textbox, you can access
any of the properties of that textbox with code like.
MyTextBox.visible = .t.
MyTextBox.readonly = .f.

www.universalthread.com
www.foxite.com
have many articles on row/table buffering.
John.


"Neil Waterworth" <nospam-or-nwaterworth@lineone.net> wrote in message
news:O3JZlytXEHA.3552@TK2MSFTNGP12.phx.gbl...
> Hi,
>
> I'm just starting to get into the DE, and I'll probably have a lot of
other
> dumb questions in the weeks to come.
>
> I've setup a DE (about 10 tables), and then dropped the individual fields
> into pages of a pageframe on a form. All good and easy for design. But how
> do I bind the field to, for example, a subclassed textbox which is
readonly
> instead of the default one?
>
> Another question. Which is the best buffermode/override property to use.
> It's a sales entry system with a sales header (one-to-many on sales items
> and payments tables, one-to-one on customer table), sales items
(one-to-one
> on stock tables), etc. I've read varying opinions, but I'm wondering what
> the general consensus on Row vs Table and Pessimistic vs Optimistic
> buffering is. Any ideas or articles on the subject would be appreciated.
>
> Thanks,
> Neil
>
>
>

Gerben
Wed Jun 30 16:25:53 CDT 2004

To change the class of the fields you drop from your DE, change the field
mappings in menu->tools->options->field mappings.
And IMO optimistic locking is the the way to go....

HTH,

Gerben Kessen


"Neil Waterworth" <nospam-or-nwaterworth@lineone.net> wrote in message
news:O3JZlytXEHA.3552@TK2MSFTNGP12.phx.gbl...
> Hi,
>
> I'm just starting to get into the DE, and I'll probably have a lot of
other
> dumb questions in the weeks to come.
>
> I've setup a DE (about 10 tables), and then dropped the individual fields
> into pages of a pageframe on a form. All good and easy for design. But how
> do I bind the field to, for example, a subclassed textbox which is
readonly
> instead of the default one?
>
> Another question. Which is the best buffermode/override property to use.
> It's a sales entry system with a sales header (one-to-many on sales items
> and payments tables, one-to-one on customer table), sales items
(one-to-one
> on stock tables), etc. I've read varying opinions, but I'm wondering what
> the general consensus on Row vs Table and Pessimistic vs Optimistic
> buffering is. Any ideas or articles on the subject would be appreciated.
>
> Thanks,
> Neil
>
>
>

John
Wed Jun 30 21:59:28 CDT 2004

http://msdn.microsoft.com/archive/default.asp?url=/archive/en-us/dnarfoxgen/html/msdn_buffer.asp


"Neil Waterworth" <nospam-or-nwaterworth@lineone.net> wrote in message
news:O3JZlytXEHA.3552@TK2MSFTNGP12.phx.gbl...
> Hi,
>
> I'm just starting to get into the DE, and I'll probably have a lot of
other
> dumb questions in the weeks to come.
>
> I've setup a DE (about 10 tables), and then dropped the individual fields
> into pages of a pageframe on a form. All good and easy for design. But how
> do I bind the field to, for example, a subclassed textbox which is
readonly
> instead of the default one?
>
> Another question. Which is the best buffermode/override property to use.
> It's a sales entry system with a sales header (one-to-many on sales items
> and payments tables, one-to-one on customer table), sales items
(one-to-one
> on stock tables), etc. I've read varying opinions, but I'm wondering what
> the general consensus on Row vs Table and Pessimistic vs Optimistic
> buffering is. Any ideas or articles on the subject would be appreciated.
>
> Thanks,
> Neil
>
>
>

Stefan
Thu Jul 01 06:43:21 CDT 2004

Hi Neil,

As for the Field Mapping classes in Tools/Options - they are
stored in the Windows registry:
HKCU\Software\Microsoft\VisualFoxpro\<version>\Options\
IntelliDrop\Fieldtypes
So you can modify them programmatically, say in a method called
from ProjectHook.Init() or on demand, e.g. using the Home()\
Tools\registy classes.
In the current Vfp9 Beta you can also use the new Environment
Manager features (e.g. from the Task Pane)

Optimistic vs Pessimistic buffering -
Many people use Optimistic buffering ("last update wins").
I think not so many use Pessimistic ("access denied while other
multi-user is editing"), which is difficult to implement with many
RDBMS backends (even impossible directly working with views).

Row vs. Table may depend on each particular situation, I think.
i.e. multi-row update in "child" tables requires Table buffering, while
skipping thru "parent" tables might not.


hth
-Stefan

"Neil Waterworth" <nospam-or-nwaterworth@lineone.net> schrieb
> Hi,
>
> I'm just starting to get into the DE, and I'll probably have a lot of other
> dumb questions in the weeks to come.
>
> I've setup a DE (about 10 tables), and then dropped the individual fields
> into pages of a pageframe on a form. All good and easy for design. But how
> do I bind the field to, for example, a subclassed textbox which is readonly
> instead of the default one?
>
> Another question. Which is the best buffermode/override property to use.
> It's a sales entry system with a sales header (one-to-many on sales items
> and payments tables, one-to-one on customer table), sales items (one-to-one
> on stock tables), etc. I've read varying opinions, but I'm wondering what
> the general consensus on Row vs Table and Pessimistic vs Optimistic
> buffering is. Any ideas or articles on the subject would be appreciated.
>
> Thanks,
> Neil
>
>
>

Neil
Fri Jul 02 14:59:33 CDT 2004

Thanks to everyone who replied. Very useful stuff!

Regards,
Neil

"Neil Waterworth" <nospam-or-nwaterworth@lineone.net> wrote in message
news:O3JZlytXEHA.3552@TK2MSFTNGP12.phx.gbl...
> Hi,
>
> I'm just starting to get into the DE, and I'll probably have a lot of
other
> dumb questions in the weeks to come.
>
> I've setup a DE (about 10 tables), and then dropped the individual fields
> into pages of a pageframe on a form. All good and easy for design. But how
> do I bind the field to, for example, a subclassed textbox which is
readonly
> instead of the default one?
>
> Another question. Which is the best buffermode/override property to use.
> It's a sales entry system with a sales header (one-to-many on sales items
> and payments tables, one-to-one on customer table), sales items
(one-to-one
> on stock tables), etc. I've read varying opinions, but I'm wondering what
> the general consensus on Row vs Table and Pessimistic vs Optimistic
> buffering is. Any ideas or articles on the subject would be appreciated.
>
> Thanks,
> Neil
>
>
>