Re: Access to field of type 'uniqueidentifier' on SQL7?

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

Article #4314

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

#4314

From: David Barnes
Date: Wed, 06 Feb 2002 16:56

28 lines
2225 bytes

> I set Dataset property of DataSource1 to "Query1" and SQL property of Query1
> to "SELECT * FROM dbo.myTable". Is * (star) not enough to retrieve all
> columns?


   Generally, Yes, using a * to select everything is ok. I like to 
identify all fields in my select statements. Probably abit of a personal 
choice, but it does have advantages.


> I also tried "SELECT Uniqf, Field2, Field3 FROM dbo.myTable". But the result
> is same.


I also noticed that in your first post you had:

   Edit1->Text=DataModule1->DataSource1->DataSet->FieldValues["Uniqf"];

but you mentioned the field name is UniqueIdentifier, is that correct?

Another suggestion I would make is to be sure your connection is 
becomming active. If it is not then you would also get the Field Not 
Found error.

If that doesn't help let me know, I will try to throw out some more 
ideas. :)

David Barnes

Technical Details

Message-ID: <3C61603F.3040707@kalos-inc.com>

Path:

arc1-ca.pugleaf.net!archiver1.google.com!news1.google.com!sn-xit-02!supernews.com!news-x2.support.nl!newsgate.cistron.nl!news.tele.dk!small.news.tele.dk!194.213.69.151!news.algonet.se!algonet!newsfeed.rt.ru!newsfeed2.kddnet.ad.jp!news-out.spamkiller.net!propagator-maxim!news-in.spamkiller.net!news02.tsnz.net!newsfeed01.tsnz.net!newsfeeds.ihug.co.nz!ihug.co.nz!dnews

References: <3c5b4d26_2@dnews> <3C5EB03F.2000309@kalos-inc.com> <3c5fe200_1@dnews>

Show Full Headers

Complete Article Headers

X-Google-Language: ENGLISH,ASCII-7-bit
X-Google-Thread: fc5f9,63e18f51711dcbf
X-Google-Attributes: gidfc5f9,public
X-Google-Thread: 10698b,63e18f51711dcbf
X-Google-Attributes: gid10698b,public
X-Google-ArrivalTime: 2002-02-06 09:03:11 PST
Message-ID: <3C61603F.3040707@kalos-inc.com>
Date: Wed, 06 Feb 2002 10:56:31 -0600
From: David Barnes <david@kalos-inc.com>
User-Agent: Mozilla/5.0 (Windows; U; WinNT4.0; en-US; rv:0.9.4) Gecko/20011019 Netscape6/6.2
X-Accept-Language: en-us
MIME-Version: 1.0
Newsgroups: borland.public.cppbuilder.database.ado,borland.public.cppbuilder.database.sqlservers
Subject: Re: Access to field of type 'uniqueidentifier' on SQL7?
References: <3c5b4d26_2@dnews> <3C5EB03F.2000309@kalos-inc.com> <3c5fe200_1@dnews>
Content-Type: text/plain; charset=us-ascii; format=flowed
Content-Transfer-Encoding: 7bit
NNTP-Posting-Host: 65.69.231.139
X-Trace: dnews 1013014564 65.69.231.139 (6 Feb 2002 08:56:04 -0800)
Lines: 29
Path: arc1-ca.pugleaf.net!archiver1.google.com!news1.google.com!sn-xit-02!supernews.com!news-x2.support.nl!newsgate.cistron.nl!news.tele.dk!small.news.tele.dk!194.213.69.151!news.algonet.se!algonet!newsfeed.rt.ru!newsfeed2.kddnet.ad.jp!news-out.spamkiller.net!propagator-maxim!news-in.spamkiller.net!news02.tsnz.net!newsfeed01.tsnz.net!newsfeeds.ihug.co.nz!ihug.co.nz!dnews

Reply to Parent Message