Foxpro Memo field type and Oracle8i ?

From: dejanj <member40114_at_dbforums.com>
Date: Tue, 28 Oct 2003 01:23:36 -0500
Message-ID: <3530127.1067322216@dbforums.com>

Hi All,

Can anybody tell me how to upsize this 2 tables in Oracle8i from Visual Foxpro 6.

They both uses Memo fields. What field type should i use in Oracle8i?

FUNCTION MakeTable_SGCCELOG

Table setup for SGCCELOG *****

CREATE TABLE 'SGCCELOG.DBF' NAME 'SGCCELOG' (USER C(10) NOT NULL, ;

                       PREFIX C(3) NOT NULL, ;

                       ERR_DATE T NOT NULL, ;

                       ERR_NO N(4, 0) NOT NULL, ;

                       ERR_MESS M NOT NULL, ;

                       CUR_PROG M NOT NULL, ;

                       LINE_NO N(6, 0) NOT NULL, ;

                       LINE_CODE M NOT NULL, ;

                       TOP_WINDOW M NOT NULL, ;

                       GET_FIELD C(10) NOT NULL, ;

                       LAST_KEY N(4, 0) NOT NULL, ;

                       CUR_MEMORY M NOT NULL, ;

                       CUR_STATUS M NOT NULL)

Create each index for SGCCELOG *****

SET COLLATE TO 'MACHINE' INDEX ON TTOC(ERR_DATE,1)+USER+PREFIX TAG DATE_ASC INDEX ON STR(100000000000000-VAL(TTOC(ERR_DATE,1)),14)+USER+PREFIX TAG DATE_DESC

Change properties for SGCCELOG *****

ENDFUNC FUNCTION MakeTable_SGCCSUSR

Table setup for SGCCSUSR *****

CREATE TABLE 'SGCCSUSR.DBF' NAME 'SGCCSUSR' (ENCRYPTED C(132) NOT NULL, ;

                       PW_PRIOR M NOT NULL, ;

                       LANG_ID C(3) NOT NULL, ;

                       L_USERSEL M NOT NULL)

Create each index for SGCCSUSR *****

SET COLLATE TO 'MACHINE' INDEX ON SUBSTR(ENCRYPTED,15,10) TAG USER_ID INDEX ON SUBSTR(ENCRYPTED,5,10) TAG USER_NO INDEX ON LANG_ID TAG LANG_ID

Change properties for SGCCSUSR *****

ENDFUNC Help is very much appreciated.

Thanks

Dejan Jocic

--
Posted via http://dbforums.com

Received on Tue Oct 28 2003 - 00:23:36 CST