Re: insert...select... with LONG

LONG data types are difficult to work with. In V7, you can use a LONG with SELECT, the SET clause of UPDATE, and VALUES of INSERT, but there are several restictions. The LONG column CANNOT:

• be used in WHERE, GROUP BY, ORDER BY, CONNECT BY, or SELECT..DISTINCT
• be referenced by SQL functions (e.g., SUBSTR, TO_CHAR)
• be used in the SELECT list of a query combined with set operators (UNION, INTERSECT, etc.)
• be used in expressions
• be referenced when creating a table with a query

I avoid their use whenever as possible, as it is difficult to use a columns with these restrictions. Hope this helps.

Dagmar Anne Bogan

Kopania & Komorovski
Richardson, TX 75081

dagmara_at_delphi.com Received on Sun Nov 20 1994 - 19:44:05 CET