Done.
Diego
On Fri, Jul 23, 2010 at 12:07, Diego Mijelshon <[email protected]>wrote:
> I see... it uses current_timestamp...
>
> I'll use getdate() in SQLCE. I'll update the patch shortly.
>
> Diego
>
>
>
> On Fri, Jul 23, 2010 at 09:50, Fabio Maulo <[email protected]> wrote:
>
>> have a look to MSSQL dialects
>>
>>
>> On Fri, Jul 23, 2010 at 8:46 AM, Diego Mijelshon
>> <[email protected]>wrote:
>>
>>> The idea crossed my mind... but at that point, the input is a SqlString,
>>> so I'd have to know the actual Id column name (i.e. I can't use the
>>> pseudo-property).
>>> One possibility is finding the first member after the SELECT clause,
>>> which should be the Id in non-projection queries. It might be a good
>>> compromise.
>>> Thoughts?
>>>
>>> Diego
>>>
>>>
>>>
>>> On Fri, Jul 23, 2010 at 03:19, Ayende Rahien <[email protected]> wrote:
>>>
>>>> You can check it if has OrderBy and add Order By id?
>>>>
>>>>
>>>> On Fri, Jul 23, 2010 at 12:22 AM, Diego Mijelshon <
>>>> [email protected]> wrote:
>>>>
>>>>> Hi all,
>>>>>
>>>>> I've just created http://216.121.112.228/browse/NH-2252, to support
>>>>> the new paging syntax (if only the full SqlServer supported it...)
>>>>>
>>>>> It's kinda trivial, but I have one concern...
>>>>>
>>>>> This syntax is only valid when there is an ORDER BY clause (which makes
>>>>> sense).
>>>>> SQLCE has a decent error message for it: "OFFSET clause is invalid
>>>>> unless ORDER BY clause is specified."
>>>>>
>>>>> Should we leave that as-is?
>>>>>
>>>>> Diego
>>>>>
>>>>
>>>>
>>>
>>
>>
>> --
>> Fabio Maulo
>>
>>
>