OT:Oracle long to clob conversion V10.2

2007-05-29 Thread patrick zandi
Anyone out there know how to make a long raw into a clob (oracle Style) Version 10.2.0.3 --- And yes I still had some of those laying around from the 4.0 days. -- Patrick Zandi ___ UNSUBSCRIBE or access ARSlist Archives

Re: OT:Oracle long to clob conversion V10.2

2007-05-29 Thread Jarl Grøneng
Yes. Add new temporary field to form, same as the one with long. Created a temporary table holding entryid and CLOB. Copy from the TxxxC table to the temporary table. Update the form (SQL) with data from the temporary table. Deleted the original fields, added new one with the same id. SQL

Re: OT:Oracle long to clob conversion V10.2

2007-05-29 Thread Jarl Grøneng
Or you can do it the Remedy way. Add new fields, update all records with a set field filter. -- Jarl On 5/29/07, Jarl Grøneng [EMAIL PROTECTED] wrote: Yes. Add new temporary field to form, same as the one with long. Created a temporary table holding entryid and CLOB. Copy from the TxxxC