Sql Query, Update Sql, Providers.

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

Article #707

Back to borland.public.cppbuilder.database.multi-tier Previous Next

#707

From: Clara D�az
Date: Mon, 19 Feb 2001 08:25

18 lines
1593 bytes

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: <96ql8l$gh13@bornews.inprise.com>

Path:

arc1-ca.pugleaf.net!supernews.google.com!sn-xit-02!supernews.com!bignews.mediaways.net!newsfeed00.sul.t-online.de!t-online.de!newsfeeds.belnet.be!news.belnet.be!skynet.be!newsfeed01.tsnz.net!bornews.borland.com!not-for-mail

Show Full Headers

Complete Article Headers

X-Google-Language: ENGLISH,ASCII
X-Google-Thread: fcd2b,563e9462028067bf,start
X-Google-Attributes: gidfcd2b,public
X-Google-ArrivalTime: 2001-02-19 00:38:00 PST
Path: arc1-ca.pugleaf.net!supernews.google.com!sn-xit-02!supernews.com!bignews.mediaways.net!newsfeed00.sul.t-online.de!t-online.de!newsfeeds.belnet.be!news.belnet.be!skynet.be!newsfeed01.tsnz.net!bornews.borland.com!not-for-mail
From: "Clara D�az" <cdiaz@fcc.es>
Newsgroups: borland.public.cppbuilder.database.multi-tier
Subject: Sql Query, Update Sql, Providers.
Date: Mon, 19 Feb 2001 09:25:26 +0100
Organization: Another Netscape Collabra Server User
Lines: 22
Message-ID: <96ql8l$gh13@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