|
|||||||||
|
|||||||||
| |||||||||
|
|||||||||
|
|||||||||
| |||||||||
|
|
|
| |||||||||
 |
|
|
«
Previous Thread
|
Next Thread
»
|
Thread Tools | Search this Thread | Rate Thread | Display Modes |
Dev Shed Forums Sponsor:
|
|
Stay one step ahead of the competition. Evaluate and give feedback
on some of the hottest web development tools on the market today.
Make your opinion heard! Click
Here
|
|
#1
July 22nd, 2003, 09:23 AM
|
|||
|
|||
|
Muliple Updates in Access 2000
I want to update multiple records in my soft_lic table, but it doesn't want to accept multiple records.
The Error: "At Most one record can be returned by this subquery." Query: UPDATE soft_lic SET soft_lic.used_lic = ([soft_lic].[used_lic]-1) WHERE (( [soft_lic].[recordnum]) = (SELECT [PC_Soft].[recordnum] FROM PC_Soft WHERE ([PC_Soft].[compn])= (SELECT info_add FROM info_add_pc ))) What can I do t fix this? Mike
__________________
The Rog
|
|
#2
July 22nd, 2003, 09:41 AM
|
|||
|
|||
|
Code:
UPDATE soft_lic SET soft_lic.used_lic = ([soft_lic].[used_lic]-1) WHERE (( [soft_lic].[recordnum]) in (SELECT [PC_Soft].[recordnum] FROM PC_Soft WHERE ([PC_Soft].[compn]) in (SELECT info_add FROM info_add_pc )))
|
|
| Viewing: Dev Shed Forums > Databases > Database Management > Muliple Updates in Access 2000 |
| Thread Tools | Search this Thread |
| Display Modes | Rate This Thread |
|
|
 |
|
|
Del.icio.us
Digg
Google
Spurl
Blink
Furl
Simpy
Y! MyWeb
Linear Mode
