Re: problem updating from local view

Gene,

Thank you. That was it. I was really banging my head against the wall on
this one.

Dave

"Gene Wirchenko" <genew@xxxxxxxx> wrote in message
news:thktr29nehmmcp56murglsbr6qn9uie4nu@xxxxxxxxxx
Dave Tiffany <dtiffany@xxxxxxxxxx> wrote:

When I use the view below I can update the character field and update
the underlying table without a problem. However I have a problem
modifying either of the date fields. I can append a blank record to
the view and update that, but changes to an existing record result in
"Syntax Error". Not a very helpful message.

Both "from" and "to" are reserved words. Try different column
names.

[snip]

Sincerely,

Gene Wirchenko

Computerese Irregular Verb Conjugation:
I have preferences.
You have biases.
He/She has prejudices.


.

Relevant Pages

  • Re: so i finally hear the new common....
    ... Banging your head against a wall ... Banging your head against a strong wind ... The sound of the bed knocking against the wall while your grandparents are having sex in the next room ... You know how when you record over a tape, how in the silent parts of the new recording you can faintly hear the beat of the old recording? ...
    (rec.music.hip-hop)
  • Re: Night Smoke Monday 11-5-07
    ... Albarino white wine while struggling (banging my head against the wall) ... with some schoolwork. ...
    (alt.smokers.pipes)
  • Re: Night Smoke Monday 11-5-07
    ... Sipping on some Albarino white wine while struggling (banging my head against the wall) with some schoolwork. ...
    (alt.smokers.pipes)
  • Re: Mapped drives and FSO
    ... I forgot I turned off netbios a while ago, been banging my head up against ... the wall ever since. ... > Yes but keep in mind that your web app doesn't run under the same context. ...
    (microsoft.public.inetserver.asp.general)
  • Re: All Odd Numbers are Prime!!!!!!!!!!!!!!!......... ...
    ... arguing with him is like banging your head against a brick ... wall, ...
    (sci.physics.relativity)
Quantcast