VB 6.0/ADO Data Control ??

Hi..

I'm new to VB 6.0.  Haven't programmed in years.  Last time was with VB 4.0; so its been awhile.  I have come to the ADO Data Control.  I have a form that loads the data into the ADO Data Control with an SQL statement (selecting only certain records from my table).  I bind a datagrid to the ADODC and have the fields displayed in the datagrid.  The user can add new records, but only if all cells are filled.  If any cell is left unfilled, the record should not be saved.  However, when I try to cancel the update...I get a program message that says "Action is Cancelled"...I don't want that message to appear.  I used vbDataErrContine, and that suppresses the program's message, but the record is saved.

I used the form designer to create a form and it set up a Select Case under the ADODC's WillChangeRecord event.  Under "adRsnUpdate" I check to see if the cells are filled in and if not, and I cancel it, it tells me "Multiple Step Operation Generated Errors. Check each status value"...

I've check the constants out for the ADO controls and they are briefly defined in MSDN, but no examples to show how they are used.

Are there sample programs in VB 6.0 using these events with the ADODC that can show me how to do this   Any assistance would be much appreciated.

JP

Answer this question

VB 6.0/ADO Data Control ??

VB 6.0/ADO Data Control ??

Answer this question