Search Results

Search found 95201 results on 3809 pages for 'system data sqlite'.

Page 18/3809 | < Previous Page | 14 15 16 17 18 19 20 21 22 23 24 25  | Next Page >

• Android SQLite: nullColumnHack parameter in insert/replace methods

  - by poke

  The Android SDK has some convenience methods for manipulating data with SQLite. However both the insert and replace methods use some nullColumnHack parameter which usage I don't understand. The documentation explains it with the following, but what if a table has multiple columns that allow NULL? I really don't get it :/ SQL doesn't allow inserting a completely empty row, so if initialValues is empty this column [/row for replace] will explicitly be assigned a NULL value

  Read the article

• php framework with sqlite, orm, i18n, l10n search addon

  - by ddorian

  im trying to find a php framework to build small,multilingual sites. do you know a php framework with support for: 1.sqlite (it will be little sites so no performance problem and good for copy-paste from development to production) 2.orm 3.i18n & l10n 4.easy search addon 5.ability to just copy-paste no need to change config for going from devel machine to production and if you know cms with those features put it too thank you

  Read the article

• Number of rows returned in a sqlite statement

  - by Christopher Brady

  Is there any easy way to get the number of rows returned by a sqlite statement? I don't want to have to go through the process of doing a COUNT() first. Thanks.

  Read the article

• [Rails] ActiveRecord using Safari Sqlite

  - by Gregory

  Hi, I am build a webapp for iphone using Phonegap, and I want to create a DB on the device and not on my server. I've seen that there is a Safari Sqlite database, but I haven't been able to find any information about using this database with active record. Does someone knows how to do so? Best, Gregory

  Read the article

• how to download update from iphone app to replace old sqlite database

  - by user301212

  hi i use sqlite database on my iphone app and i need to update this database from the internet from my server how i can download the new database and delete the old database and recopy the new database to document directory

  Read the article

• Special Characters from SQLite DB

  - by Matthias

  Hi, I read from a sqlite db to my iphone app. Within the texts sometimes there are special characters like 'xf2' or 'xe0' as I can see in the debugger in the char* data type. When I try to transform the chars to an NSString Object by using initWithUTF8String, I get a nil back. How can I transform such special characters? Thanks for your help. Bye Matthias

  Read the article

• How do I list the tables in a SQLite database file

  - by izb

  What SQL can be used to list the tables, and the rows within those tables, in a SQLite database file once i've ATTACHed it on the sqlite3 command line tool?

  Read the article

• browse data in Android SQLite Database

  - by Justin C

  Is there a way for an Android user to browse the SQLite databases on his/her phone and view the data in the databases? I use the SoftTrace beta program a lot. It's great but has no way that I can find to download the data it tracks to a PC. Thanks

  Read the article

• how to download update from iphone app to sqlite database

  - by user301212

  hi i use sqlite database on my iphone app and i need to update this database from the internet from my server how i can download the new database and delete the old database and recopy the new database to document directory

  Read the article

• SQLite is the CASE statement expensive?

  - by galford13x

  I'm wondering if using a CASE statement in SQLite (or other SQL engines) to replace data is not advised. For example lets say I have a query. SELECT Users, CASE WHEN Active = 0 THEN 'Inactive' WHEN Active = 1 THEN 'Active' WHEN Active = 2 THEN 'Processing' ELSE 'ERROR' AS Active FROM UsersTable; When is it better to create a reference table and perform a JOIN. In this case I would create a Table 'ActiveStatesTable' with ActiveID, ActiveDescription and perform the JOIN.

  Read the article

• Nesting, grouping Sqlite syntax?

  - by Linda

  I can't for the life of me figure out this Sqlite syntax. Our database contains records like: TX, Austin OH, Columbus OH, Columbus TX, Austin OH, Cleveland OH, Dayton OH, Columbus TX, Dallas TX, Houston TX, Austin (State-field and a city-field.) I need output like this: OH: Columbus, Cleveland, Dayton TX: Dallas, Houston, Austin (Each state listed once... and all the cities in that state.) What would the SELECT statement(s) look like?

  Read the article

• Sqlite table constraint - unique on multiple columns

  - by Rich

  I can find syntax "charts" on this on the sqlite website, but no examples and my code is crashing. I have other tables with unique constraints on a single column, but I want to add a constraint to the table on two columns. This is what I have that is causing a SQLiteException with the message "syntax error". CREATE TABLE name (column defs) UNIQUE (col_name1, col_name2) ON CONFLICT REPLACE I'm doing this based on the following: table-constraint

  Read the article

