How to make SQL insert record?

#1

Hi
Whats wrong in this code, exactly following the manual https://orientdb.com/docs/3.0.x/sql/SQL-batch.html

image
image1901×869 42.9 KB

Thanks

#2

Hi @hanzgs

I just tried it in latest 3.0.25 and it works fine.
Did you select the BATCH mode for the execution?

Thanks

Luigi

#3

Hi @luigidellaquila
Thanks for the reply

May I know whats the BATCH mode for execution please

Thanks

#4

Hi @hanzgs

On the Browse tab in Studio, at the bottom right corner of the query panel, click on the drop-down menu and choose Type: BATCH

21
21744×972 33.2 KB

I hope it helps

Thanks

Luigi

#5

Thanks @luigidellaquila

Finally I made it working
the issue is

begin;
let payment = create vertex Transactions set TrxID = 'T1';
let account = select from Accounts where AccountNo = 'A1';
let e = create edge madeTrans from $account to $payment;
commit retry 100;
return $e;

I have I already created vertex for Accounts, but not for Transactions and didn’t create edge madeTrans

I thought the query “create vertex and create edge” creates if they doesn’t exists

Now I created first, then ran the begin query, it worked

Thanks