stymied by ADO

[jimenright]

i have a vc++ gui interface to an MSAccess table. Everything works fine -
i can navigate (first, prev, next, last) and save, insert and delete records.

now the problem occurs: i changed the attributes of the MSAccess table
so now there is a primary key that can not be null and attempts to
add a new record fail/throw exception with complaints about trying to add a record with a null value.

the table of postal rates has the follwoing fields:

Use
RateDate
InitialRate
InitialWeight
InrementalRate
IncrementalWeight

with RateDate having been elevated to primary key status.

the code to transfer data from the dialog to the table is as follows (with
a note where the exception occurs):


AccessDBManager.vName = "Use";
if ( ((CButton*)GetDlgItem(IDC_CHK_USE))->GetCheck() == 0 ){
AccessDBManager.vValue = "0";
}
else{
AccessDBManager.vValue = "-1";
}
AccessDBManager.RecordsetPtr->Update( // exception thrown here!
AccessDBManager.vName,
AccessDBManager.vValue
);

AccessDBManager.vName = "RateDate";
GetDlgItem(IDC_EDT_RATEDATE)->GetWindowText( s );
AccessDBManager.vValue = s;
AccessDBManager.RecordsetPtr->Update(
AccessDBManager.vName,
AccessDBManager.vValue
);

AccessDBManager.vName = "RateInit";
GetDlgItem(IDC_EDT_RATEINIT)->GetWindowText( s );
AccessDBManager.vValue = s;
AccessDBManager.RecordsetPtr->Update(
AccessDBManager.vName,
AccessDBManager.vValue
);

AccessDBManager.vName = "WeightInit";
GetDlgItem(IDC_EDT_WEIGHTINIT)->GetWindowText( s );
AccessDBManager.vValue = s;
AccessDBManager.RecordsetPtr->Update(
AccessDBManager.vName,
AccessDBManager.vValue
);

AccessDBManager.vName = "RateIncr";
GetDlgItem(IDC_EDT_RATEINCR)->GetWindowText( s );
AccessDBManager.vValue = s;
AccessDBManager.RecordsetPtr->Update(
AccessDBManager.vName,
AccessDBManager.vValue
);

AccessDBManager.vName = "WeightIncr";
GetDlgItem(IDC_EDT_WEIGHTINCR)->GetWindowText( s );
AccessDBManager.vValue = s;
AccessDBManager.RecordsetPtr->Update(
AccessDBManager.vName,
AccessDBManager.vValue
);

the problem seems to me that upon trying to update the "Use" field MSAcess
now notes that the "RateDate" field is empty. Changing the order of
the updates is not an acceptable solution since there can be more than one
primary key, in general, and the problem would still occur.

what is the trick to accomplish this?

thanks in advance.

[sicarie]

i have a vc++ gui interface to an MSAccess table. Everything works fine -
i can navigate (first, prev, next, last) and save, insert and delete records.

now the problem occurs: i changed the attributes of the MSAccess table
so now there is a primary key that can not be null and attempts to
add a new record fail/throw exception with complaints about trying to add a record with a null value.

the table of postal rates has the follwoing fields:

Use
RateDate
InitialRate
InitialWeight
InrementalRate
IncrementalWeight

with RateDate having been elevated to primary key status.

the code to transfer data from the dialog to the table is as follows (with
a note where the exception occurs):


AccessDBManager.vName = "Use";
if ( ((CButton*)GetDlgItem(IDC_CHK_USE))->GetCheck() == 0 ){
AccessDBManager.vValue = "0";
}
else{
AccessDBManager.vValue = "-1";
}
AccessDBManager.RecordsetPtr->Update( // exception thrown here!
AccessDBManager.vName,
AccessDBManager.vValue
);

AccessDBManager.vName = "RateDate";
GetDlgItem(IDC_EDT_RATEDATE)->GetWindowText( s );
AccessDBManager.vValue = s;
AccessDBManager.RecordsetPtr->Update(
AccessDBManager.vName,
AccessDBManager.vValue
);

AccessDBManager.vName = "RateInit";
GetDlgItem(IDC_EDT_RATEINIT)->GetWindowText( s );
AccessDBManager.vValue = s;
AccessDBManager.RecordsetPtr->Update(
AccessDBManager.vName,
AccessDBManager.vValue
);

AccessDBManager.vName = "WeightInit";
GetDlgItem(IDC_EDT_WEIGHTINIT)->GetWindowText( s );
AccessDBManager.vValue = s;
AccessDBManager.RecordsetPtr->Update(
AccessDBManager.vName,
AccessDBManager.vValue
);

AccessDBManager.vName = "RateIncr";
GetDlgItem(IDC_EDT_RATEINCR)->GetWindowText( s );
AccessDBManager.vValue = s;
AccessDBManager.RecordsetPtr->Update(
AccessDBManager.vName,
AccessDBManager.vValue
);

AccessDBManager.vName = "WeightIncr";
GetDlgItem(IDC_EDT_WEIGHTINCR)->GetWindowText( s );
AccessDBManager.vValue = s;
AccessDBManager.RecordsetPtr->Update(
AccessDBManager.vName,
AccessDBManager.vValue
);

the problem seems to me that upon trying to update the "Use" field MSAcess
now notes that the "RateDate" field is empty. Changing the order of
the updates is not an acceptable solution since there can be more than one
primary key, in general, and the problem would still occur.

what is the trick to accomplish this?

thanks in advance.

::bumping the thread in hope of getting someone's attention who has worked with Access and C++ before::

[willakawill]

Would you please explain in a little more detail why you can't update RateDate before you update Use?