Linker IT Software
Google
Web www.oraxcel.com
menubar-top-links menubar-top-rechts
Home Help Search Login
Welcome, Guest. Please Login.
SQL*XL: Database to Excel bridge litLIB: Excel power functions pack ExcelLock: Locking and securing your valuable Excel spreadsheets encOffice: Protect your Excel file easy and safe encOffice: Protect your Excel file easy and safe
Pages: 1
sorry the current record set is not updateable (Read 4728 times)
marwan
YaBB Newbies
*


I Love SQL*XL

Posts: 1
sorry the current record set is not updateable
26.03.07 at 08:03:19
 
Hi,
 
I am using the standard version of SQL*XL version 4.1.13. When I run a simple query everything works fine, but when I run a more complex query I get the above error whenever I try to update a record.
 
I have all needed privileges, I am not selecting from a view and the query works fine without any errors. What could be the problem?
Back to top
 
 
  IP Logged
Gerrit-Jan Linker
YaBB Administrator
*****




Posts: 75
Re: sorry the current record set is not updateable
Reply #1 - 26.03.07 at 13:12:36
 
Not all select statements can be updated. You can research this yourself by looking at the Oracle documentation for updatable views.  
 
In general if you do a neat join query you should get an updatable view/recordset.  
 
A recordset will not be updatable when you have make computations. E.g. select sysdate - birthdate from person will not be updatable.
Back to top
 
 

Gerrit-Jan Linker
Linker IT Software
Email WWW Gerrit-Jan Linker   IP Logged
Pages: 1