<!DOCTYPE html PUBLIC "-//W3C//DTD HTML 4.01 Transitional//EN">
<html>
<head>
<meta content="text/html;charset=ISO-8859-1" http-equiv="Content-Type">
</head>
<body bgcolor="#ffffff" text="#000000">
Kenneth Brody wrote:
<blockquote
cite="mid20051017190311.r425ckgsccgg8k0o@webmail.spamcop.net"
type="cite">
<pre wrap="">Quoting Dan Coutu (Mon, 17 Oct 2005 17:08:11 -0400):
</pre>
<blockquote type="cite">
<pre wrap="">Kenneth Brody wrote:
</pre>
</blockquote>
<pre wrap=""><!---->[...Building memo field from other fields...]
</pre>
<blockquote type="cite">
<blockquote type="cite">
<pre wrap="">Have you tried:
my_memo = comment_1 < comment_2 < comment_3
</pre>
</blockquote>
<pre wrap="">Okay, so I tried to build on this idea. Basically I'm writing processing
table code that has no human user interface. It is used in automated
processes. So I had made a filePro database whose purpose in life was to
contain the code. Because of this the fields in the database are
actually useless. So made a new field, defined it as a memo field, and
then tried this type of code logic:
Note: field 2 is a memo field.
if: ' Test value for recnum field, field 2
then: rn(8,.0)="93414"
if: ' Initialize the memo to be empty.
then: 2 = ""
if:
then: lookup tbl=detail i=B k=rn -ng
loop:
if: not tbl
then: goto done
if: tbl(2) ne rn
then: goto done
if: tbl(5) ne ""
then: 2 = 2 < tbl(5)
if:
then: getnext tbl
if:
then: goto loop
done:
if:
then: close tbl
if:
then: end
Seems pretty straightforward. Yet it crashes and burns with a
segmentation violation every time. Seems like I should be able to append
stuff to a memo field right?
Am I missing something?
</pre>
</blockquote>
<pre wrap=""><!---->
What length/type are field 2 and tbl(5)?
On which line does it SEGV?
</pre>
</blockquote>
field 2 of the db is a memo field. tbl(5) has a (500,*) edit.<br>
<br>
I'll have to run it in debug mode to isolate the line that dies. I'll
try that in the morning.<br>
<br>
Dan<br>
</body>
</html>