🚀 go-pugleaf

RetroBBS NetNews Server

Inspired by RockSolid Light RIP Retro Guy

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

RE: Sql Query, Update Sql, Providers.

#572
From: Clara D�az
Date: Mon, 12 Mar 2001 12:23
39 lines
2102 bytes
I have a TUpdateSQL and It doesn�t work. Do you have this situation in some
of your programs?

Onat TAKAK <otakak@turk.net> escribi� en el mensaje de noticias
98bdem$pl011@bornews.inprise.com...
> 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: <98if3g$ov18@bornews.inprise.com>
Path: arc1-ca.pugleaf.net!supernews.google.com!sn-xit-03!supernews.com!cyclone-sf.pbi.net!209.81.14.120!feeder.via.net!enews.sgi.com!news.xtra.co.nz!newsfeed01.tsnz.net!bornews.borland.com!not-for-mail
References: <96ql8l$gh13@bornews.inprise.com> <98bdem$pl011@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-12 04:34:04 PST
Path: arc1-ca.pugleaf.net!supernews.google.com!sn-xit-03!supernews.com!cyclone-sf.pbi.net!209.81.14.120!feeder.via.net!enews.sgi.com!news.xtra.co.nz!newsfeed01.tsnz.net!bornews.borland.com!not-for-mail
From: "Clara D�az" <cdiaz@fcc.es>
Newsgroups: borland.public.cppbuilder.database.multi-tier
Subject: RE: Sql Query, Update Sql, Providers.
Date: Mon, 12 Mar 2001 13:23:57 +0100
Organization: Another Netscape Collabra Server User
Lines: 41
Message-ID: <98if3g$ov18@bornews.inprise.com>
References: <96ql8l$gh13@bornews.inprise.com> <98bdem$pl011@bornews.inprise.com>
NNTP-Posting-Host: 195.235.176.18
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