does anyone get me a demo by uniquery.sqldelete?

[bugmenot1]

I read the documents but didn't understand how to use it.

[bork]

Hello

For example you have the following table:

Code: Select all

CREATE TABLE MY_TEST_TABLE (
  ID NUMBER,
  NAME VARCHAR2(50),
  VALUE NUMBER(15,10)
)

To select data from this table you should write the following query:

Code: Select all

  UniQuery1.SQL.Text := 'select * from MY_TEST_TABLE';

Now if you try to delete a record from UniQuery1 then UniDAC will generate a DELETE query automatically. But if you want to write the DELETE query manually then you should write the following code:

Code: Select all

  UniQuery1.SQLDelete.Text := 'delete from MY_TEST_TABLE where ID = :Old_ID';

In this case ODAC gets the ID value from the selected record and puts it to the "Old_ID" parameter automatically. And the current record will be deleted. If you want to delete a record by the NAME field then you should write the following DELETE query:

Code: Select all

  UniQuery1.SQLDelete.Text := 'delete from MY_TEST_TABLE where NAME = :Old_NAME';

You can find more detailed information about this in the UniDAC help.

If you need a sample application then please contact me by E-mail and I will send a sample to you.