Search Results

Search found 4769 results on 191 pages for 'places sqlite'.

Page 25/191 | < Previous Page | 21 22 23 24 25 26 27 28 29 30 31 32  | Next Page >

• Database structure for various items

  - by XGouchet

  I'm building a sqlite database for an android app which will hold a list of items, each of which have different characteristics. Some of the characteristics are available for all objects, some are only relevant for a subset of objects. For example, all my items have a name, a description, an image. Some items will also have an expiration date,…

  Read the article

• What is the traditional way to maintain extensibility in a database-driven application like this?

  - by Jsess

  I'm working on a simple application for a game in Java that allows a user to record whether they have collected a given item and how much experience it contains. This will work for multiple item types (weapons, armor) and each will have its own tab with a list of all items that qualify under it. Making changes as new types are added is not such a…

  Read the article

• Android–Supporting Multiple Devices Part 2

  - by rodelljr

  Originally posted on: http://geekswithblogs.net/rodelljr/archive/2014/06/03/androidsupporting-multiple-devices-part-2.aspxI would like to thank the KC Mobile App Developers group for allowing me to do my presentation; Supporting Multiple Devices Part 2. In this talk, I discussed a Master/Detail application that runs on Android 2.2 devices and…

  Read the article

• Can SQLite file copied successfully on the data folder of an unrooted android device ?

  - by student

  I know that in order to access the data folder on the device, it needs to be rooted. However, if I just want to copy the database from my assets folder to the data folder on my device, will the copying process works on an unrooted phone? The following is my Database Helper class. From logcat, I can verify that the methods call to…

  Read the article

• SQLite dataypes lengths?

  - by XF

  I'm completely new to SQLite (actually 5 minutes ago), but I do know somewhat the Oracle and MySql backends. The question: I'm trying to know the lengths of each of the datatypes supported by SQLite, such as the differences between a bigint and a smallint. I've searched across the SQLite documentation (only talks about affinity,…

  Read the article

• slow network pc opening in network places

  - by Ahsan

  In my network places when i try to open a computer, it opens very slowly, but other pc opens quickly, what can be the cause? kindly help. Thank you.

  Read the article

• Finding places by travel time from start point

  - by Colin Pickard

  Does anyone know of any website or other route planning tool that lets you find places by travel time from a specific point? For example, if my starting point is London, and I drive for 24 hours, what are the major cities I could reach?

  Read the article

• How to manage Places Menu in Ubuntu 9.10

  - by foldswd

  Hi, A bit embarrassing as I thought I knew how to use Ubuntu until I stumble on a basic task! I have named a connection I added to the bookmarks on the Places menu incorrectly and I have no idea how to edit it! Thanks.

  Read the article

• Need database selection advise

  - by jacknad

  I know this is considered a bad question since there is no correct answer, but I need to decide on a database for embedded linux (DaVinci 368 based) hardware and I've never had to produce a design with a database before. Each record will probably contain less than 1000 images with associated alpha-numeric data and the mass…

  Read the article

• Android Card Game Database for Deck Building

  - by Singularity222

  I am making a card game for Android where a player can choose from a selection of cards to build a deck that would contain around 60 cards. Currently, I have the entire database of cards created that the user can browse. The next step is allowing the user to select cards and create a deck with whatever cards they would…

  Read the article

• How should 4 decimals places behave, being simple yet powerful

  - by vener

  I have a UI question that troubled me on the best method to handle 4 decimal places for prices. In an table already cramped full of data, I would want to simplified the interface to make it not so cluttered. The actual current UI is shown below. http://i41.tinypic.com/bg5tub.jpg The problem is, for a unit…

  Read the article

• bind (hardlink) one directory to many places

  - by PoltoS

  I need to "bind" one directory to many chrooted places. I know that I can do "mount -o bind", but this requires special processing on startup each time (run the mount). Is there a way to do it on the filesystem directly? My fs is ext4 and it seems not to support hardlinks to directories. Hardlinking all…

  Read the article

