Re: [sqlite] I'm trying to figure out how to ...

You cannot do any of these things in any relational database. You can only do this in navigational databases. There are various kludges which permit you to simulate navigational abilities on top of relational databases, but they are all kludges which are performed by various forms of fakery

[sqlite] I'm trying to figure out how to ...

I'm racking my brain trying to figure out how to get directly to the last item in a (potentially) sorted or ordered table. At least oe of the tables will be ordered by a name and a date, so uising the rtowid won't work. Also, how to traverse a table or cursor in a reverse direction. Going

Re: [sqlite] Divide by 0 not giving error

Hi, Von: Jean-Christophe Deschamps > > > This would means that if ever an SQL statement encounters divide by > > > zero, the application will crash with no way handle the situation > > > gracefully, nor to locate the source of the problem. > > > >Seriously, what are you talking about? Why is