330 Topics
 | |
 | Was wondering if anyone could recommend both free and not free report generator programs for use with SQlite. I'll need charts, colours and the ability to generate some pretty flexible reports. Any suggestions? Thanks danny2000  |
| | I use mediaportal as my mediacenter, with this I use the plugin mvcentral for my music videos. This generates .db3 file, what I want to do is create a .net interface to view this file, with the intention of making it into an exe to have a portal database of …  |
| | The problem is, when I load a particular page (user.php) the session variable not work. But on the other pages it works fine. Even in my local host user.php also works fine. Only user.php on remote server is occuring this problem. This is login script <?php require_once 'inc/functions.php'; require_once 'inc/mysql_cnct.php'; … |
| | Does anyone knows how to assigned directly the sqlite query result to a struct in C rather that assigning to its members one by one? I have a table user_info with fields user_id, username, password. Also I have a struct st_user_info. typedef struct st_user_info{ int userId; char* userName; char* password; …  |
| | Hello there Quick insight of what im trying to achieve here is. User adds data to a database called property in (addproperty.php) Then user can search for specific data in that property database Here is the code addproperty.php [CODE]<?php $dbhandle = sqlite_popen("property", 0666, $err_msg); if(!$dbhandle) die("Could not open the database"); … |
| | Is anyone aware of how to silently install this application on windows? (sqliteodbc.exe) I can't find it anywhere, and yet it seems like such an important feature to have. I've tried the usual /?, /help etc, but to no avail. Regards |
| | I had my iPhone app working, developed with Storyboard. I decided to take all of the methods that belonged in a SQLite method and move them to a new SQLite class (.h and .m). Now I have errors that I can't seem to get rid of. The basic problem is …  |
 | hi friends . i have a sqlite program. i need get stuff data from QLineEdit and add to model & tableView . but i dont know what should I do :( plz help me  |
| | Okay, been working on Android program and since its JAVA based, I figured this might be a place to get some good advice. I have been writing this program to run tcpdump, but for some reason it freezes and crashes. I am able to execute the shell commands, but after … |
| | Basically I'm trying to create an app where it generates random questions and displays them in a dialog box. I've managed to create a dialog box ok but incorporating the sql database full of questions and answers is proving difficult. I've been trying to follow this tutorial and it's the … |
| | I am pretty new in android application development and I am trying to get on of the rows from a SQLite db to show up as a Listactivity, but this is not working and the program terminates unexpectedly. Here is the code: [CODE]package ankur.test.app; import android.app.ListActivity; import android.content.Intent; import android.os.Bundle; … |
| | Hi Guys! I'm new to the forum and I have a doubt. Who can help me, I thank you. This is a simple GUI .. formed by a simple table. How do I connect to a database file. Db so that is shown in table QtGui? I'm using SQLite in … |
| | i am doing a project for a mobile apps class and i am about 80% done. all the UI is complete, but i need to have a filled out form stored into a db. i used the core data model to set up all the entities/attributes, i just cannot figure …  |
| | I have this code that creates gets the data from a sqlite3 database and prints it out in a table with checkboxes next to each row to check to delete that row. After deleting a row I want to update the data base so that the id of the rows … |
| | Hello everybody i'am building a software to make lab management. So I need to save the data base. and i using SQLite. but I have problem the SQLite pramter is a const char. and the data from the software are CString. and becouse I using Unicode I can't convert them … |
| | get error cannot find table although database already in correct path!. I also already put [B]SQLite.Interop.dll[/B] on my project file |
| | Hi, Is there any tool available to convert sql CE db (*.sdf) file to SQLITE db?. I got some from code project but it converts only SQL Server DB. -anoop |
| | I have a form and php code to register a user. It's not complete, but right now I'm trying to get the insert query to work and put the data entered from the form into the sqlite database. I've tried entering the data by puting the form variables in the … |
| | I have the registration form and everything seems to work good except when I try to insert the data into the table from the query in the php code. It will submit, but when i check the database the data is not in there. I tried multiple ways, but none … |
 | Is it possible to export MySQL database to SQLite? If possible, how do you do that? |
| | hi i'm having some trouble with web2py models: [CODE]# -*- coding: utf-8 -*- db = DAL("sqlite://storage.sqlite") from gluon.tools import Crud crud = Crud(db) db.define_table("shout", Field("author", "string"), Field("shout","text")) db.shout.shout.requires = IS_NOT_EMPTY [/CODE] (there is more but it is for the admin interface) It is all correct but I get this error: … |
| | Hey, I am wondering if it is possible to transfer data from one database to another e.g. from a SQLlite database to a mySql database. I know they are different type and styles of database. The SQLlite database would be stored on android phone and mySQL seperatly on a appropriated … |
| | I am making a quick program to get basic database functions working before i create a larger app but my application keeps force closing when i try and read from the database. I am an amature at android programming and im just starting out. Does anyone know what is wrong? … |
| | We have a web based application in which users can give orders to their supplier. This process consists of login to the application, selecting supplier, get the products for the supplier, and select the products, key in order delivery date and comments. This process has 4, 5 steps (4, 5 … |
| | Hi, In the past few months I've been learning how to make applications for android by making small games just for the fun of it. I am stuck at the moment at the database object I created to manage the database, specifically the cursor: it won't close. A snippet of … |
 | I am trying to create an app to enter records into a database (SQLite) which includes an option field with data selected from a drop-down list box or Spinner. I can create the Spinner from a string array input from Strings.xml but I want to make the data 'user editable,' … |
 | hey there, I am trying to build a small around soccer/football matches. So, I have built a class that models a Match (Match.java). It only contains field variables like hostid, guestid, matchid, result, and such, and setter and getter methods. When I retrieve matches from my sqlite database, I build … |
| | i have a script for greenstone applciation mkcol.pl here it is: [CODE]#!/usr/bin/perl -w ########################################################################### # # mkcol.pl -- # A component of the Greenstone digital library software # from the New Zealand Digital Library Project at the # University of Waikato, New Zealand. # # Copyright (C) 1999 New Zealand … |
| | hi all, i just started practicing android and sqlite database. i came across a very strange problem which i am unable to rectify.kindly help me out. Below i have out my DataBaseHelper class. (Description follows after the code block...) [CODE=java] package com.dialog.test; import java.io.FileOutputStream; import java.io.IOException; import java.io.InputStream; import java.io.OutputStream; … |
| | Hi all, I am beginner in android and, My question is i want to know where my SQLite database physically reside in my system when i create it as [code] SQLiteDatabase db = openOrCreateDatabase("MyDB1", Context.MODE_PRIVATE, null); db.execSQL("CREATE TABLE IF NOT EXISTS MyTable(LName TEXT,FName TEXT,No INTEGER PRIMARY KEY);"); db.execSQL("INSERT INTO MyTable(No) … |
| | Hi everyone, I'm new here so I hope I've put this in the right place. I'm looking for a little help with a python program I've written. I'm trying to create a timeline from SQLite databases. I take information from a calls database, then an sms database, write those to … |
 | I am having trouble structuring an sqlite update statement that has multiple parameters. The following code does not raise an exception, but nor does it update my table. After extensive googling and searching Daniweb, I think I'm looking right at the blindingly obvious and missing it. I have a list … |
| | This is code for an internal forum, it works on my local server, but not the godaddy one i just purchased! phpinfo()s posted below: [CODE]<?php // forum.php :: Foro interno del juego.Version 1.0 define('INSIDE' , true); define('INSTALL' , false); require_once dirname(__FILE__) .'/common.php'; /* Este foro esta basado en el PHPBBs …  |
| | Hi All, Sorry if this annoyed any of you. but I'm really indeed. I need to know on HOW TO LOAD 300 RECORDS OR DATA PER SECOND in my mobile apps (for this purpose, I use iOS app). I just need a sample or basic code on how to run … |
| | Hello, colleagues, Greetings I'm developing this code but I have problems on the part of a database query look at the full function code in which I have problems other than data base is [CODE]import sqlite3 as lite con = lite.connect('MiBase.sqlite') c = con.cursor() c.execute("""create table inventario (codigo real, producto … |
| | HI all, I am not c++ expert. Just a beginner. I have few requirements to design the pattern. Simple requirement is 1) i have a table in sqlite say T1 with ( name, version ) 2) I daemon which has is watching specific directory with inotification for the event IN_CLOSE_WRITE. … |
| | Hi. I have a problem that I am tearing my hair out to solve. I am trying to transfer tens of thousands of records into a sqlite db using the script below. The script seems to run okay and I can see the db growing as it runs to some … |
| | I have 2 images, one is supposed to be on top of the other. This works fine until one of the "movement" keys are hit (a,s,d,w) [CODE]import sqlite3 as sqlite import wx username=None class MainWindow(): def drawmap(self): self.map4_31="C:/python27/game/4_31.gif" self.map1=wx.Image(self.map4_31,wx.BITMAP_TYPE_GIF).ConvertToBitmap() height=self.map1.GetHeight() width=self.map1.GetWidth() self.map1.map4_31 = wx.StaticBitmap(frame, -1, self.map1, (270, 170), (width,height)) def … |
 | Hi, I've posted two scripts that I would like to improve. The first one (SparePartsDemo.py) is a little utility that takes a .csv (.txt) data file exported from another application, builds a SQLite database,performs a request to select and sort records and write the results to a sqlite database file, … |
| | Hi,i am looking for a light relational database server with the ability to recover after a crash.I am not looking for sqlite or any other single file db system. |
| | Hey. I keep getting AVG popping up with a message that tells me that cookies.sqlite in the Firefox folder of my Document and Settings, within Application Data, folder is infected. I've followed the sticky and here are the results: Malwarebytes' Anti-Malware 1.46 [url]www.malwarebytes.org[/url] Database version: 4052 Windows 5.1.2600 Service Pack …  |
| | Hi gang ; The code below works fine but a more flexible one would be better. For example what am looking for an original try-throw-cath block which throws the exception "Item not found" message itself. try { SQLiteConnection ^connection = gcnew SQLiteConnection(); connection->ConnectionString = "Data Source = atbdn3.db3"; connection->Open(); System::String …  |
| | Hi, Am new to here, and i cam here with problem that can be easily solved by you guys, Please help me out. I have got sqlite3 db dump as dbname.db3, So then i tried to connect this sqllite from php. Here is my sample code which i got it … |
 | Hi there, my name is Stéphane, i'm french and a beginner with Python... I've registered on a french forum about Python to ask a question regarding an issue i have with a code, but it seems the members of this forum are not active. I paste the message i posted … |
 | I am trying to understand using an SQLite database in Python and can grasp running queries, but would like to understand how to populate Python variables from SQLite fields. Here is my sample Python code: [CODE]import sqlite3 id = 0 name = "" occupation = "" location = "" connection …  |
| | A bit of background: I've been working on a python script to do some calculations on a land use model. Basically, I take amount of space developed in the future and pull out a table that has the amount of space by geographic area within the larger area. I load … |
| | Hi :) I am writing an admin application for a website I've written. It's a basic database update/insert/delete app. I started by using the website's server, but the time it took to connect to the server (since the main JTable is populated from the db, you have to wait for … |
| | :( hi, i am beginner in python and i am getting one error sql =cursor.execute("INSERT INTO main12 VALUES('self.temp','self.entry2')") sqlite3.IntegrityError: column num is not unique while entering two value from text box to my database main12 where i hav only 2 fields num and time .i first create tool.sqlite and then … |
| | I can find a lot of information about the concepts of normalization, but I don't really see documentation for how to actually bring a table, for example, from first normal form to second normal form. I'm using SQLite through Python to automate some data processing, and I have three input … |
| | I'm writing an inventory program for my uncle's warehouse, which has never been counted in 20 years. (yea it's taking me a week so far and still counting parts) I want the program to be serverless and just run on his laptop (which I'm still fixing also). I thought of …  |
The End.