David, Thanks for that - my excuse is the same - either seems to work for me so far, although I do appreciate that in some commands IN is not correct and FROM is needed. Perhaps I need to spend some time updating myself -all I need is the 'spare' time and even RBTI do not provide that.
Regards, John Docherty -----Original Message----- From: [email protected] [mailto:[EMAIL PROTECTED] On Behalf Of David M. Blocker Sent: Sunday, June 26, 2005 10:27 AM To: RBG7-L Mailing List Subject: [RBG7-L] - Re: 7.5 Edit Data in Grid or Row Sorry, John I hit "send" too soon! The error in syntax was EDIT ALL IN SYSTEMS instead of EDIT ALL FROM SYSTEMS ALL is fine instead of * David Blocker [EMAIL PROTECTED] 781-784-1919 Fax: 781-784-1860 Cell: 339-206-0261 ----- Original Message ----- From: "John Docherty" <[EMAIL PROTECTED]> To: "RBG7-L Mailing List" <[email protected]> Sent: Saturday, June 25, 2005 5:21 PM Subject: [RBG7-L] - Re: 7.5 Edit Data in Grid or Row > Jim, > > Thanks for your response. I have solved the problem by reducing some of my > column sizes to keep under the 4096 byte limit per row. > > My using 'edit all' instead of 'edit *' is probably just a hangover from the > past - I presume 'edit all' was valid when I started with v2.1c in '87. > Still seems to work though. > > Regards, > > John Docherty > > -----Original Message----- > From: [email protected] [mailto:[EMAIL PROTECTED] On Behalf Of James Bentley > Sent: Sunday, June 26, 2005 8:06 AM > To: RBG7-L Mailing List > Subject: [RBG7-L] - Re: 7.5 Edit Data in Grid or Row > > John, > > Perhaps I am misunderstanding the command you are > using "EDIT ALL IN SYSTEMS". If that is indeed the > exact command you are using then it is not a valid > command syntax. > > Jim Bentley > American Celiac Society > [EMAIL PROTECTED] > --- "A. Razzak Memon" <[EMAIL PROTECTED]> wrote: > > > At 10:36 PM 6/23/2005, John Docherty wrote: > > > > > I try EDIT ALL IN SYSTEMS, which is where the > > error occurs. > > > > > > John, > > > > Try the following steps and see what you get: > > > > CONNECT dbname > > SET VERIFY ROW > > EDIT * FROM tablename WHERE ... ORDER BY ... > > > > Let me know. > > > > Very Best R:egards, > > > > Razzak. > > > > > > > > > __________________________________ > Do you Yahoo!? > Yahoo! Mail - Find what you need with new enhanced search. > http://info.mail.yahoo.com/mail_250 > > -- > No virus found in this incoming message. > Checked by AVG Anti-Virus. > Version: 7.0.323 / Virus Database: 267.8.1/28 - Release Date: 24/06/2005 > > > -- > No virus found in this outgoing message. > Checked by AVG Anti-Virus. > Version: 7.0.323 / Virus Database: 267.8.1/28 - Release Date: 24/06/2005 > > > > -- No virus found in this incoming message. Checked by AVG Anti-Virus. Version: 7.0.323 / Virus Database: 267.8.1/28 - Release Date: 24/06/2005 -- No virus found in this outgoing message. Checked by AVG Anti-Virus. Version: 7.0.323 / Virus Database: 267.8.1/28 - Release Date: 24/06/2005
