Re: problem updating from local view

Tech-Archive recommends: Repair Windows Errors & Optimize Windows Performance

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: 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: Set statusbar to show section via VBA
    ... This property is no longer supported in Microsoft Word Visual Basic for Applications. ... So you can stop banging your head against the wall. ...
    (microsoft.public.word.pagelayout)
  • 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)