|
| |
|
|
stu
Posts: 142
From: doylestown,pa
Status: offline
 |
Transition to Expression Web issue - 6/2/2009 11:18:46
I am going thru the transition from fp2003 to EW 2.0 and am having a problem getting the 'Insert into' and 'delete' functions to work on an Access 2002 database.
I'm using the standard Data Controls under the ASP.NET section of the EW toolbox. Everything seems to work well. All functions work in the localhost. When I try it on the server, I can see the contents of the database table (indicating that the connection is working - I guess) but the Insert funtion generates an error that says "Operation must use an updateable query"
The Insert statement generated by EW is: InsertCommand="INSERT INTO [BRCUSOpen] ([name], [comments], [paid]) VALUES (?, ?, ?)"
Does this seem like a problem with a setting on the server, which I'm told is set up for dotNet?
|
|
|
|
treetopsranch
Posts: 1539
From: Cottage Grove, OR, USA
Status: offline
|
RE: Transition to Expression Web issue - 6/2/2009 12:47:08
Since this forum has discontinued the Expression Web section I have been going to this Expression Web Forum for help. Lots of Expression Web experts there.
_____________________________
Don from TreeTops Ranch, Oregon
"I've got a taste for quality and luxury"
| |
|
|
|
stu
Posts: 142
From: doylestown,pa
Status: offline
|
RE: Transition to Expression Web issue - 6/2/2009 13:34:42
Thanks treetopsranch. I'll post on that forum.
Since you're one of the people who convinced me to go to EW (from an earlier post), do you have any comment on my issue?
So far, I'm impressed with the capabilities of EW and with ASPNet, but i need to get past this issue.
| |
|
|
|
ou812
Posts: 1705
Joined: 1/5/2002
From: San Diego
Status: online
|
RE: Transition to Expression Web issue - 6/2/2009 17:50:48
Just a quick guess, but you may want to look and make sure your database is writeable. The error you describes seems it is having difficulties accessing to delete or insert, and probably update.
_____________________________
-brian
Black Holes suck.
EnterpriseDB: Enterprise-class relational database management system
PostgreSQL: The world's most advanced open source database
| |
|
 New Messages |
 No New Messages |
 Hot Topic w/ New Messages |
 Hot Topic w/o New Messages |
 Locked w/ New Messages |
 Locked w/o New Messages |
|
Post New Thread
Reply to Message
Post New Poll
Submit Vote
Delete My Own Post
Delete My Own Thread
Rate Posts
|
|
|
Printable Version 