Ok - we are restructuring the application, so that now, we can get away
with a primary key field of just an INTEGER, rather than the two BIGINT
columns. Also, because of the restructure, we don't need to check for
the existence of a duplicate record before insertion, so we can now
create the p
"Bernt M. Johnsen" <[EMAIL PROTECTED]> writes:
> Reginald Johnson wrote (2008-03-30 00:48:33):
>> Is it possible to update the substring of a field? I'm trying to do
>> something like this:
>>
>> UPDATE tblIntervals SET SessionMouseID = 'ggg', substr(SessionID, 0, 3) =
>> 'ggg' WHER
Reginald Johnson wrote (2008-03-30 00:48:33):
> Is it possible to update the substring of a field? I'm trying to do
> something like this:
>
> UPDATE tblIntervals SET SessionMouseID = 'ggg', substr(SessionID, 0, 3) =
> 'ggg' WHERE SessionMouseID = 'bbb'
Neither Derby, nor the SQL s