Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
ingineu
Yak Posting Veteran
89 Posts |
 Posted - 2003-07-06 : 20:09:31
|
| In trying to update a control, I receive the message: Form is read-only because the unique table property is not set. The Form was working before I switched over to SQL Server 7.0. I am Joining to 3 other Tables to pickup descriptions and that seems to be the hangup. If I just Select one table it works. Am I missing something? Thanks. |
|
|
X002548
Not Just a Number
15586 Posts |
Posted - 2003-07-07 : 17:04:25
|
| Maybe it's not an updateable recordset. Can you create a view in SQL Server and replace it as the source?Brett8-) |
 |
|
|
ingineu
Yak Posting Veteran
89 Posts |
Posted - 2003-07-07 : 18:39:48
|
| Here's what my simplified code looks like stored in a SPROC that doesn't allow me to update the TableA.ASeq field. SELECT TableA.AID, TableA.ACode, TableA.ASeq, TableB.BDescFROM TableA LEFT OUTER JOIN TableB ON TableB.BCode= TableA.ACode |
|
|
|
Doug G
Constraint Violating Yak Guru
331 Posts |
Posted - 2003-07-08 : 02:32:22
|
quote:
In trying to update a control, I receive the message: Form is read-only because the unique table property is not set. The Form was working before I switched over to SQL Server 7.0. I am Joining to 3 other Tables to pickup descriptions and that seems to be the hangup. If I just Select one table it works. Am I missing something? Thanks.
Did you set the unique table property of the control? I've noticed this gets unset sometimes for reasons I can't pin down.======Doug G====== |
|
|
|
ingineu
Yak Posting Veteran
89 Posts |
Posted - 2003-07-08 : 03:51:08
|
| You nailed it down .. it now works! Thanks a bunch!! |
|
|
|
|
|
|
Form: unique table property not set