There is no triggers in the table . it is a simple table with no primary key only 4 fields in tht named as TEST as name c(10),address c(50),city c(10),pincode n(10).

And when i use the command to delete from SQL as
sqlexec(gnhandle,"delete from test") it works fine but it deletes all the records. Now my problem is that i need to delete only one record e.g
i need like "delete from test where name = cstest.name)
here cstest is the alias for the cursoradaptor created.

TIA
Shailesh