//Set the distance of SOI People
i = 0;
while (i < num_rows)
{
str_cpy(sql_cmd, "update soi set distance = ");
str_cat(sql_cmd, "sqrt(pow((select pos_x from position where handle = '");
str_cat(sql_cmd, send_handles.string[i]);
str_cat_num(sql_cmd, "') - %f, 2)) + ", cur_pos[0]);
str_cat(sql_cmd, "sqrt(pow((select pos_y from position where handle = '");
str_cat(sql_cmd, send_handles.string[i]);
str_cat_num(sql_cmd, "') - %f, 2)) + ", cur_pos[1]);
str_cat(sql_cmd, "sqrt(pow((select pos_z from position where handle = '");
str_cat(sql_cmd, send_handles.string[i]);
str_cat_num(sql_cmd, "') - %f, 2)) ", cur_pos[2]);
[...]