On Mon, 24 Mar 2008 01:53:27 -0700, Sarah Reichelt wrote:
> Check out the docs for the revDataFromQuery function which I think
> will do what you want in a lot less code.
>
> I think your script can be condensed to:
>
> put revOpenDatabase("ODBC","testdb",,,) into myDB
> put "SELECT Item Id, Item Title from Item" into tSQL
> revDataFromQuery(tab,return,myDB,tSQL) into fld "Item List"
>
> Cheers,
> SarahSource: http://www.mail-archive.com/[email protected]/msg104599.html First of all, when I need database tips, I search the list for "Sarah Reichelt" because well... SHE'S AWESOME! I have been using the above 3 lines very successfully in Rev 3.0 for accessing a Microsoft SQL database via ODBC. I remember having to keep up with a connection id in the past, and closing the database when done. Is that still required when using the above method to retrieve a record? What happens if connections are left open? Roger Eller <[email protected]> _______________________________________________ use-revolution mailing list [email protected] Please visit this url to subscribe, unsubscribe and manage your subscription preferences: http://lists.runrev.com/mailman/listinfo/use-revolution
