James, Thanks for your emails re my problem. It appears that it was all down to the row length being too long. I originally thought I had fixed this by reducing some of the column sizes (as the error disappeared when I tried to save the modified table), however this apparently was not the case, so some further reductions were needed, which now seem to have solved the problem. (The edit was on a table, not a view.)
It was interesting to see that the error message only was generated when I used the commands Razzak suggested (and then only if I included an order by clause as well). This demonstrates the good support we are able to get from RBTI, and the value of this list. Thanks & Regards John Docherty -----Original Message----- From: [email protected] [mailto:[EMAIL PROTECTED] On Behalf Of James Bentley Sent: Tuesday, 28 June 2005 7:30 a.m. To: RBG7-L Mailing List Subject: [RBG7-L] - Re: 7.5 Edit Data in Grid or Row- Access Violation Error on Save John, If you are editing a view are you sure that your view is "an editable view". The dos version was more liberal than the windows version in defining what is an editable view. To the best of my knowledge in windows you must use a single table view and it can't have a GROUP By or HAVING clause Jim Bentley American Celiac Society [EMAIL PROTECTED] tel 1-504-738-6165 --- John Docherty <[EMAIL PROTECTED]> wrote: > I find at times that when using the edi all in .. > command with the data > viewed as a row it is not possible to change the > data, with the data entered > being lost when the cursor moves away from a column, > while in the grid view, > editing works correctly. My latest problem with the > edi all in . command > results in an access violation error (in > RBENGINE.DLL) when I try to save > the changes using either view - this occurs on two > different machines. > > > > If anyone has any suggestions as how to overcome the > access violation error > that would be much appreciated. > > > > Thank you. > > > > Regards > > > > > > John Docherty > > > > __________________________________________________ Do You Yahoo!? Tired of spam? Yahoo! Mail has the best spam protection around http://mail.yahoo.com
