ADO field value 
Author Message
 ADO field value
If I have a datagrid that I can navigate with an ADODC control, how do I
more the values of the current record to a variable.  How do I reference the
field value?  If I reference the recordsource, the values don't change when
I goto a different record using the control.
If I use rs1.Field_0 is returns the correct value but not correct record,
but I need to use adodc1.?????
Thanks,
Brock


Fri, 22 Jun 2001 03:00:00 GMT
 ADO field value

You can access the source recordset right insid ethe ADODC.

use  adodc1.Recordset.

The bookmark is changed automatically to the selected row and you can get
the values as

adodc1.Recordset.Fields(0).Value

or

adodc.Recordset!Name, etc.
Hope this helps.

Tom Schoeneweis
Utiility Management Services
SG Tec



Fri, 22 Jun 2001 03:00:00 GMT
 
 [ 2 post ] 

 Relevant Pages 

1. Check for NULL field value without returning field value

2. Incrementing Next Field's Value Based Upon Prior Field's Value

3. adodb connection to excel: recordset.fields(i).value=null for fields with numeric value

4. Help:Editing field values of an ADO recordset returned from SQL SP

5. problem in assigning values to ado fields from normal data control

6. Count values from field in ADO Recordset

7. How to get Field Default Value and how identify Primary Key Column in SQL with ADO

8. Learning value of identity field on SQL Server 7 after ADO-based insert

9. assign null value in ado date field

10. C++ and ADO Fields [NULL Values breaks my Application]

11. deleting value from data field with ADO

12. Get Identity Field Value ADO SQL Server


 
Powered by phpBB® Forum Software