Sql Query, Update Sql, Providers.

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

3 messages

[T] Back to Threads [V] Tree View [G] Group Articles

3 total messages Started by Clara D�az Mon, 19 Feb 2001 08:25

#707

Author: 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.

Re: Sql Query, Update Sql, Providers.

#568

Author: 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.
>
>
>
>

RE: Sql Query, Update Sql, Providers.

#572

Author: 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.
> >
> >
> >
> >
>
>

Thread Navigation

This is a paginated view of messages in the thread with full content displayed inline.

Messages are displayed in chronological order, with the original post highlighted in green.

Use pagination controls to navigate through all messages in large threads.

Back to All Threads