Article View: borland.public.cppbuilder.database.ado
Article #4320Re: Access to field of type 'uniqueidentifier' on SQL7?
From: Baris YURTCU
Date: Fri, 08 Feb 2002 14:22
Date: Fri, 08 Feb 2002 14:22
32 lines
2214 bytes
2214 bytes
> > 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? No, not field NAME. I mentioned the field TYPE is uniqueidentifier. (for example, Field2's type is varchar. Like that, Uniqf field's type is uniqueidentifier) > > 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. I am sure connection is active. At design time, I put a DBEdit onto my form and set it's DataSource property to 'DataSource1'. Then I click it's combobox of DataField property, a list appears and all fields of myTable are there (for example Field2, Field3). But the field Uniqf is not. > > If that doesn't help let me know, I will try to throw out some more > ideas. :) > :) Thanks for your interest David. Baris.
Technical Details
Message-ID:
<3c63df83_2@dnews>Path:
arc1-ca.pugleaf.net!archiver1.google.com!news1.google.com!sn-xit-02!supernews.com!sienna.impulse.net!207.69.128.245.MISMATCH!news.atl.earthlink.net!out.nntp.be!propagator-SanJose!in.nntp.be!newsfeed01.tsnz.net!newsfeeds.ihug.co.nz!ihug.co.nz!dnewsReferences:
<3c5b4d26_2@dnews> <3C5EB03F.2000309@kalos-inc.com> <3c5fe200_1@dnews> <3C61603F.3040707@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-08 06:30:12 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> <3c5fe200_1@dnews> <3C61603F.3040707@kalos-inc.com> Subject: Re: Access to field of type 'uniqueidentifier' on SQL7? Date: Fri, 8 Feb 2002 16:22:57 +0200 Lines: 34 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.162.230 Message-ID: <3c63df83_2@dnews> X-Trace: dnews 1013178243 195.175.162.230 (8 Feb 2002 06:24:03 -0800) Path: arc1-ca.pugleaf.net!archiver1.google.com!news1.google.com!sn-xit-02!supernews.com!sienna.impulse.net!207.69.128.245.MISMATCH!news.atl.earthlink.net!out.nntp.be!propagator-SanJose!in.nntp.be!newsfeed01.tsnz.net!newsfeeds.ihug.co.nz!ihug.co.nz!dnews