Quote:

I'm not sure what you mean by "form of a result set". Do you want a graphical representation of your form design as a text file? A graphical representation of each record in your result set?  If you are trying to duplicate a process you did in Q&A, could you tell us what you were doing in Q&A?

Part of your problem may be that you are in a graphical (GUI) environment now. The elements drawn on your screen are not text characters as they were in Q&A. Simply printing the form is a matter of clicking Print Form. Getting a GUI screen dump to translate itself into a plain text file is a different story. You are dealing with pixels, not ASCII characters. You also appear to need to push the output through Wordperfect. Perhaps if you explained what the actual end result needs to be, we could help?

[quote ]I  If you are trying to duplicate a process you did in Q&A, could you tell us what you were doing in Q&A? [/quote]

File, Print, enter file name, Print Records, F10 all,  Print Field Labels: Yes

That will print the whole form, including Label Entries, to either the 
printer or a ascii file.

Quote:


Select and retrieve a group of records from the database, then "print" the Field Labels and field entries for all fields for all of those forms, one form after another, all in one ascii file.

Quote:


I understand the difference between a set of pixels and an ascii character, but a displayed webpage is a "graphical environment", yet you can select the text and copy it (regardless of its Font attributes).  Isn't that part of the reason for the ODBC specs?  To be able to move info from one GUI ap to another?

My end result is to get my Form and its data (as nearly as possible as it is displayed on my database screen) to Wordperfect.  I then do a little editing for some alignment and word wrap to make it visually appealing.  Bold the Field Names and add several graphics at changing points on the page depending on the length of various field contents.  Since the placement is visual, the graphics have to be added manually.

Sorry for my frustrated rantings.  Thanks for helping me find a solution to my questions.

    Robert

I like the idea of the merge file, that is a great and simple solution.  In checking the Wordperfect help on merging, I should be able to merge a delimited text file.  So I will manually edit the Sesame exported file myself, and search and replace the decimal and extra zeroes on the whole number fields.  It should be ready to import at that point.  Shouldn't it?

That should make your offered SBasic code unnecessary at this point.  But just for info, where would the SBasic bode be put in Sesame? 

I understand "on Entry" and "on exit" and the other "in record" calculations, but I am fuzzy about where code to print a result set would be placed.   

    Thanks, Robert

Quote:


Yes.

Quote:


We would do this as a Mass Update. For each record, we would write a line to a text file, with the data formatted however you wanted. The end result would be a delimited text file, just like you get with export, but with custom data formatting.