Information générale
Catégorie:
Base de données, Tables, Vues, Index et syntaxe SQL
Titre:
Send updates to the MSSQL server VFP6.0
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.
Suivant
Répondre
Voir le fil de ce thread
Voir le fil de ce thread à partir de ce message seulement
Voir tous les messages de ce thread
Voir tous les messages de ce thread à partir de ce message seulement