CDS, Query and Access

Hello to all,
I have the following configuration:

CDS --> Provider --> TADOQuery
with db Access.
Through a DataSource I visualize the data on one DBGrid.
I have given the possibility to the customer to insert,
to modify, to cancel the data directly from the grid,
using methods POST and DELETE of the CDS.
But problems are several:

1. to the ApplyUpdate if there is an error of the type:
Duplicate Primary key, Relationship record etc etc...
comes to me then communicated the error and the program is not resumed,

and must be only reset from the IDE (Run --> Program Reset).

2. in modification many times give the error to me: "record not
found...."
even if on the provider I have set up like method of Update =
upWhereKeyOnly
and to the creation of the several one fields key
ProviderFlags = [pfInUpdate, pfInKey]

Someone gives one hand to me?

Thanks in advance
Rino

p.s sorry for my English

.

Relevant Pages

  • Re: Can I reset a password or remove a username?
    ... membership provider or else you have to know the existing password or the ... Anyway, I think I can replace the default provider as shown below, but I ... If you, as an admin, need to do this, Code against the Membership objects. ... have already created a fairly simple admin page to reset a user's ...
    (microsoft.public.dotnet.framework.aspnet)
  • Re: goofy global.asa
    ... Application.Lock 'Lock App while you reset ... That will assure you that even if the variables are "lost", ... provider has misconfigured, your variables will be available for your use ... > To solve the problem i delete from server my global.asa and upload new one ...
    (microsoft.public.dotnet.framework.aspnet)
  • Re: blackberry
    ... The only one who can retrieve it or reset it is your provider, ... Videotron. ...
    (microsoft.public.windows.vista.mail)
  • Re: My Acct. got hacked
    ... > someone broke into my e-mail account is there anyway to ... contact your provider and report it, have them reset your password to ...
    (microsoft.public.security)