General information
Category:
Coding, syntax and commands
Environment versions
Network:
Windows 2008 Server
>>>>It's just a way of combining a GUID and a date to create a 'pseudo' GUID which will order by date. I don't see any reason why it would not work in CE - but there's no point unless you need the ordering. I'd also be concerned that MS might change the way a GUID is constructed in a future version - I think they've already changed it once....
>>>>Best,
>>>>Viv
>>>
>>>Hi Viv,
>>>
>>>CE doesn't support this function, it seems.
>>
>>Which bit are you referring to. It supports GUID's. The rest is just an algorithm to modify it using a date......
>
>I mean I tried changing the GUID field in SQL Server Compact Edition to use NewSequentialID() as default value and it gave me a message that it's wrong function name or something along the lines.
>
>Of course, I could have used the C# algorithm in my code to insert sequential GUID this way.
Ah, I thought we were talking about C# code. I've no idea which subset of SQL syntax is supported by SQL CE...
Previous
Reply
View the map of this thread
View the map of this thread starting from this message only
View all messages of this thread
View all messages of this thread starting from this message only