<?xml version="1.0" encoding="utf-8"?>
<!-- Copyright (c) 2007-2010 Nokia Corporation and/or its subsidiary(-ies) All rights reserved. -->
<!-- This component and the accompanying materials are made available under the terms of the License 
"Eclipse Public License v1.0" which accompanies this distribution, 
and is available at the URL "http://www.eclipse.org/legal/epl-v10.html". -->
<!-- Initial Contributors:
    Nokia Corporation - initial contribution.
Contributors: 
-->
<!DOCTYPE concept
  PUBLIC "-//OASIS//DTD DITA Concept//EN" "concept.dtd">
<concept xml:lang="en" id="GUID-580471E3-7DFD-5325-A8B9-B3E7FABF872D"><title>Using TDbColSetIter</title><prolog><metadata><keywords/></metadata></prolog><conbody><section><title>Using the iterator</title> <p><codeph>TDbColSetIter</codeph> provides a useful way to iterate over the contents of a column set. Given a <codeph>CDbColSet* set</codeph>, we can count the number of nullable columns like this:</p> <codeblock id="GUID-14CED4FF-C2A4-54E4-B089-A97EA9503AE6" xml:space="preserve">TInt nullable=0;
for (TDbColSetIter iter(*set);iter;++iter)
    {
    if ((iter-&gt;iAttributes&amp;TDbCol::ENotNull)==0)
        ++nullable;
    }</codeblock> </section> </conbody></concept>