HI,
I have a few problems.

I have at table in the Sqlserver

CREATE TABLE [dbo].[test_guid] (
[test_guid_id] uniqueidentifier ROWGUIDCOL NOT NULL ,
[a] [char] (10) NULL ,
[b] [char] (10) NULL ,
[bit1] [bit] NOT NULL ,
[timestamp_column] [timestamp] NULL
) ON [PRIMARY]

and a few values in it with bit1 .f.

i make a cursor with a valid handle like

cursorsetprop("buffering",5,0)

sqlexec(handle,'select * from test_guid','test1') && returns 1 and i get the cursor with the records.
** so far so good. Then
sqlexec(handle,'select top 0 test_guid_id,bit1 from test_guid','test2') && returns 1 and i get an empty cursor

insert into test2 values(test1.test_guid_id,.t.) && value gets inserted locally.
skip in test1
insert into test2 values(test1.test_guid_id,.t.) && value gets inserted locally.

** NOW how to update test2 ??? thats bugging me for days. I tried a lot with cursorsetprop. But the error returned was 1491. No update tables as specified.Use the tables property of the cursor.

Can any one tell me if it works this way and if so how ? If not how should i modify this ?

thanx in advance.