Wrox Programmer Forums
|
ASP.NET 1.0 and 1.1 Basics ASP.NET discussion for users new to coding in ASP.NET 1.0 or 1.1. NOT for the older "classic" ASP 3 or the newer ASP.NET 2.0.
Welcome to the p2p.wrox.com Forums.

You are currently viewing the ASP.NET 1.0 and 1.1 Basics section of the Wrox Programmer to Programmer discussions. This is a community of software programmers and website developers including Wrox book authors and readers. New member registration was closed in 2019. New posts were shut off and the site was archived into this static format as of October 1, 2020. If you require technical support for a Wrox book please contact http://hub.wiley.com
 
Old July 2nd, 2004, 04:40 AM
Registered User
  
Join Date: Jul 2004
Posts: 1
Thanks: 0
Thanked 0 Times in 0 Posts
Default You must use an updateable query
I am facing a problem with "insert" operation(C#) in a webform. While using command object with "ExecuteNonQuery" method,I have encounterd with an error"You must use an updateable query". If someone knows about it please tell me how to correct it.
 
Old July 2nd, 2004, 04:58 AM
Friend of Wrox
  
Join Date: Sep 2003
Posts: 121
Thanks: 0
Thanked 0 Times in 0 Posts
Default
Can you tell us what the SQL of your query is ?
99% of my SQL problems are because of incorrect syntax.
 
Old July 2nd, 2004, 06:04 AM
planoie's Avatar
Friend of Wrox
  
Join Date: Aug 2003
Posts: 5,407
Thanks: 0
Thanked 16 Times in 16 Posts
Default
Or perhaps this is an Access permissions issue. Usually this errors comes from the Access database not being writable because of file system settings or web site permissions. There are numerous threads on this forum dealing with that. Do a search on it and you should find your answer.
 
Old July 2nd, 2004, 06:59 AM
Imar's Avatar
Wrox Author
  
Join Date: Jun 2003
Posts: 17,089
Thanks: 80
Thanked 1,576 Times in 1,552 Posts
Default
Check out this FAQ for more info:

http://Imar.Spaanjaars.Com/QuickDocID.aspx?QUICKDOC=263

Cheers,

Imar
---------------------------------------
Imar Spaanjaars
Everyone is unique, except for me.





Similar Threads
Thread Thread Starter Forum Replies Last Post
When is a query updateable? donevco Access 2 January 31st, 2007 11:56 AM
updateable query dilionyi Visual Basic 2005 Basics 7 August 16th, 2006 11:42 AM
help me ! can't updateable query ! 123123 Classic ASP Databases 1 April 18th, 2005 08:54 AM
Operation must use an updateable query chaos2003 Classic ASP Databases 4 August 22nd, 2003 03:04 PM
Updateable Query Error hoffmann Classic ASP Databases 2 August 13th, 2003 09:54 PM




Contact Us - Wrox - Privacy Statement - Top

Powered by vBulletin®
Copyright ©2000 - 2020, Jelsoft Enterprises Ltd.
Copyright (c) 2020 John Wiley & Sons, Inc.