2012/2/11 Igor Tandetnik itandet...@mvps.org:
On 2/10/2012 10:52 PM, Rick Guizawa wrote:
Hi All, how do you generate a random number between two numbers in
your query using the random() function? Thank's.
select random() % (:high - :low) + :low;
Igor Tandetnik
sqlite select
Would this be able to run on windows mobile or windows ce?
I don't see why not but I've never used windows mobile or ce and I suppose it
depends on the hardware too.
Maybe I've misunderstood what you are trying to do but it seems to me that
somewhere in the process that gets your data
into
I'm trying to open some Firefox files that are located in the profiles
directory using Sqlite admin
(http://sqliteadmin.orbmu2k.de/).
I'm getting an error message:
Cannot perform this operation on a closed dataset.
I cannot see any security restrictions (Windows 7/64) is the OS.
On Sat, Feb 11, 2012 at 4:56 AM, Christoph Kukulies k...@kukulies.orgwrote:
I'm trying to open some Firefox files that are located in the profiles
directory using Sqlite admin
(http://sqliteadmin.orbmu2k.**de/ http://sqliteadmin.orbmu2k.de/).
I'm getting an error message:
Cannot perform
Here's exactly what I did. You get a different result?
sqlite3 test1.db
create table grocery(a int,b int);
insert into grocery values(1,2);
insert into grocery values(2,3);
.quit
copy test1.db test2.db
copy test1.db test3.db
At this point I have:
02/11/2012 06:53 AM
On Sat, Feb 11, 2012 at 1:56 PM, Christoph Kukulies k...@kukulies.orgwrote:
I'm trying to open some Firefox files that are located in the profiles
directory using Sqlite admin
(http://sqliteadmin.orbmu2k.**de/ http://sqliteadmin.orbmu2k.de/).
I'm getting an error message:
Cannot perform
SQLite is a great database to unit test (TDD) applications. You can run
it in memory with your tests ...
I've found a problem when I was unit testing my application. MySQL
(production database) supports EXTRACT SQL standard function. SQLite
don't support it. It would be great to have support
On 10 Feb 2012, at 3:00pm, Willian Gustavo Veiga wrote:
I've found a problem when I was unit testing my application. MySQL
(production database) supports EXTRACT SQL standard function. SQLite don't
support it. It would be great to have support in this standard.
EXTRACT is /not/ a standard.
On Feb 10, 2012, at 4:00 PM, Willian Gustavo Veiga wrote:
Unfortunately, strftime isn't a solution. It's not a standard.
Unfortunately, extract isn't supported. strtime is what you can use.
___
sqlite-users mailing list
sqlite-users@sqlite.org
2012/2/10 Willian Gustavo Veiga wilt...@gmail.com:
SQLite is a great database to unit test (TDD) applications. You can run it
in memory with your tests ...
I've found a problem when I was unit testing my application. MySQL
(production database) supports EXTRACT SQL standard function. SQLite
10 matches
Mail list logo