NorbertNetzwerk
Technical User
Hi,
using SQLbase 7.0, I have 2 tables containing product data. Usually, in table SYNONYMS several descriptive strings (CHAR(100)) are held for each product listed in table STOFF.
Problem: some products have empty entries in SYNONYMS. As a last resort, there is a LONG VARCHAR field in STOFF which would do. I would like to copy the first 100 chars from it into the string field in SYNONYMS.
How can this be done? @substring() does not support LONG args.
Can it be done using a procedure? I am not very proficient in SQLbase so I would need any pointer at all.
I even thought of UNLOADing the db and using an awk script...
using SQLbase 7.0, I have 2 tables containing product data. Usually, in table SYNONYMS several descriptive strings (CHAR(100)) are held for each product listed in table STOFF.
Problem: some products have empty entries in SYNONYMS. As a last resort, there is a LONG VARCHAR field in STOFF which would do. I would like to copy the first 100 chars from it into the string field in SYNONYMS.
How can this be done? @substring() does not support LONG args.
Can it be done using a procedure? I am not very proficient in SQLbase so I would need any pointer at all.
I even thought of UNLOADing the db and using an awk script...