Re: ADO Table and Datamodules...

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

Article #4521

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

#4521

From: Michael Mouer
Date: Thu, 13 Dec 2001 18:05

26 lines
1712 bytes

This works if you use SQL:

DataModuleName->ADOQueryName->SQL->Close();
DataModuleName->ADOQueryName->SQL->Clear();
DataModuleName->ADOQueryName->SQL->Add("SELECT * ");
DataModuleName->ADOQueryName->SQL->Add("FROM table");
DataModuleName->ADOQueryName->SQL->Add("WHERE column LIKE ");
DataModuleName->ADOQueryName->SQL->Add("'" + searchItem + "'");
DataModuleName->ADOQueryName->SQL->AddOpen();

"Alan S" <al.stanton@verizon.net> wrote:
>Hello,
>
>Have had trouble's putting my ADOTables inside a Datamodule.  When executing
>the program I get something like "ADOTable needs to be an updatable query".
>My programs work when just using the Form, but it gets cluttered without
>using a Datamodule.  I make sure to include Unit.hdr.  Am I doing something
>wrong ?
>
>Any help would be appreciated.
>
>Al
>
>
>

Technical Details

Message-ID: <3c18edff$1_2@dnews>

Path:

arc1-ca.pugleaf.net!archiver1.google.com!news1.google.com!sn-xit-02!supernews.com!newsfeed.direct.ca!look.ca!netnews.com!fr.clara.net!heighliner.fr.clara.net!newsfeed01.sul.t-online.de!t-online.de!dnews

References: <3c183c4e$1_2@dnews>

Show Full Headers

Complete Article Headers

X-Google-Language: ENGLISH,ASCII-7-bit
X-Google-Thread: 10698b,2e48c881728df1
X-Google-Attributes: gid10698b,public
X-Google-ArrivalTime: 2001-12-13 14:04:21 PST
From: "Michael Mouer" <michael.mouer@sherwin.com>
Sender: "Michael Mouer" <michael.mouer@sherwin.com>
Reply-To: "Michael Mouer" <michael.mouer@sherwin.com>
Subject: Re: ADO Table and Datamodules...
Newsgroups: borland.public.cppbuilder.database.ado
X-User-Info: 148.141.31.19 148.141.31.19    
References:  <3c183c4e$1_2@dnews> 
NNTP-Posting-Host: 207.105.83.65
Message-ID: <3c18edff$1_2@dnews>
Date: 13 Dec 2001 10:05:51 -0800
X-Trace: dnews 1008266751 207.105.83.65 (13 Dec 2001 10:05:51 -0800)
Lines: 27
Path: arc1-ca.pugleaf.net!archiver1.google.com!news1.google.com!sn-xit-02!supernews.com!newsfeed.direct.ca!look.ca!netnews.com!fr.clara.net!heighliner.fr.clara.net!newsfeed01.sul.t-online.de!t-online.de!dnews

Reply to Parent Message