Generating Log Code (Surrogate Key)

luckiejacky

1.   String str1 = "select 'LOG' || replace(substr(quote(zeroblob((9 + 1) / 2)), 3, (9 - length('LOG') - length(max(IFNULL(e.LogID,0)+1)))), ''', '') || "
   
2.                  +" max(IFNULL(e.LogID,0)+1) || '-' || strftime('%Y-%m-%d', date('now'))"
   
3.                   +" from elog e ";

複製代碼

What happens when there are no rows in the
database initially.
Thanks

henrywho

Why dun you try 1st?

And some times, for related reasons, we need to use nested ifnull() / nvl()

luckiejacky

Thanks, I have solved it by Java instead