General information
Category:
Databases,Tables, Views, Indexing and SQL syntax
>>HI,
Cetin,
I think u understood a bit wrong.
I have a tables populated with values.
I make a view modify a few records and then would like to update a the column OF those MODIFIED RECORDS.
So I have the primary key/s
I make a view with top 0 or the 1=2 ,
make the view updatable, insert those primary keys already present on the server into the updatable cursor and then issue a tableupdate ? Should Succeed ? No it doesnt.
I dont have a problem in inserting Fresh records.
Remember the last question i asked about joins ? I just wanted to do a bit turn around by doing this.
*** your code
mySQLExec(m.lnHandle,"select top 3 temp_guid_id","GUIDVal") && *** eg: these three records are to be updated.
Select GUIDVal
Scan
Insert Into v_test Values (GUIDVal.temp_guid_id,.T.) && value gets inserted locally.
** Yes but remember the PKs are already present on the server. I just want to modify a column associated with these records
Endscan
? Tableupdate(2,.T.,'v_test') && Tableupdate to send updates ?Will it succede ? It fails for me.
Previous
Reply
View the map of this thread
View the map of this thread starting from this message only
View all messages of this thread
View all messages of this thread starting from this message only