Setting properties on columns using Variants

Article View: borland.public.cppbuilder.database.ado

Article #523

Back to borland.public.cppbuilder.database.ado Previous Next

#523

From: Russell Allen
Date: Thu, 01 Sep 2005 16:44

19 lines
1434 bytes

Hi guys,

I'm wondering how I'd be able to set a property on a table column using variants?

My existing code is as follows:

  Variant Cols = NewTable.OlePropertyGet("Columns");
  Variant column = CreateOleObject("ADOX.Column");
  column.OlePropertySet("Name", "ID");
  column,OlePropertySet("Type", adSmallInt);
  Cols.OleProcedure("Append", column);

I need a line in there that does the equivelant of:
  column.OlePropertySet("Properties('autonumber')", true)

Any help much appreciated!  Thanks all,

Russ

Technical Details

Message-ID: <43172fe5$1@newsgroups.borland.com>

Path:

arc1-ca.pugleaf.net!g2news1.google.com!news3.google.com!news.glorb.com!fr.ip.ndsoftware.net!newsfeed.freenet.de!newsfeed.inode.at!news-out.newsgroups.com!propagator2-sterling.newsfeeds.com!in.nntp.be!caladan.landsraad.net!newsgroups.borland.com!not-for-mail

Show Full Headers

Complete Article Headers

X-Google-Thread: 10698b,c8c71d799de9a629,start
X-Google-Attributes: gid10698b,public
X-Google-Language: ENGLISH,ASCII-7-bit
From: "Russell Allen" <russell.allen@bt.com>
Sender: "Russell Allen" <russell.allen@bt.com>
Reply-To: "Russell Allen" <russell.allen@bt.com>
Subject: Setting properties on columns using Variants
Newsgroups: borland.public.cppbuilder.database.ado
X-User-Info: 193.113.57.163     
X-Forwarded-For: 10.229.16.56
NNTP-Posting-Host: 207.105.83.66
Message-ID: <43172fe5$1@newsgroups.borland.com>
Date: 1 Sep 2005 09:44:21 -0700
X-Trace: newsgroups.borland.com 1125593061 207.105.83.66 (1 Sep 2005 09:44:21 -0700)
Lines: 19
Path: arc1-ca.pugleaf.net!g2news1.google.com!news3.google.com!news.glorb.com!fr.ip.ndsoftware.net!newsfeed.freenet.de!newsfeed.inode.at!news-out.newsgroups.com!propagator2-sterling.newsfeeds.com!in.nntp.be!caladan.landsraad.net!newsgroups.borland.com!not-for-mail