Re: [sqlite] A proposal for SQLite version 3.0

[Andrew Francis]

I have an application which depends on INTEGER PRIMARY KEY values 
fitting into 32 bits.

I know that currently, the keys are generated with MAX()+1, but this 
behaviour is "undocumented and liable to change.: Now that rowid's are 
going 64 bit, a truly random INTEGER PRIMARY KEY may not fit into 32 bits.

Could we please see the current behaviour set in stone? I'd like to know 
that generated keys will always fit into 32 bits (provided I don't 
exceed ~4.3 billion records, naturally).

Thanks

--
Andrew Francis
Lead Developer
Family Health Network
-
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]

Re: [sqlite] SQLite for Win32 TCHAR

[Andrew Francis]

Michael Smith wrote:

Has anyone ported the SQLite code to support the Win32 TCHAR type and API?
I'll confess I'm not actually sure what you mean by "ported" - do you 
mean using TCHAR (which is, btw, just a typedef for char or short 
depending on whether UNICODE is #define'd) in the sqlite library 
interface, or using TCHAR for Win32 calls?

Regardless, I'd start by looking at the sqlite ports to Windows CE / 
PocketPC. From memory, there are a couple around. Windows CE provides 
only Unicode versions of the Win32 functions, so generally WinCE code 
has to be TCHAR/Unicode 'clean.'

--
Andrew Francis
Software Developer
Family Health Software
-
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]