🚀 go-pugleaf

RetroBBS NetNews Server

Inspired by RockSolid Light RIP Retro Guy

Article View: borland.public.cppbuilder.database.multi-tier
Article #568

Re: Sql Query, Update Sql, Providers.

#568
From: Onat TAKAK
Date: Fri, 09 Mar 2001 20:19
32 lines
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-mail
References: <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