Hi
(1)
A simple code to insert, update and delete using TOraQuery works fine for updating and deleting. Trying to insert a record like
iClientID := StrToInt(edtClientID.Text);
sSurname := edtSurname.Text;
sName := edtName.Text;
//
dm1.qrOraTemp.Close;
dm1.qrOraTemp.SQL.Clear;
dm1.qrOraTemp.Params.CreateParam(ftInteger, 'P_ClientID', ptInput);
dm1.qrOraTemp.ParamByName('P_ClientID').AsInteger := iClientID;
dm1.qrOraTemp.Params.CreateParam(ftString, 'P_Surname', ptInput);
dm1.qrOraTemp.ParamByName('P_Surname').AsString := sSurname;
dm1.qrOraTemp.Params.CreateParam(ftString, 'P_Name', ptInput);
dm1.qrOraTemp.ParamByName('P_Name').AsString := sName;
aaSQL := 'INSERT INTO SCOTT.ScottClients' +
' (ClientID, Surname, FirstName)' +
' VALUES' +
' (:P_ClientID, :P_Surname, :P_Name)';
dm1.qrOraClients.SQL.Text := aaSQL;
dm1.qrOraClients.ExecSQL;
raises the ORA-01400 Cannot Insert Null ... and then
... exception Class N-18 message 'Unknown Error 1'
Any help there please?
(2)
This ScottClient table above works fine for updating and deleting when the table IOT properties are set to "Standard, Heap Organized".
Before I did that I had used "Index Organized Table (IOT)" and the above code or what else .. would raise:
"ORA-03115: Unsupported Network Datatype or Representation"
Any comments there please ?
Thank you