|
From: Andy C. <an...@ad...> - 2001-03-31 15:25:54
|
Table BALE, column FARMERIDENT is 7 characters. I added column ZONEIDENT =
which is a copy of the first 4 characters of FARMERIDENT. I tried (in =
isql.exe)
UPDATE BALE SET ZONEIDENT=3DSUBSTR(FARMERIDENT,1,4) WHERE ZONEIDENT =
IS NULL;
and the reference to SUBSTR ( or SUBSTRING ) was rejected. Also, grep =
can't find "SUBSTR" anywhere in C:\Program Files\Firebird. Near as I can =
tell Firebird doesn't come with any substring function. So I wrote code =
that selects every record where ZONEIDENT IS NULL, does a C strncpy(), =
and updates the record. Is there one or more UDF Libraries we should be =
shipping in the Firebird package?
|