• Foreign key constraints in Android using SQLite? on Delete cascade.

  - by LordSnoutimus

  I have two tables: tracks and waypoints, a track can have many waypoints, but a waypoint is assigned to only 1 track. In the way points table I have a column called "trackidfk" which inserts the track_ID once a track is made, however I have not setup Foreign Key constraints on this column. When I…

  Read the article

• Where to get Native SQLite driver for use in ruby on rails?

  - by Hisham

  Ran my units tests this morning and I get this message. How do I get and install the native driver on osx? The DL driver for sqlite3-ruby is deprecated and will be removed in a future release. Please update your installation to use the Native driver.

  Read the article

• How can I write query to output this format in SQLite?

  - by GivenPie

  I would like to output in this format: e.EE_id e.FNAME e.LNAME SUPer_id s.FNAME s.LNAME --- --------- -------------- --- ------------- ------------------- 1 Ziqiao Li 2 Charlie Li 1 Ziqiao Li 3 George Pee 2 Charlie Li 4 Jason Dee 2 Charlie Li 5 …

  Read the article

• Will a multi column PRIMARY KEY create a multi column INDEX in SQLite?

  - by Derk

  When creating a table with a multi column PRIMARY KEY like this, CREATE TABLE t (a, b, PRIMARY KEY(a, b)) will it create a compound index that behaves the same as it would when indexed like this? CREATE INDEX i ON t (a, b)

  Read the article

• Refining data stored in SQLite - how to join several contacts?

  - by Krab

  Problem background Imagine this problem. You have a water molecule which is in contact with other molecules (if the contact is a hydrogen bond, there can be 4 other molecules around my water). Like in the following picture (A, B, C, D are some other atoms and dots mean the contact). A B . . …

  Read the article

• Add not null DateTime column to SQLite without default value?

  - by acidzombie24

  It looks like i cant add a not null constraint or remove a default constraint. I would like to add a datetime column to a table and have all the values set to anything (perhaps 1970 or year 2000) but it seems like i cant use not null without a default and i cant remove a default once added in. So…

  Read the article

• Any tool to convert SQLite database to sql server?

  - by Aseem Gautam

  DBConvert is one such tool I know. Any open source or any other product?

  Read the article

• Why does SQLite take such a long time to fetch the data?

  - by Derk

  I have two possible queries, both giving the result set I want. Query one takes about 30ms, but 150ms to fetch the data from the database. SELECT id FROM featurevalues as featval3 WHERE featval3.feature IN (?,?,?,?) AND EXISTS ( SELECT 1 FROM …

  Read the article

• How to insert a SQLite record with a datetime set to 'now' in Android application?

  - by droidguy

  Say, we have a table created as: create table notes (_id integer primary key autoincrement, created_date date) To insert a record, I'd use ContentValues initialValues = new ContentValues(); initialValues.put("date_created", ""); long rowId = mDb.insert(DATABASE_TABLE, null,…

  Read the article

• is there a limit to the size of a sqlite database ?

  - by asksuperuser

  I have read their limits faq, they talk about many limits except limit of the whole database.

  Read the article

• How to merge existing row with new data in SQLite?

  - by CSharperWithJava

  I have a database full of simple note data, with columns for title, due date, priority, and details. There is also a _id column PRIMARY KEY int. Say I have a note in the table already with some data filled and the rest null. I also have a set of data that will fill all those…

  Read the article

• Want to store profiles in Qt, use SQLite or something else?

  - by Pirate for Profit

  I want to store some settings for different profiles of what a "task" does. I know in .NET there's a nice ORM is there something like that or an Active Record or whatever? I know writing a bunch of SQL will be fun

  Read the article

• How select data from SQLite table where date = week of year?

  - by vovaxo

  I have table expense: "create table " + Expense.TABLE_NAME + "(" + Expense.ID + " integer primary key autoincrement not null, " + Expense.CATEGORY_ID + " integer, " + Expense.ITEM + " text, " + Expense.PRICE + "…

  Read the article

< Previous Page | 21 22 23 24 25 26 27 28 29 30 31 32  | Next Page >