Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Having booklet start in second column
Message
 
 
General information
Forum:
Visual FoxPro
Category:
Reports & Report designer
Miscellaneous
Thread ID:
00514260
Message ID:
00514327
Views:
11
Mike,

Either UNION the row into the original cursor or you'll have to use a trick to make the cursor writable (VFP7 has a READWRITE clause that will solve this problem)
select ... into tempcursor
use dbf("tempcursor") alias TheNameYouWant again
use in tempcursor
>I am creating a two-column landscape report (booklet) and on the first page, I want to start the report in the second column. In Word, you would simply issue a column break on the blank first column to start the report on the second column.
>
>I added a field to my table called nsection, then I set all the data to have a value of 1 in nsection. I thought if I could insert a blank record with a value of 0 for the nsection, I could group first by this field, and start a new column after the first blank record (Data Grouping, Start Grouping on New Column).
>
>I created a cursor in the Data Environment that joins tables in a one to many relationship into a cursor T1.
>
>What I am trying to do is to APPEND a blank record into the T1 cursor. When I try:
>
>INSERT INTO T1 (nsection) VALUES (0)
>
>It tells me that it "Cannot update the cursor".
>
>I gave all the initial information in case there is another way to achieve this. I know this will work if I can append a record to my cursor with a single field value.
df (was a 10 time MVP)

df FoxPro website
FoxPro Wiki site online, editable knowledgebase
Previous
Reply
Map
View

Click here to load this message in the networking platform