Next Issue

[Bart Pietercil]

but, but don't you love us any more then ???

LOL

Bart


On 28 Jan 2013, at 21:28, jda <jda at his.com> wrote:

> 
> Hi Ruslan,
> 
> I wish I'd never shown my code...
> 
> Trust me, I need it for what I'm doing in my app (and it's not worth my time or yours to go through it).
> 
> Somebody, next issue, please!
> 
> Jon
> Sonny Software
> 
> 
>> Hi Jon,
>> 
>> But 
>> 
>>   SELECT * FROM T
>> 
>> Selects all records. No need for
>> WHERE RecID <> 0
>> 
>> Sometimes we have show tip to select NONE records as
>>   SELECT * FROM T WHERE FALSE;
>> 
>> So by idea 
>> 
>>    select * 
>>   from myTable 
>>   where recID <> 0
>>   order by creation_dt desc limit 20
>> 
>> Is same as
>> 
>>   select * 
>>   from myTable 
>>   order by creation_dt desc limit 20
>> 
>> 
>>> Hi,
>>> 
>>> Because I need to select all records (and as you say, you can't get a recID of
>>> 0) and then sort them. As I said, this is a peculiarity of the UI I'm using,
>>> nothing for anyone else to concern themselves about. The code you suggested
>>> works just fine without the WHERE.
>>> 
>>> Jon
>>> 
>>> 
>>> Hi Jon,
>>> 
>>> glad you worked it out;
>>> However, how is it possible that you get Recid = 0 in a Valentina DB ???
>>> Otherwise put why do you do recid <> 0 ?
>> 
>> -- 
>> Best regards,
>> 
>> Ruslan Zasukhin
>> VP Engineering and New Technology
>> Paradigma Software, Inc
>> 
>> Valentina - Joining Worlds of Information
>> http://www.paradigmasoft.com
>> 
>> [I feel the need: the need for speed]
>> 
>> 
>> _______________________________________________
>> Valentina mailing list
>> Valentina at lists.macserve.net
>> http://lists.macserve.net/mailman/listinfo/valentina
> 
> _______________________________________________
> Valentina mailing list
> Valentina at lists.macserve.net
> http://lists.macserve.net/mailman/listinfo/valentina