2014년 12월 23일 화요일

fusion tabloya kayıtlı olan verinin rowid nasıl alınır? (How to get the rowid of the data is saved to the fusion of the table?)


rowid need to update or delete operation, but I can not reach him

--
SELECT ROWID FROM <tableid> WHERE ...
--
unfortunately it's a little bit complicated...
How do i delete all values in one column 
you only can delete rows, but you can update all values in a column and set them to empty string like this:

generally: For UPDATE statements the first step to be done is to get the ROWID of the row to be updated with a SELECT statement. The second step is to do the UPDATE.

to update several rows, you first could retrieve the rowids of all rows like this
SELECT ROWID FROM <tableid>
and store them in a list, then execute an update statement for each rowid
UPDATE <tableid> SET myColumn = '' WHERE ROWID = <rowid>

how do i only get the last value in a column
you can try the following slect statement
SELECT columnName FROM <tableid> WHERE ROWID = MAXIMUM(ROWID)

--

댓글 없음:

댓글 쓰기