Very Computer

i have a text field (txt1) bound to a data control (data1).  data1 is
bound to table "employers".  txt1 is tied to "company".  the database
is "abc.mdb".

in a command button called "save", i have the following in the click
event:

    data1.recordset.update

thus, when i run this small program, the table is positioned at the
first record.  hence i can use the vcr buttons of the data control and
move in either "direction" of the record sequence.

if modification is made to the the txt1 field, the changes are
committed when i move to another record via the validate event of
data1.

in vb3, i can click on the save button and the validate event will
called with update action parameter.

in vb4, i get an "3426" (an action was cancelled by an associated
object) error.  i called ms tech support and was told that the error
message should have been "3020" (update called without edit nor
addnew).

why?

the "visdata" sample program in vb3 uses the update method in the
click event of the "update" button.  ie:

    data1.recordset.update

in vb4, visdata has the following:

    data1.updaterecord      '!!!!

anyone has any ideas?

thanks.

--------
paul chow

Hi Paul;

        I am having similar problems using their own examples I get
Object dosent support method or property.  I have had my app in
operation with VB3.0 for a year and a half with no problems.  I have
spent six or seven hours on the phone with them and they have no
answer.  I suggest that the data object has a bug they do not want to
committ to that.  I sent them my database (because they dident have
one other than bibilo) still no answer.  If you get any answers
please let me know, and I will do the same.

                                        MEH
                                        Senior Technical Instructor
                                        Johnson Controls Training

Quote:

>the "visdata" sample program in vb3 uses the update method in the
>click event of the "update" button.  ie:

>    data1.recordset.update

>in vb4, visdata has the following:

>    data1.updaterecord      '!!!!

>anyone has any ideas?

>thanks.

The database methods have been restructured as described in
Chapter 10, page 198 of the "Guide to Data Access Objects" in the
"Professional Features" book that came with VB.  The new structures
are superior to the old, but as far as I know, it is still suppose to
be backwards compatible.  There are some differences in the data control
that you need to account for.

My personal opinion is that the data control should not be used, with
one exception -- a read only list.  If you want your application to be
robust and polished, stay away from the data control and use DAO or if
you are developing a client/server system use RDO (Enterprise Edition).
My reasons for this are numerous, but the heaviest concern is speed and
memory.

If you continue to use the data control, read the above referenced article
for the differences between V3 and V4.

--
J. Kyle Rickett
__________________________________________________________________
Suppose you were an idiot. And suppose you were a
member of Congress.  But I repeat myself.
     -- Mark Twain
If you have Visual Basic questions, stop by my
-Ask the VB Guru- page at
        http://rampages.onramp.net/~jkyler/guru.htm

__________________________________________________________________

Quote:

>The database methods have been restructured as described in
>Chapter 10, page 198 of the "Guide to Data Access Objects" in the
>"Professional Features" book that came with VB.  The new structures
>are superior to the old, but as far as I know, it is still suppose to
>be backwards compatible.  There are some differences in the data control
>that you need to account for.

>My personal opinion is that the data control should not be used, with
>one exception -- a read only list.  If you want your application to be
>robust and polished, stay away from the data control and use DAO or if
>you are developing a client/server system use RDO (Enterprise Edition).
>My reasons for this are numerous, but the heaviest concern is speed and
>memory.

>If you continue to use the data control, read the above referenced article
>for the differences between V3 and V4.

>--
>J. Kyle Rickett
>__________________________________________________________________

kyle:

i appreciate your input wrt my problem ... a couple of questions:

[1].  using dao's as opposed to data controls will be speedier and more
memory efficient ... how much better?  my client machines are 386/486
with 8 megs of rams ... am i going to get marginally better performance
from dao's?  any paper of this subject?

[2].  bounds controls will generate an "action" for the _validate event
of the data control when changes are made.  if i'm using data objects
instead, do i have to check the .datachanged property for each of the
fields/boxes?

again, thanks for your input.

--------
paul chow