| View previous topic :: View next topic |
| Author |
Message |
Zerex71
General User
Joined: 23 Feb 2012
Posts: 42
|
 Posted: Wed Feb 29, 2012 11:56 am Post subject: [SOLVED] Fred Toussi, can you use UPDATE in SQL Query view? |
 |
|
See subject. 
I'm getting the following error any time I try to do an UPDATE statement in the Query Design view using SQL:
SQL Status: 42581
Error code: -5581
unexpected token: UPDATE : line: 2
I'm writing simple valid UPDATE statements in the view but Base doesn't like them.
Mike
Last edited by Zerex71 on Thu Mar 01, 2012 6:57 am; edited 1 time in total |
|
| Back to top |
|
 |
probe1
Moderator
Joined: 18 Aug 2004
Posts: 2465
Location: Chonburi Thailand Asia
|
| Posted: Wed Feb 29, 2012 10:48 pm Post subject: Re: Fred Toussi, can you use UPDATE in SQL Query view? |
|
|
| Zerex71 wrote: | | in the Query Design view using SQL |
No, you can't.
Use Tools>SQL... to issue UPDATE statements.
_________________
Cheers
Winfried
My Macros
DateTime2 extension: insert date, time or timestamp, formatted to your needs |
|
| Back to top |
|
|
Zerex71
General User
Joined: 23 Feb 2012
Posts: 42
|
| Posted: Thu Mar 01, 2012 6:52 am Post subject: |
|
|
Great, thanks. That's what another person was saying as well, but I couldn't tell if it was due to a limitation of the query window (in which I can actually see the results of my SQL statements) or the database permission issue (I'm currently locked out of adding any records because my primary key is not autonumbering anymore after the migration.
Mike |
|
| Back to top |
|
|
|
