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

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

Article #4302

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

#4302

From: Baris YURTCU
Date: Tue, 05 Feb 2002 13:44

27 lines
1761 bytes

Hi David,

> How are you filling your DataSet?

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?

> For example, if you are doing a Select * from ABC you might
> not have the field name you want

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

>or if you have two same fields named
> the same from two tables that are being included one would be given a
> temp name (ex. two tables that both have an ID field),

No, my field names do not conflict.

> David Barnes
>

Thank you very much for your response, David.

And still I need help on this subject.
Baris.

Technical Details

Message-ID: <3c5fe200_1@dnews>

Path:

arc1-ca.pugleaf.net!archiver1.google.com!news1.google.com!sn-xit-02!supernews.com!news-x2.support.nl!skynet.be!skynet.be!newsfeed01.tsnz.net!newsfeeds.ihug.co.nz!ihug.co.nz!dnews

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

Show Full Headers

Complete Article Headers

X-Google-Language: ENGLISH,ASCII-7-bit
X-Google-Thread: 10698b,63e18f51711dcbf
X-Google-Attributes: gid10698b,public
X-Google-Thread: fc5f9,63e18f51711dcbf
X-Google-Attributes: gidfc5f9,public
X-Google-ArrivalTime: 2002-02-05 05:59:47 PST
From: "Baris YURTCU" <badidi@hotmail.com>
Newsgroups: borland.public.cppbuilder.database.ado,borland.public.cppbuilder.database.sqlservers
References: <3c5b4d26_2@dnews> <3C5EB03F.2000309@kalos-inc.com>
Subject: Re: Access to field of type 'uniqueidentifier' on SQL7?
Date: Tue, 5 Feb 2002 15:44:30 +0200
Lines: 29
X-Priority: 3
X-MSMail-Priority: Normal
X-Newsreader: Microsoft Outlook Express 5.50.4522.1200
X-MimeOLE: Produced By Microsoft MimeOLE V5.50.4522.1200
NNTP-Posting-Host: 195.175.127.93
Message-ID: <3c5fe200_1@dnews>
X-Trace: dnews 1012916736 195.175.127.93 (5 Feb 2002 05:45:36 -0800)
Path: arc1-ca.pugleaf.net!archiver1.google.com!news1.google.com!sn-xit-02!supernews.com!news-x2.support.nl!skynet.be!skynet.be!newsfeed01.tsnz.net!newsfeeds.ihug.co.nz!ihug.co.nz!dnews

Reply to Parent Message