• Dynamically create categories for SQLite pivot/crosstab

  - by alj

  I realise it is possible to create a crosstab within sqlite, but is it possible to dynamically determine the relevant categories/columns at runtime rather than hardcoding them? Given the following example, it can get rather tedious ... SELECT shop_id, sum(CASE WHEN product = 'Fiesta' THEN units END) as Fiesta, sum(CASE WHEN product = 'Focus' THEN units END) as Focus, sum(CASE WHEN product = 'Puma' THEN units END) as Puma, sum(units) AS total FROM sales GROUP BY shop_id I managed to do this in SQLServer in a stored proceedure before and wondered if there was anything equivalent.

  Read the article

• Android browse SQLite database on phone

  - by Chris

  How can I browse the SQLite database that I am creating in my app on my Android myTouch phone? When I log in through adb shell, sqlite3 gives me a permission denied. Is there another way to check if my database and tables are actually being created, and if rows are being inserted? I am not able to use the emulator, since it doesn't play videos etc. very well that is the main feature of my app, so I can only test on phone. Thanks Chris

  Read the article

• SQLite connection pooling with Fluent NHibernate

  - by Groo

  Is there a way to setup SQLite connection pooling using Fluent NHibernate configuration? E.g. equivalent of DataSource=:memory: would be: var sessionFactory = Fluently .Configure() .Database(SQLiteConfiguration.Standard.InMemory) (etc.) Is there something eqivalent to "Pooling=True;Max Pool Size=1;"?

  Read the article

• How do I unlock a SQLite database?

  - by RyanTM

  sqlite> DELETE FROM mails WHERE (`id` = 71); SQL error: database is locked How do I unlock the database so this will work?

  Read the article

• Batch Select Sql in SQLite or SqlCE with C#

  - by David Osborn

  Is there anyway to batch two different select queries to either SQLite or SQLCE and get the two result sets back in C#? If not, is there an embedded database that handles this?

  Read the article

• Conditional SQLite check constraint?

  - by Rezzie

  I have a table defined by the following SQL: CREATE TABLE test ( id integer PRIMARY KEY NOT NULL UNIQUE, status text NOT NULL, enddate date, /* Checks */ CHECK (status IN ("Current", "Complete")) ); I'd like to add a constraint that requires enddate to be non-null if the status is "Complete". Is this possible? I am using SQLite v3.6.16.

  Read the article

• Bind Boolean value in Sqlite

  - by milanjansari

  Hello, Anyone have idea about how to bind Boolean in sqlite with objective - c. i know how to bind int and string but i don't know about boolean value. sqlite3_bind_int(addStmt, 1, id); sqlite3_bind_text(addStmt,3 ,[message UTF8String], -1, SQLITE_TRANSIENT); but how can i bind boolean value. Please help me. Thanks you

  Read the article

• How to insert date in sqlite through java.

  - by dimitar

  Hello guys, I want to make a database that will hold a date in it(SQLite). Now first to ask is what is the right syntax to declare a date column. The second i want to know is how to insert date in it after that. And the third thing i want to know is how to select dates between, for example to select all rows which contain date between 01/05/2010 and 05/06/2010. Thank you

  Read the article

• Version of SQLite used in Android?

  - by Eno

  Reason: Im wondering how to handle schema migrations. The newer SQLite versions support an "ALTER TABLE" SQL command which would save me having to copy data, drop the table, recreate table and re-insert data.

  Read the article

• SQLite vs MySQL

  - by Teifion

  SQLite is a flat-file database and MySQL is a normal database. That's great but I'm not sure which is faster where or better for what? What are the pros and cons of each option?

  Read the article

• Excel/SQLite date serial numbers

  - by John Smith

  How can I get SQLite to accept excel-type serial number dates, e.g. I want to put the integer 40074 in a table and somehow get the date 18 Sept 2009?

  Read the article

• SQLITE Blob OR file system for images

  - by saint cyr

  Hello, I am building an application based on a single table with a column with text. Occassionally, an adjacent column will have an image. Is it better to store this image as a BLOB in SQLITE or should I store them on the file system and reference them from my programs. Thanks!

  Read the article

• Using PRAGMAs as sources in SQLite in getting column names

  - by Paul Nathan

  Problem: I want to do this operation select name from pragma table_info(my_awesome_table) However, it yields a syntax error. I have the sneaking suspicion this is possible, but it doesn't seem to be documented as usable in the SELECT docs with sqlite.

  Read the article

< Previous Page | 14 15 16 17 18 19 20 21 22 23 24 25  | Next Page >