Article View: borland.public.cppbuilder.database.ado
Article #4338Re: Access to field of type 'uniqueidentifier' on SQL7?
From: Peter Bernhardt
Date: Thu, 14 Feb 2002 09:41
Date: Thu, 14 Feb 2002 09:41
12 lines
1856 bytes
1856 bytes
Hi all, the datatype is unique to sql7 (and 2k) and consists of 14 binaries separated with hyphens e.g. 6F9619FF-8B86-D011-B42D-00C04FC964FF and I think the bde doesn't support it. So you have no chance to access a field with this type. The only way out I know is to create a view in sqlsvr with e.g. cast(yourguidfield as char(36)). So you can show the content of this field but not change it. Or maybe its possible if you use ado - I couldn't test it because I have only cb4 without it. HTH Peter
Technical Details
Message-ID:
<3C6B8634.5C87607F@hsl.de>Path:
arc1-ca.pugleaf.net!archiver1.google.com!news1.google.com!sn-xit-02!supernews.com!news-x2.support.nl!news-spur1.maxwell.syr.edu!news.maxwell.syr.edu!cpk-news-hub1.bbnplanet.com!news.gtei.net!news.voicenet.com!news-out.spamkiller.net!propagator-la!news-in-la.newsfeeds.com!news-in.superfeed.net!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> <3c63df83_2@dnews> <3C6AB5E4.7010701@gmx.de>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-14 02:07:23 PST Message-ID: <3C6B8634.5C87607F@hsl.de> Date: Thu, 14 Feb 2002 10:41:08 +0100 From: Peter Bernhardt <pbernhardt@hsl.de> Organization: HSL X-Mailer: Mozilla 4.78 [de]C-CCK-MCD DT (WinNT; U) X-Accept-Language: de 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> <3C61603F.3040707@kalos-inc.com> <3c63df83_2@dnews> <3C6AB5E4.7010701@gmx.de> Content-Type: text/plain; charset=us-ascii Content-Transfer-Encoding: 7bit NNTP-Posting-Host: 195.180.183.162 X-Trace: dnews 1013679668 195.180.183.162 (14 Feb 2002 01:41:08 -0800) Lines: 12 Path: arc1-ca.pugleaf.net!archiver1.google.com!news1.google.com!sn-xit-02!supernews.com!news-x2.support.nl!news-spur1.maxwell.syr.edu!news.maxwell.syr.edu!cpk-news-hub1.bbnplanet.com!news.gtei.net!news.voicenet.com!news-out.spamkiller.net!propagator-la!news-in-la.newsfeeds.com!news-in.superfeed.net!newsfeed01.tsnz.net!newsfeeds.ihug.co.nz!ihug.co.nz!dnews