Re: Beginning question for Access OLEDBUpdate command

Cor,

After setting up a connection, I added a data adapter from the Data tab of
the Toolbox and a wizard started.

Dave

"Cor Ligthert [MVP]" <notmyfirstname@xxxxxxxxx> wrote in message
news:OdZdPVzCHHA.4952@xxxxxxxxxxxxxxxxxxxxxxx
Dave,

With what wizard did you made this, I miss the select command that is in
my idea standard in the generated dataadapter commands.

Cor

"Dave" <dls5678@xxxxxxxxxxxxxxxx> schreef in bericht
news:ujMXFdyCHHA.204@xxxxxxxxxxxxxxxxxxxxxxx
I used the wizard in VB.NET 2003 to generate a data adapter and it created
the following update command. It seems like the WHERE clause would never
evaluate to true? Am I reading this wrong?

The member_ID is the key for the table but it looks like the 2 statements
checking the address_1 and address_2 values would only be true if no
changes were made.

Me.OleDbUpdateCommand1.CommandText = "UPDATE Member_Listing SET address_1
= ?, address_2 = ? WHERE (member_ID = ?) AND (address_1 = ? OR ? IS NULL
AND address_1 IS NULL) AND (address_2 = ? OR ? IS NULL AND address_2 IS
NULL)

Thanks for your help.

Dave





.

Relevant Pages

  • Re: copy last record
    ... In the form design view, there is a command button wizard that will do that. ... Click the Command Button tool on the toolbox and click in the form. ...
    (microsoft.public.access.formscoding)
  • Re: Beginning question for Access OLEDBUpdate command
    ... After setting up a connection, I added a data adapter from the Data tab of ... the Toolbox and a wizard started. ... created the following update command. ...
    (microsoft.public.dotnet.framework.adonet)
  • Re: Simple question
    ... When I click the command button icon in the Toolbox and make the size ... wizard will not show up. ...
    (microsoft.public.access.forms)
  • Simple question
    ... When I click the command button icon in the Toolbox and make the size ... But now when I create a command button the pop up wizard ...
    (microsoft.public.access.forms)
  • RE: Help Needed - Linking a User Selected Option to Another Form
    ... command buttons to pop up other forms. ... sure the "Wizard" button is selected in te Toolbox, ... The Wiz will walk you through it) ...
    (microsoft.public.access.forms)