Hi Chris,
I think the cat.t and cat.f functions handle it for you.
Try this:
cat.c["abc";1;"def"]
the number 1 as opposed to the string values outputs a CRLF, you can use
other numbers other than 1
Regards
Brian
_____
From: [email protected]
[mailto:[email protected]] On Behalf Of Chris Pedersen
Sent: Tuesday, 21 April 2009 12:48 PM
To: [email protected]
Subject: Re: [Dataperf] DP 2.6f on XP/Vista and SBS 2003/2008
It would be cool if the web site had a FAQ, and if there were the ability to
search a knowledgebase.
For example, I know I have append CR/LF's to text data.. a thousand times.
I just don't remember *how* I did it.
_____
From: [email protected]
To: [email protected]
Date: Tue, 21 Apr 2009 12:05:01 +1000
Subject: Re: [Dataperf] DP 2.6f on XP/Vista and SBS 2003/2008
Hi Miguel,
1. DP is a file database so your users need to just have a mapped drive on
the file server. You can use any DOS or DOS emulating client, Win31, Win95,
Win98, Win2000, WinXP. or you can run it in a terminal server windows under
Win2003. The easiest way to deply a DP application is to copy all the
application files in one folder, and include the executables DP.EXE and
DP.SYS. Since the program itself is very tiny, there is no issue about
loading the executables across the network from the server. DP creates
temporary files in the same folder as the application files unlee you start
it with the /D-[drive:path] startup switch to set as different temp folder.
2. DP generally needs little or no maintenance. On rare occasions if you
have been moving files around and have screwed something up you might need
to do a reindex (Shift-F9). Some people advocate the use of a "Big Clean"
where you export all the data into a log file, and then reimport it, as a
way to clean out nasties, but personally in 18 years of using it I have
never had t do it.. Usually maintina it is a matter of adding the new
functionality that application always seem to demand.
3. There is no automatic conversion to MS Access. I use MS Access
extensively, and even if there was a simple way of exporting data and
definitions into Access you would probably find that the design paradigms
are so dissimilar that you are better designing from scratch rather than
converting. You can use DP reports to export data. Reports offer low level
access, so you can create CSV files, Tab delimited files, or WordPerfect
secondary files, or even XML. If you are a whizz with the Access XML
database schema you can actually write an export from DP which you can take
the entire set of data and panel definition etc, and convert it to Access.
I have done it once as a purely academic exercise so it can be done, but it
takes for ages and is very complicated.
4. DP upgrades are as simple as replacing the older DP.EXE and DP.SYS
file with the newer ones.
5. There are heaps of good resources through this mailing list and
associated website http://dataperfect.nl <http://dataperfect.nl/>
Regards
Brian
_____
From: [email protected]
[mailto:[email protected]] On Behalf Of Miguel Monk
Sent: Monday, 20 April 2009 4:43 PM
To: [email protected]
Subject: [Dataperf] DP 2.6f on XP/Vista and SBS 2003/2008
Hello!
I have never worked with DP before, and I have several questions.
1) I am wondering if DP 2.6f can be moved from old Win98 stations to have
the database on a Small Business Server 2003 or 2008 server, with clients
being XP Pro or Vista Business/Ultimate.
2) What is involved in maintaining DP, i.e., is there some sort of periodic
database maintenance that needs to be done?
3) Can DP be exported to MS Access 2007?
4) And finally, how does one upgrade from DP 27.6f to 2.6y?
Thank you for your help!
Gregg Hill
_____
Rediscover HotmailR: Get e-mail storage that grows with you. Check it out.
<http://windowslive.com/RediscoverHotmail?ocid=TXT_TAGLM_WL_HM_Rediscover_St
orage2_042009>
_______________________________________________
Dataperf mailing list
[email protected]
http://lists.dataperfect.nl/mailman/listinfo/dataperf
