The Help states that the word 'Rows' is optional for the Delete command. I have other code in my application that use just the Delete from (without the rows). I just used the open and closed paren to illustrate without putting the actual information in there. The real code has multiple orders within the paren separated by commas.
I will wait until the operation is used again on Tuesday to see if the problem arises again. Jim -----Original Message----- From: [email protected] [mailto:[email protected]] On Behalf Of Javier Valencia Sent: Monday, August 05, 2013 7:00 PM To: RBASE-L Mailing List Subject: [RBASE-L] - RE: cannot delete rows from table I have always used the syntax: DELETE ROWS FROM your_table WHERE your _column your clause Now what is the clause: WHERE control# in () Mean? Are you trying to delete rows where the column control# is NULL or empty? In that case you should use: DELETE ROWS FROM orderpartsused where control# IS NULL Or DELETE ROWS FROM orderpartsused where control# IN ('') You can try doing a selection with your clause: BROWSE * FROM orderpartsused where control# in () If it brings up records, then the clause is correct; if it does not, then you WHERE clause is probably incorrect. Also, you can: SET ECHO ON And then do the manual delete and look at the R> prompt and the correct command used will be displayed Javier, Javier Valencia, PE O: 913-829-0888 H: 913-397-9605 C: 913-915-3137 -----Original Message----- From: [email protected] [mailto:[email protected]] On Behalf Of Jim Belisle Sent: Monday, August 05, 2013 6:14 PM To: RBASE-L Mailing List 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
