Hi,

Thank very much for your kind help, yes i m using VF8 with SQL Server2000
and i allready using Cursor Adapter with ADO( if Create with ODBC i have to configure DSN and all
so, i prefer to make in using ADO, so, i can cotrool the database path through Program ),
but if i want to add anything we have to issue a command like
CA.Add and CA.Update etc..., but if i want search a code and if it is not found,
then i want add the record otherwise i want to edit it. for these purposes what shall i do.
i saw a command like CA.Seek, but i do'nt how to seek and set the index for seeking other
wise on which base i will seek.

if don't mind Pls check the following stament too.

val1 = 'test1'
val2 = 3456.000
val3 = 1

Ca.Add
Ca.Fileds("abc") = val1
Ca.Fileds("xyz") = val2
Ca.Fileds("cde") = val3
ca.update

its giving errors especially for numeric values

With Thanks and Regards

Abdulla