Re: [dabo-users] What Does a ReportDesigner Dictionary Cursor Look Like?

[Ed Leafe]

On Mar 2, 2007, at 5:57 PM, Rich Shepard wrote:

>    I would like to see an example of a dictionary cursor that RD  
> accepts as
> input. This will allow me to query the sqlite3 database, extract  
> the table
> data, and manually prepare the cursor.

        I ran a custom report against the standard zipcodes demo database,  
and the data in the rfxml file looked like:

         <TestCursor>
                 <record czip="u&apos;60001&apos;"  
ctimezonediff="u&apos;+6&apos;" cstateprov="u&a
                 <record czip="u&apos;60002&apos;"  
ctimezonediff="u&apos;+6&apos;" cstateprov="u&a
                 <record czip="u&apos;60004&apos;"  
ctimezonediff="u&apos;+6&apos;" cstateprov="u&a
                 <record czip="u&apos;60005&apos;"  
ctimezonediff="u&apos;+6&apos;" cstateprov="u&a
                 <record czip="u&apos;60006&apos;"  
ctimezonediff="u&apos;+6&apos;" cstateprov="u&a
                 <record czip="u&apos;60007&apos;"  
ctimezonediff="u&apos;+6&apos;" cstateprov="u&a
                 <record czip="u&apos;60008&apos;"  
ctimezonediff="u&apos;+6&apos;" cstateprov="u&a
                 <record czip="u&apos;60009&apos;"  
ctimezonediff="u&apos;+6&apos;" cstateprov="u&a
                 <record czip="u&apos;60010&apos;"  
ctimezonediff="u&apos;+6&apos;" cstateprov="u&a
                 <record czip="u&apos;60011&apos;"  
ctimezonediff="u&apos;+6&apos;" cstateprov="u&a
         </TestCursor>

        That's the XML, with all the escaping. Basically, though, a record  
is a dictionary with column names for keys and column values for  
values. A cursor's dataset consists of a tuple of such records.

-- Ed Leafe
-- http://leafe.com
-- http://dabodev.com



_______________________________________________
Post Messages to: Dabo-users@leafe.com
Subscription Maintenance: http://leafe.com/mailman/listinfo/dabo-users