SQL. Add (' insert into BookOrder (Code, ReaderId, ISBN, BName, Author, BCost, Quantity, OrderDate, DepositCash, DeliveryDate, BookOrderMemo) '+
'values (Code, : ReaderId, : ISBN, : BName, : Author, : BCost, : Quantity, : OrderDate, : DepositCash, : DeliveryDate, : BookOrderMemo)');
O master correct,,

CodePudding user response:

The

refer to the original poster yummy2046 response:

SQL. Add (' insert into BookOrder (Code, ReaderId, ISBN, BName, Author, BCost, Quantity, OrderDate, DepositCash, DeliveryDate, BookOrderMemo) '+
'values (Code, : ReaderId, : ISBN, : BName, : Author, :...

'the select Reader. ReaderId from Reader, BookOrder
Where Reader. ReaderId=BookOrder. ReaderId and Reader, IdCard='+ quotedstr (Edit11. Text)
='+ +' and BookOrder. ReaderId quotedstr (Edit2. Text);