Jim, Try putting the control# column name inside idquote characters. The # used to be very common in R:BASE databases, but would be illegal in most SQL implementations.
The default idquotes character is the backwards quote character, usually left of 1 and below the ESC key. Bill (sent from Android mobile) On Aug 5, 2013 7:30 PM, "Jim Belisle" <[email protected]> wrote: > Not a reserved word according to the Help information.**** > > ** ** > > *From:* [email protected] [mailto:[email protected]] *On Behalf Of *Karen > Tellef > *Sent:* Monday, August 05, 2013 6:27 PM > *To:* RBASE-L Mailing List > *Subject:* [RBASE-L] - Re: cannot delete rows from table**** > > ** ** > > I could be wrong, but I think "control" is a reserved word. Make sure you > have > ANSI OFF? > > Karen**** > > ** ** > > ** ** > > -----Original Message----- > From: Jim Belisle <[email protected]> > To: RBASE-L Mailing List <[email protected]> > Sent: Mon, Aug 5, 2013 6:19 pm > Subject: [RBASE-L] - cannot delete rows from table**** > > **** > > ** ** > > I have a strange situation.**** > > ** ** > > I cannot delete rows from a table using code but can go into the table**** > > and delete the rows.**** > > ** ** > > This is my code I used that worked on another table but not on this**** > > table.**** > > ** ** > > delete from orderpartused where control# in ()**** > > ** ** > > I am using the most recent 9.5 compiled RBASE.**** > > ** ** > > **** > > ** ** > > James Belisle**** > > ** ** > > **** > > ** ** > > Making Information Systems People Friendly Since 1990**** > > ** ** > > **** > > ** ** > > **** > > ** ** > >
