Update and Select...

[VAMick]

Can I do an update and select in the same query?

I want to show a record and also update the "times it was viewed"...is that how I'd do it?

 

[rac2]

I think you must do that in two steps from the application which presents the record.

...
//My application obtains data with a SELECT statement,
//  including the primary key for the row to be viewed.
$sqlStatement = "SELECT colA, colB, mytable_id ";
$sqlStatement .= "FROM MyTable WHERE colX = $xToView ";

//This would be the code in ActivePerl using Win32::ODBC
//  for obtaining the primary key value.
$aDB->Sql($SqlStatement);
%aRowOfData = $aDB->DataHash();
$rowViewedID = $aRowOfData{'mytable_id'};

...

//Then update that row.
$sqlStatement = "UPDATE MyTable SET times_viewed = times_viewed + 1 ";
$sqlStatement .= "WHERE mytable_id = $rowViewedID ";
$aDB->Sql($SqlStatement);