From: mctrf@ccu.umanitoba.ca (Manitoba Cancer Treatment Mctrf Research)
Newsgroups: comp.databases.sybase
Subject: WordPerfect -> Sybase
Message-ID: <C1IxHA.By2@ccu.umanitoba.ca>
Date: 27 Jan 93 17:48:46 GMT
Sender: news@ccu.umanitoba.ca
Organization: University of Manitoba, Winnipeg, Manitoba, Canada
Lines: 33
Nntp-Posting-Host: ccu.umanitoba.ca
I am using APT-workbench 4.0.2 to write an application. Our Sybase 4.0.1 server
runs on Sun stations. We would like to create a menu in a APT form so that, by
menu, users will be able to view in an APT Window (view only, no modification) a
WordPerfect 5.1 file. I understand that the file might have to be somehow
loaded into our database as SYBTEXT datatype. The WordPerfect files will be
modified frequently by other users using MS-DOS WordPerfect. The WordPerfect files are stored on a network drive using PC NFS. We need some hints for the following problems:
- How to convert and load WordPerfect files so that Sybase users can read (and
hopefully scroll through) ?
Our plan is:
C program DB lib.
WordPerfect 5.1 file -----------> ASCII -----------> SYBTEXT in database
Our WordPerfect files only contain text (plain, bold faced, underlined, italic
and large sized.) We are open to any other suggestions.
- What's the best way to view the file (or SYBTEXT) from an APT form?
Our file size can be limited to 100 lines (worst case). Do I create an
Entry field with Character datatype of Maximum length 9999 in the APT form?
- All the steps from WP to Sybase are combined as a menu processing in APT.
So the respond time should not be more than a few seconds for an on-line
application.
- As in the SYBASE tradition, all functions are required on-line. So
