please dont rip this site

Field Object

A Field object represents a column of data with a common data type.


Collections

Properties

Properties

ActualSize, Attributes, DefinedSize, Name, NumericScale, OriginalValue, Precision, Type, UnderlyingValue, Value

Methods

AppendChunk, GetChunk

Remarks

A Recordset object has a Fields collection made up of Field objects. Each Field object corresponds to a column in the Recordset. You use the Value property of Field objects to set or return data for the current record. Depending on the functionality the provider exposes, some collections, methods, or properties of a Field object may not be available.

With the collections, methods, and properties of a Field object, you can do the following:

· Return the name of a field with the Name property.

· View or change the data in a Recordset with the Value property.

· Return the basic characteristics of a field with the Type, Precision, and NumericScale properties.

· Return the declared size of a field with the DefinedSize property.

· Return the actual size of the data in a given field with the ActualSize property.

· Determine what types of functionality are supported for a given field with the Attributes property and Properties collection.

· Manipulate the values of fields containing long binary or character data with the AppendChunk and GetChunk methods.

· Resolve discrepancies in field values during batch updating with the OriginalValue and UnderlyingValue properties.

To refer to a Field object in a collection by its ordinal number or by its Name property setting, use any of the following syntax forms:

recordset.Fields.Item(0)
recordset.Fields.Item("name")
recordset.Fields(0)
recordset.Fields("name")
recordset(0)
recordset("name")
recordset![name]

See Also

Fields, Item, Recordset

See also:


file: /Techref/language/asp/comp/dadobj01_3.htm, 4KB, , updated: 1996/11/21 18:01, local time: 2022/1/25 21:28,
TOP NEW HELP FIND: 
52.203.18.65:LOG IN

 ©2022 These pages are served without commercial sponsorship. (No popup ads, etc...).Bandwidth abuse increases hosting cost forcing sponsorship or shutdown. This server aggressively defends against automated copying for any reason including offline viewing, duplication, etc... Please respect this requirement and DO NOT RIP THIS SITE. Questions?
Please DO link to this page! Digg it! / MAKE!

<A HREF="http://www.piclist.com/techref/language/asp/comp/dadobj01_3.htm"> Field Object (ADO)</A>

After you find an appropriate page, you are invited to your to this massmind site! (posts will be visible only to you before review) Just type a nice message (short messages are blocked as spam) in the box and press the Post button. (HTML welcomed, but not the <A tag: Instead, use the link box to link to another page. A tutorial is available Members can login to post directly, become page editors, and be credited for their posts.


Link? Put it here: 
if you want a response, please enter your email address: 
Attn spammers: All posts are reviewed before being made visible to anyone other than the poster.
Did you find what you needed?

  PICList 2022 contributors:
o List host: MIT, Site host massmind.org, Top posters @20220125
* Page Editors: James Newton, David Cary, and YOU!
* Roman Black of Black Robotics donates from sales of Linistep stepper controller kits.
* Ashley Roll of Digital Nemesis donates from sales of RCL-1 RS232 to TTL converters.
* Monthly Subscribers: Gregg Rew. on-going support is MOST appreciated!
* Contributors: Richard Seriani, Sr.
 

Welcome to www.piclist.com!

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

  .