[sqlite] Row shuffling

2004-10-18 Thread Jay Macaulay
and limited. That is, when selecting out I use that ID row to select out say 5000 at a time. So the id field doesn't have to have the same ranges as it did before, in fact they can be completely randomized to any number, but they all have to be unique. Thanks in advance, Jay Macaulay

Re: [sqlite] OT: Reply-To Munging Considered Useful

2004-07-23 Thread Jay Macaulay
ing the Reply-To makes me have to view the mail properties, find the >From email, then type that in. On the other hand, if I wanted to reply to the list before and not to a person directly, all I had to do was hilight the name and delete it. A lot less painful than the other way around IMHO. Jay Macaulay

[sqlite] An update with LIMIT ?

2004-06-11 Thread Jay Macaulay
ddress SET retrieved=1 WHERE group="a" LIMIT 5; So it only updates the same 5 I just selected? I'm trying to select then marked as retrieved. I don't think I can use LIMIT in an UPDATE statements. Any help would be appreciated, Jay Macaulay

Re: [sqlite] re: academic software licensing (delphi)

2004-06-04 Thread Jay Macaulay
> hi- > > i dont think delphi 7 personal edition will work with sqlite (not 100% > sure though). > i believe i need more than a tdataset that works with sqlite to get it > to work with delphi 7 personal edition. > there is an alternative however. http://ibobjects.com seems to be very > generous

[sqlite] Re: [inbox] [sqlite] About ORDER BY results...

2004-02-27 Thread Jay Macaulay
s, at the cost of an extra column. Jay Macaulay - To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]

Re: [sqlite] Concurrency in SQLite

2003-11-24 Thread Jay Macaulay
ctions, which really made me feel like I had to work around the database. Now this was many years ago, but that was one miserable SQL experience that I hope never to repeat. Jay Macaulay - To unsubscribe, e-mail: [EMAIL PROTECTED