I am using Ruby on Rails in NetBeans 6.7.1 under windows, and I'm trying to use SQLite3. I've installed the windows version of sqlite3-ruby, and I've placed sqlite3.def, sqlite3.dll and sqlite3.exe in NetBeans6.7.1>ruby2>jruby-1.2.0>bin When I try to run the db:create rake task, I get the error and trace shown below. Can anyone help pl...
I know how to execute single statements, but is their a way to execute a block of statements in some easy way. I just want to delete a column from a table. BEGIN TRANSACTION; CREATE TEMPORARY TABLE t1_backup(a,b); INSERT INTO t1_backup SELECT a,b FROM t1; DROP TABLE t1; CREATE TABLE t1(a,b); INSERT INTO t1 SELECT a,b FROM t1_backup; DRO...
Hi, I have a requirement wherein I need a list of all the contacts that are edited/changed. As per the Android documentation, _SYNC_DIRTY will be set every time a contact is edited. But, there seems to be a bug in this, which makes this always set to 1 (no matter what), even is we explicitly set it to 0. So, I was wondering if I c...
hi people! well, I have problems with my queries,i dont know why!! please help i try to select an id from a table named moneda and I give the name like parameter, this is my method with my query : -(int)ConsultaIdMoneda:(NSString*) nombreMonedaParametro { int idMonedaObtenido; NSLog(@" entre a consultar id de la moneda desde...
Hi all, May be its a silly question but I am a bit confused in it, I want to bind a character into sqlite database (neither as varchar, nor as text but as character only) Hence we can not use sqlite3_bind_text(insertStmt, 1, @"A", -1, SQLITE_TRANSIENT); So should I use sqlite_bind_int(insertStmt,1,65); or there is a better way t...
I want to create and manage a database with images and or audio clips. I know it's not the best idea and I know there are better options, but it's the easiest way to have the data separate from the programming and I'm not the one writing the code. So I need an application that will allow me to edit the database that the application is ...
Hi, I've got a problem that I just can't nail an answer to. Basically I want to retrieve a specific column for the last entry in the SQL database. I've got this so far but it never goes into the last if statement and thus I never get an answer. -(int) retrieveLastNumberDrawn { if(detailStmt == nil) { const char *sql = "Select Num...
I have a query as follows. select strftime('%Y-%m',A.traDate) as Month,sum(A.TraAmt) as Total,C.GroupType from TransactionTbl A left join TransactionCategory B on A.CategoryID = B.CategoryID left join CategoryGroup C on B.CatGRoupID=C.CatGRoupID where A.UserID=1 and A.ProfileID=1 and date(A.TraDate) between date('2009-12-01') and dat...
Hey All, Using an example from the Python DOCs: stocks = [('2006-03-28', 'BUY', 'IBM', 1000, 45.00), ('2006-04-05', 'BUY', 'MSOFT', 1000, 72.00), ('2006-04-06', 'SELL', 'IBM', 500, 53.00), ]: for t in stocks c.execute('insert into stocks values (?,?,?,?,?)', t) In my code, the stocks from above is g...
Hey, I'm working with sqlite3 for the first time, and cannot get it to properly check a file before it opens it. So far, sqlite always returns OK on any file. Also, the file name is a variable returned from the GTK file chooser. It returns an absolute path, I'm guessing this is not a problem. Thanks for any help. This is a snippet of...
Hi, In my Iphone App I have created this query: "SELECT * FROM visuel where id_visuel = 1" And so I have this function that works very well: - (void)getVisuel { visuelArray = [[NSMutableArray alloc] init]; sqlite3 *database; if(sqlite3_open([self.databasePath UTF8String], while(sqlite3_step(getVisuelParcSt...
Documentation states that there is a command-line shell for sqlite3: "To start the sqlite3 program, just type "sqlite3" followed by the name the file that holds the SQLite database." When I try this, in the Windows Command Prompt I get the error message "'sqlite3' is not recognized as an internal or external command, operable program or ...
I have the following table: CREATE TABLE child( id INTEGER PRIMARY KEY, parent_id INTEGER CONSTRAINT parent_id REFERENCES parent(id), description TEXT); How do I drop the constraint? sqlite> ... ? ...
I have a simple django app that is using only the admin. This is the model as is now in the server: from django.db import models class School(models.Model): school = models.CharField(max_length=200) def __unicode__(self): return self.school class Lawyer(models.Model): first = models.CharField(max_length=20) ...
I'm using GTK+ and SQLite as a front end for a small database program, and I cannot get SQLite to properly detect file type on open. Not matter what is opened, it returns SQLITE_OK. I tried sqlite3_open and sqlite3_open_v2, the problem still persists. The output is always the same, regardless of what filetype is opened: /home/shawn/P...
Hi all together, I'm pretty new to iphone development. Anyhow I've searched now for 1,5 hrs to find a possibility/tutorial or whatsoever to add a UISearchBar (it's already added to the RootViewController.XIB). There are a lot of Tutos describing how to connect an Array to a UISearchBar. What I would like to do is connect my already w...
I have data stored in a sqlite3 database and have several places that I read and write data to and from the database. The problem I am running into is that if the SQL statement gets to be very long the sqlite3_prepare_v2 method returns an error. This code works: NSString *strSQL = @"UPDATE commandList SET displayName=?, type=?, formula...
I need to create a configuration file from a data file that looks as follows: MAN1_TIME '01-JAN-2010 00:00:00.0000 UTC' MAN1_RX 123.45 MAN1_RY 123.45 MAN1_RZ 123.45 MAN1_NEXT 'MAN2' MAN2_TIME '01-MAR-2010 00:00:00.0000 UTC' MAN2_RX 123.45 [...] MAN2_NEXT 'MANX' [...] MANX_TIME [...] This file describes different "legs" of a trajectory...
I want to provide a setup feature in my next project and I'm wondering if it's possible to create a SQLite 3 database from scratch with PDO or I'm just stuck at connecting to existing databases via DSN? If it isn't possible with PDO is there any way to create a new DB via PHP? ...
Hi, I hava a sqlite3 database placed in the documents folder. I need to sync this database with the sql server 2005, which is running at our server. Is there a possibility that i can do a Replication between a sqlite3 database and a MSSql server 2005. -- Regards, Syed Yusuf ...