revdb error using record set (AltSQLite)

[chris bohnert]

David,

I simplified salient revdb api portions of your sample to:

 put revdb_query(tconnectionid,"select * from tax1") into tRS
 put revdb_columncount(tRS) into k
 repeat with i = 1 to k
     put revdb_columnByNumber(tRS,i) after field field1
 end repeat

the table tax1 has three columns with serveral rows.  No errors or crashes.

You might try setting a breakpoint before the repeat structure so you 
can step through the column access in the recordset.  If you still have 
trouble feel free to send me a sample off list and i'll take  a look at it.

--
cb


David Vaughan wrote:

> Using a licenced AltSQLite as the database, I created a record set  
> and endeavoured to extract data using the following code (some error  
> checking and other irrelevant pieces omitted from both fragments):
>
> handler 1
>   get revdb_query(gConn,"SELECT * FROM taxl")
>   put it into p
>   set the cursors of this stack to p
>   get revdb_moveFirst(p)
>   newRecDisplay
>
> on newRecDisplay
>   put the cursors of this stack into p
>   put revdb_columncount(p) into k
>   repeat with i = 1 to k
>     put revdb_columnByNumber(p,i) into field i
>   end repeat
>
> The code executes but at first put something like "revdberr, invalid  
> column  number" into each field but now pretty consistently just  
> crashes Rev.
>
> The database is open and a few rows of data exist in it with three  
> columns, fully populated, in each row. I can see that data using  
> revdb_queryList() so one option is to switch away from using the  
> cursor structure and just manage the returned data in variables  
> myself. Before making that move, I would like to know if I have made  
> a mistake in this code or have encountered a bug in the RR wrappers  
> or in AltSQLite.
>
> I added revdb_moveFirst() in the first handler, as a trial fix  
> although I expect that the cursor would automatically be pointing to  
> the first record.
>
> thanks
> David
> _______________________________________________
> use-revolution mailing list
> use-revolution at lists.runrev.com
> Please visit this url to subscribe, unsubscribe and manage your 
> subscription preferences:
> http://lists.runrev.com/mailman/listinfo/use-revolution
>
>
>