At 04:30 PM 3/20/2002 -0900, Jim Blackburn wrote: >I have assembled a routine that sends a crosstab to a file, loads >the file into a temporary table, and reformats the output slightly. > >It works well, but, when I assemble the working pieces into a >program, the temporary table comes out loaded with the correct >number of rows, all but the headings are null. > >If I have the program load an existing crosstab output - it works >properly. If I take the load command from the program and >execute it at the R> on the file created within the command, it >works properly. Within the command file, Pause for 10 does not >help, nor does doing other operations for a while including opening, >writing, and closing other files. > >Is there any way to make this work?
Jim, I would try the Step-By-Step DEBUG/TRACE process to narrow down that boo-boo. I'm sure you are NOT disconnecting/connecting the database during the process of creating and storing results in TEMPORARY Table. It would be REALLY COOL to use DYNAMIC CROSSTAB DATA in a Report Designer/Writer! Very Best Regards, Razzak. ================================================ TO SEE MESSAGE POSTING GUIDELINES: Send a plain text email to [EMAIL PROTECTED] In the message body, put just two words: INTRO rbase-l ================================================ TO UNSUBSCRIBE: send a plain text email to [EMAIL PROTECTED] In the message body, put just two words: UNSUBSCRIBE rbase-l ================================================ TO SEARCH ARCHIVES: http://www.mail-archive.com/rbase-l%40sonetmail.com/
