Problem fields with blank characters in ACCESS

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

Article #5455

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

#5455

From: Carlos
Date: Wed, 09 May 2001 15:18

13 lines
1366 bytes

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: <3af95fbe_1@dnews>

Path:

arc1-ca.pugleaf.net!newsfeed.google.com!sn-xit-02!supernews.com!peer.news.opaltelecom.net!newsfeed.wirehub.nl!fr.clara.net!heighliner.fr.clara.net!newsfeed01.sul.t-online.de!t-online.de!dnews

Show Full Headers

Complete Article Headers

X-Google-Language: ENGLISH,ASCII-7-bit
X-Google-Thread: 10698b,53a23a2b78526dba,start
X-Google-Attributes: gid10698b,public
X-Google-ArrivalTime: 2001-05-09 08:55:36 PST
From: "Carlos" <shangri-la@teleline.es>
Newsgroups: borland.public.cppbuilder.database.ado
Subject: Problem fields with blank characters in ACCESS
Date: Wed, 9 May 2001 17:18:20 +0200
Lines: 16
X-Priority: 3
X-MSMail-Priority: Normal
X-Newsreader: Microsoft Outlook Express 5.00.2919.6700
X-MimeOLE: Produced By Microsoft MimeOLE V5.00.2919.6700
NNTP-Posting-Host: 193.153.220.226
Message-ID: <3af95fbe_1@dnews>
X-Trace: dnews 989421502 193.153.220.226 (9 May 2001 08:18:22 -0700)
Path: arc1-ca.pugleaf.net!newsfeed.google.com!sn-xit-02!supernews.com!peer.news.opaltelecom.net!newsfeed.wirehub.nl!fr.clara.net!heighliner.fr.clara.net!newsfeed01.sul.t-online.de!t-online.de!dnews