Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Create cursor with Memo field causes problem
Message
From
26/02/2016 14:43:16
 
 
To
All
General information
Forum:
Visual FoxPro
Category:
Other
Title:
Create cursor with Memo field causes problem
Miscellaneous
Thread ID:
01632164
Message ID:
01632164
Views:
52
Hi,

I have a code in one of the programs that, on error, prints the error report. Here is simplified code:
CREATE CURSOR PROBALERT ( PROB_DESCR c(70), ERR_MSG c(250) ) 
		
INSERT INTO PROBALERT ( PROB_DESCR, ERR_MSG ) VALUES ;
	( "Problem!", ALLTRIM(pcErrorMsg) )

SELECT PROBALERT	
report form Problem_Report NEXT 1 NOCONSOLE to printer
The problem was that the field ERR_MSG c(250) was not big enough to hold the entire error message, so I changed the field type to memo.
The code, otherwise, is exactly the same
CREATE CURSOR PROBALERT ( PROB_DESCR c(70), ERR_MSG M )  
		
INSERT INTO PROBALERT ( PROB_DESCR, ERR_MSG ) VALUES ;
	( "Problem!", ALLTRIM(pcErrorMsg) )

SELECT PROBALERT	
report form Problem_Report NEXT 1 NOCONSOLE to printer
The problem is that after making the field ERR_MSG M the report prints on 100s and 100s pages, repeating the same page over and over.

What am I missing?
"The creative process is nothing but a series of crises." Isaac Bashevis Singer
"My experience is that as soon as people are old enough to know better, they don't know anything at all." Oscar Wilde
"If a nation values anything more than freedom, it will lose its freedom; and the irony of it is that if it is comfort or money that it values more, it will lose that too." W.Somerset Maugham
Next
Reply
Map
View

Click here to load this message in the networking platform