Hi Athanassios, I guess you are just not deleting anything with that statement ;-) Try to add a @ in front of rid:
delete from CL where @rid = 12:2 or even better delete from CL where @rid = #12:2 Luigi 2015-07-23 20:37 GMT+02:00 Athanassios Hatzis <[email protected]>: > Hi, I am using OrientDB 2.1 rc5 > > When you execute an sql delete command on the OrientDB Studio, such as > > delete from CL where rid=12:2 > > and then > > select from CL > > You get back also the list of deleted records including the one currently > deleted right ? > > But there is not any indication that the record has been deleted. > In that case it is possible to confuse the deleted record with a newly > created record that have the same fields completed. > > Therefore you should either indicate that the record has been deleted > and/or have an option to display deleted records. > e.g. with a METADATA field such as @deleted=TRUE/FALSE > > If there is such functionality in the latest version please let me know, > or make another suggestion > > Thank you > > PS: A more general comment would be to add some functionality that will > allow the administrator to view the history of operations on a certain > record. > Currently you can only view that the record has been modified @version > times..... > > -- > > --- > You received this message because you are subscribed to the Google Groups > "OrientDB" group. > To unsubscribe from this group and stop receiving emails from it, send an > email to [email protected]. > For more options, visit https://groups.google.com/d/optout. > -- --- You received this message because you are subscribed to the Google Groups "OrientDB" group. To unsubscribe from this group and stop receiving emails from it, send an email to [email protected]. For more options, visit https://groups.google.com/d/optout.
