How to set an object to null

Question

Hi,

How to set an object to null.

Ex:

my object samp contains three fileds samp.field1,samp.field2.sampfield3

If i set samp:= null; im getting errors is there a way to set the object value to null.

Answer 1

An sql database does not know about objects, it deals with rows in table.

To remove a row use DELETE :

e.g. :

DELETE FROM samp WHERE id = 12345;

DELETE FROM samp WHERE field1 = 'Delete Me';

The first example is typical to remove individual rows uing their primary key (id in this case)

The second example will remove a group of rows which have a speciic value for a field.