Hi, use this:
UPDATE 50:12 SET out=(SELECT FROM #14:10) Il giorno mercoledì 20 aprile 2016 17:09:05 UTC+2, Simon White ha scritto: > > I am probably being stupid but I am trying to run the sql UPDATE EDGE > command (from the docs http://orientdb.com/docs/2.1/SQL-Update-Edge.html) > > But I can't get it to run.... > > UPDATE EDGE Friend SET out = (SELECT FROM #14:10) WHERE @rid = '#50:12' > > > > > com.orientechnologies.orient.core.sql.OCommandSQLParsingException: Error > on parsing command at position #0: Error parsing query: UPDATE EDGE Friend > set out = #14:10 Encountered " <EDGE> "EDGE "" at line 1, column 8. Was > expecting one of: <TO> ... <VALUES> ... <SET> ... <ADD> ... <PUT> ... > <MERGE> ... <CONTENT> ... <REMOVE> ... <ORDER> ... <GROUP> ... <OFFSET> ... > <RECORD> ... <LUCENE> ... <NEAR> ... <WITHIN> ... <EXCEPTION> ... <FIND> > ... <REFERENCES> ... <THIS> ... <RECORD_ATTRIBUTE> ... <INTEGER_LITERAL> > ... "(" ... "[" ... "?" ... ":" ... "-" ... "*" ... <IN> ... <KEY> ... > <CLUSTER> ... <IDENTIFIER> ... <QUOTED_IDENTIFIER> ... <INDEX_IDENTIFIER> > ... <INDEXVALUES_IDENTIFIER> ... <INDEXVALUESASC_IDENTIFIER> ... > <INDEXVALUESDESC_IDENTIFIER> ... <CLUSTER_IDENTIFIER> ... > <CLUSTER_NUMBER_IDENTIFIER> ... <METADATA_IDENTIFIER> ... "#" ... > > I need to update the OUT value of an edge whilst maintaining the graph > consistency with vertices and *without recreating the edge* > -- --- 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 orient-database+unsubscr...@googlegroups.com. For more options, visit https://groups.google.com/d/optout.
