Next Issue

[jda]

:-)


> 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
> 
> _______________________________________________
> Valentina mailing list
> Valentina at lists.macserve.net
> http://lists.macserve.net/mailman/listinfo/valentina