Re: Problem fields with blank characters in ACCESS

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

Article #5381

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

#5381

From: Rick Golden
Date: Fri, 18 May 2001 13:03

25 lines
1709 bytes

I'm not sure it is correct..

but i think the field in access must have the Accept empty string to true...

hope it helps
Carlos <shangri-la@teleline.es> wrote in message news:3af95fbe_1@dnews...
> Hi, When i try to link a master table with a a child table in MS ACCESS
and
> when the fields used to link the tables contains blank characters i get an
> error.
>
> The only way to solve this that i find was use a TADODataSet component
> instead a TADOTable and put the CommandType property as cmdText and use a
> SELECT query at CommandText to translate the blank characters of the
fields
> in for instance "_" character.
>
> Anyone knows other method to solve this question and without using a
SELECT
> query ?
>
> Thanks.
>
>
>

Technical Details

Message-ID: <3b051d61_1@dnews>

Path:

arc1-ca.pugleaf.net!archiver1.sj.google.com!newsfeed.google.com!sn-xit-02!supernews.com!nntp-relay.ihug.net!ihug.co.nz!newsfeed00.sul.t-online.de!newsfeed01.sul.t-online.de!t-online.de!dnews

References: <3af95fbe_1@dnews>

Show Full Headers

Complete Article Headers

X-Google-Language: ENGLISH,ASCII-7-bit
X-Google-Thread: 10698b,53a23a2b78526dba
X-Google-Attributes: gid10698b,public
X-Google-ArrivalTime: 2001-05-18 06:10:22 PST
Reply-To: "Rick Golden" <GoldenRick@hotmail.com>
From: "Rick Golden" <GoldenRick@hotmail.com>
Newsgroups: borland.public.cppbuilder.database.ado
References: <3af95fbe_1@dnews>
Subject: Re: Problem fields with blank characters in ACCESS
Date: Fri, 18 May 2001 09:03:22 -0400
Lines: 27
Organization: Gold
X-Priority: 3
X-MSMail-Priority: Normal
X-Newsreader: Microsoft Outlook Express 5.00.2314.1300
X-MimeOLE: Produced By Microsoft MimeOLE V5.00.2314.1300
NNTP-Posting-Host: 198.168.250.105
Message-ID: <3b051d61_1@dnews>
X-Trace: dnews 990190945 198.168.250.105 (18 May 2001 06:02:25 -0700)
Path: arc1-ca.pugleaf.net!archiver1.sj.google.com!newsfeed.google.com!sn-xit-02!supernews.com!nntp-relay.ihug.net!ihug.co.nz!newsfeed00.sul.t-online.de!newsfeed01.sul.t-online.de!t-online.de!dnews

Reply to Parent Message