Article View: borland.public.cppbuilder.database.multi-tier
Article #568Re: Sql Query, Update Sql, Providers.
From: Onat TAKAK
Date: Fri, 09 Mar 2001 20:19
Date: Fri, 09 Mar 2001 20:19
32 lines
1806 bytes
1806 bytes
Use TUpdateSQL and connectit to your query.. Clara D�az <cdiaz@fcc.es> wrote in message news:96ql8l$gh13@bornews.inprise.com... > I'm trying to put a Sql Query in the server aplication with an Update Sql. > > The Sql Query has Cached Updates = true, Request Live = true. The sql > statement is "Select * from reparacion where szdelmaq = :@szdelmaq and fecha > = :@fecha." > > The provider is pointing to the Sql Query. This provider has > ResolveToDataset = false. > > Then when I put in my client aplication a clientdataset pointing to this > provider and I do the applyupdates this messages appears: > > "Unable to resolve records. Table name not found" > " Table does not exist. El nombre de objeto 'w' no es v�lido". (the name > of the object 'w' is not valid). > > I don�t know where is the object 'w'. I'm working with C++ Builder 4 and Sql > Server 7.0. > > > >
Technical Details
Message-ID:
<98bdem$pl011@bornews.inprise.com>Path:
arc1-ca.pugleaf.net!supernews.google.com!sn-xit-02!supernews.com!isdnet!newsfeeds.belnet.be!news.belnet.be!newsfeed00.sul.t-online.de!newsfeed01.sul.t-online.de!t-online.de!bornews.borland.com!not-for-mailReferences:
<96ql8l$gh13@bornews.inprise.com>Show Full Headers
Complete Article Headers
X-Google-Language: ENGLISH,ASCII X-Google-Thread: fcd2b,563e9462028067bf X-Google-Attributes: gidfcd2b,public X-Google-ArrivalTime: 2001-03-09 12:13:45 PST Path: arc1-ca.pugleaf.net!supernews.google.com!sn-xit-02!supernews.com!isdnet!newsfeeds.belnet.be!news.belnet.be!newsfeed00.sul.t-online.de!newsfeed01.sul.t-online.de!t-online.de!bornews.borland.com!not-for-mail From: "Onat TAKAK" <otakak@turk.net> Newsgroups: borland.public.cppbuilder.database.multi-tier Subject: Re: Sql Query, Update Sql, Providers. Date: Fri, 9 Mar 2001 22:19:42 +0200 Organization: Another Netscape Collabra Server User Lines: 34 Message-ID: <98bdem$pl011@bornews.inprise.com> References: <96ql8l$gh13@bornews.inprise.com> NNTP-Posting-Host: 195.214.156.190 X-Priority: 3 X-MSMail-Priority: Normal X-Newsreader: Microsoft Outlook Express 5.00.2615.200 X-MimeOLE: Produced By Microsoft MimeOLE V5.00.2615.200