Search Results

Search found 536 results on 22 pages for 'sqlite3'.

Page 9/22 | < Previous Page | 5 6 7 8 9 10 11 12 13 14 15 16  | Next Page >

• Is there a boolean literal in SQLite?

  - by Benjamin Oakes

  I know about the boolean column type, but is there a boolean literal in SQLite? In other languages, this might be true or false. Obviously, I can use 0 and 1, but I tend to avoid so-called "magic numbers" where possible. From this list, it seems like it might exist in other SQL implementations, but not SQLite. (I'm using SQLite 3.6.10, for what…

  Read the article

• Handling national language prefix for checkconstraints

  - by Chris Chilvers

  I'm trying to create a check constraint such as CHECK Type IN (N'Create', N'Remove') for an enumeration's value. Sqlite complains about this syntax and only accepts CHECK Type IN ('Create', 'Remove'). The main database will be Sql Server 2005, but I use sqlite's in memory database for unit tests. Is there any way to get sqlite to recognise the…

  Read the article

• Will pool the connection help threading in sqlite (and how)?

  - by mamcx

  I currently use a singleton to acces my database (see related question) but now when try to add some background processing everything fall apart. I read the sqlite docs and found that sqlite could work thread-safe, but each thread must have their own db connection. I try using egodatabase that promise a sqlite wrapper with thread safety but is…

  Read the article

• how to connect with sqlite in iphone?

  - by vijaya-reddy

  Hi... I am developing an application in iphone and am new to iphone. Kindly let me know the code for open/close/update/delete database record in iphone using sqlite? Regards, Vijaya

  Read the article

• SELECT INTO statement in sqlite.

  - by monish

  HI Guys, Here I a wanna know that whether sqlite supports SELECT INTO statement. Actually I am trying to save the data in my table1 into table2 as a backup of my database before modifying the data. for that when I am using the SELECT INTO Statement a syntax error was generating as: My query as: SELECT * INTO equipments_backup FROM…

  Read the article

• Django queries Especial Caracters

  - by Jorge Machado

  Hi, I Working on location from google maps and using django to. My question is: I have a String in request.GET['descricao'] lets say it contains "Via rapida". In my database i have store = "Via Rápida" i'm doing : local = Local.objects.filter(name__icontains=request.GET['descricao']) with that i can get everthing fine like "Via…

  Read the article

• Reference platform specific System.Data.SQLite

  - by Dmitriy Nagirnyak

  I am using SQLite for the unit testing and might use it as a database for local development/staging. The System.Data.SQLite has basically 2 versions: x86 and x64. Correct one should be used for the specific platform. I have 64 bit Win7, other guys in the team might use 32-bit OSs. The server's platform is not known at this stage. If…

  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…

  Read the article

• Prevent sqlite INJECTION ATTACKS on your own iPhone?

  - by Bonnie

  I always take precautions regarding SQL INJECTION ATTACKS when data is saved between someone's iPhone and a remote database on the cloud. But is it also necessary to do the same... when just saving data (using sqlite) from someone's cell phone, to a database that's just on their own phone? What's the worse they can do? Delete their…

  Read the article

• Making a sqlite file stay existent between runs of the program

  - by Cocorico

  Hi! I'm having a problem with some sqlite code for an iPhone program in Xcode. I was opening my database like this: int result = sqlite3_open("stealtown.db", &database); Which is how they had it in a book I was looking at while I type the program. But then, that way of opening a database it only works when you run in simulator,…

  Read the article

• Unable to retrieve data from SQLite database iOS6.0

  - by kunalg

  When i run build ios5.0 or less then Sqlite response correct and retrieve data its work fine but when run on ios6.0 i am trying to fetch data from my.sqlite database but it is not executing my if case. It always enters in else condition. What wrong thing i am doing? I am not able to execute my if case i.e.…

  Read the article

• Implementing a 1 to many relationship with SQLite

  - by Patrick

  I have the following schema implemented successfully in my application. The application connects desk unit channels to IO unit channels. The DeskUnits and IOUnits tables are basically just a list of desk/IO units and the number of channels on each. For example a desk could be 4 or 12 channel. CREATE TABLE…

  Read the article

• Password check from the database, what am I doing wrong ???

  - by user271753

  -(IBAction)EnterButtonPressed:(id)sender { const char *sql = "SELECT AccessCode FROM UserAccess"; double result = ([Password.text doubleValue]); if(sql == result ) { NSLog(@"Correct"); } else { NSLog(@"Wrong"); } }

  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…

  Read the article

• Appropriate C# command for ADO.NET SQlite when implementing COUNT() query

  - by Soham

  Hi All, Consider this command, as written here: Command.CommandText = "SELECT COUNT(ASSET) AS POSEXISTS FROM POSITIONS WHERE ASSET = @ASSET"; Command.Parameters.Add("@ASSET",DbType.String).Value = Symbol; So here, how should I execute this query so that, I can receive the POSEXISTS variable…

  Read the article

• Why is PHP5 SQLite PDO silently failing on DB connection?

  - by danieltalsky

  I have no idea why my code is failing silently. PDO and PDO SQLite are confirmed loaded. Errors are turned on and OTHER errors display. The SQLite file exists. Perms are set correctly. If I change the filename, PHP actually DOES create the file but still fails silently. No output or commands are…

  Read the article

• SQLite Databases and Grid Hosting

  - by jocull

  I'm considering moving my site from a GoDaddy shared hosting account to a Media Temple grid hosting account in anticipation of traffic. However, I first have some concerns with the grid hosting setup. My site stores a large personal set of data on a per-user basis (possibly 3-4MB per user). At this…

  Read the article

• Connecting sqlite database

  - by user358171

  Ive seen tutorials after tutorials but i still dont get how to connect a database to my xcode.. i already put it in my reference, put the sqlite framework but still it doesnt work.. i even tried copying the whole code the tutorial offers but still my iphone simulator turns up blank.. can you please…

  Read the article

• C# Finisar SQLite Date Format Problem

  - by Emanuel

  My "task" database table look like this: [title] [content] [start_date] [end_date] [...] [...] [01.06.2010 20:10:36] [06.06.2010 20:10:36] [...] [...] [05.06.2010 20:10:36] [06.06.2010 20:10:36] And I want to find only those records that meet the condition that a given day is between start_date…

  Read the article

• Nested joins hide table names

  - by Sergio

  Hi: I have three tables: Suppliers, Parts and Types. I need to join all of them while discriminating columns with the same name (say, "id") in the three tables. I would like to successfully run this query: CREATE VIEW Everything AS SELECT Suppliers.name as supplier, Parts.id, Parts.description,…

  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

• Android SQLiteConstraintException: error code 19: constraint failed

  - by Tom D

  I've seen other questions about this exception, but all of them seem to be resolved with the solution that a row with the primary key specified already exists. This doesn't seem to be the case for me. I have tried replacing all single quotes in my strings with double quotes, but the same problem…

  Read the article

• Implementation of MVC with SQLite and NSURLConnection, use cases?

  - by user324723

  I'm interested in knowing how others have implemented/designed database & web services in their iphone app and how they simplified it for the entire application. My application is dependent on these services and I can't figure out a efficient way to use them together due to the…

  Read the article

• inserted in multiple tables of database at a time

  - by rajkumari

  can we work with multiple tables of database with same connection object of database at same time . suppose i have inserted value in table 1 and at same time also inserted value in table 2 of data base with same object of data base connection. I am using sqlite database in code…

  Read the article

< Previous Page | 5 6 7 8 9 10 11 12 13 14 15 16  | Next Page >