[sqlite] Forum Topics

This tutorial demonstrates how to build an AI agent that queries SQLite databases using natural language. You will see how to leverage the [LangGraph framework](https://www.langchain.com/langgraph) and the [OpenAI GPT-4o](https://openai.com/index/gpt-4/) model to retrieve natural language answers from an SQLite database, given a natural language query. So, let's begin without ado. ## …

Hi. I have a local installation of SQLite3 and PHP which runs a small in house PHP application so sql injection is not an issue. I am able to execute the following: if(isset($_GET['deletequote'])) { $qno = $_GET['deletequote']; echo $qno;?><br><?php // for testing $db = new SQLite3('./fi_data.db') or die('Cannot delete quote. …

I am trying to come up with an SQL query to return all the records earlier than a certain year with SQLite using DB Browser. I can't seem to come up with the right regex expressipn to use for filtering only the year from a row for comparison, below is …

Helllo guys am trying to build my first ASP.NET application here and I have a **Models** folder and **Controllers** folder. The models folder contains the class for an entity called customer whose properties are to be read from sqlite database. Thee is also a **Pages** folder that contains a folder …

## Introduction ## If your Android Application uses Room, then you might have wondered how to prepopulate a Room database. In this tutorial, we will learn how to prepopulate a Room database. ## Goals ## At the end of the tutorial, you would have learned: 1. How to prepopulate a …

## Introduction ## One of the best debugging tools in Android Studio is the *live database inspector*. It allows developers to peek at the current state of the database and even run queries against it. In this tutorial, we will learn how to use it to debug a local SQLite …

I have a SQLite database that for some insane reason stores dates as the number of days since 1899-12-31. I want to create a view that will display the date as an actual date. I can calculate a specific date from a specific day number as select date('1899-12-31','Localtime','+44386 day') as …

Create the following table using SQLite database The basic building block of the system. Book: Every book will have BookID, BookTitle, Author, ISBN, Publishers. Employee : Every Employee will have EmployeeID, EmployeeName, FatherName, Designation, Salary Student: Every student will have Registration, StudentName, DOB, Program, Term Create table for issue and …

I want to make sqlite table like this format: | Matric | Name | GitHub Link | Status | |--------|-------------------------- |---------------------------|--------| | 243340 | Yu Zhixiong | https://github.com/abcde | Yes | | 250634 | Ahmad Afham Bin Noor Azizan | | No | I get two link is first link …

I'm looking to build a command-line tool that will enable me to read an arbitrary XML file combined with a mapping to fill an existing (arbitrary) SQLite database with data. What I'm looking for are conceptual ideas on how to solve this. I've got a possible theoretical solution in mind, …

Hello. I am making a database using SQLite. Then I need to make an API with functions that returns information about that database. Then I need to print out a report. However, when I try to return an answer to a query using inputs, nothing is returned. I either get …

I have been trying to solve this error for almost 2 days have tried various posts from multiple places like github, stack overflow, and even daniweb. None have helped so far. So expecting atleast explaination for issue if you don't have answer. So here how I am creating database in …

I'm reading data from SQLite database table. If the SQLiteDataReader encounters a negative double an InvalidCastException is thrown. Here is my code. public void DBToArray() { string stm = "SELECT * FROM mtable"; SQLiteCommand cmd = new SQLiteCommand(stm, sqlcon); SQLiteDataReader rdr = cmd.ExecuteReader(); while (rdr.Read()) { Console.WriteLine( rdr.GetInt32(0) + " …

can anyone help me with Add to cart functionality in xamarin(i.e) C# code using SQLite

I am using web server as LIGHTTPD....database as sqlite3....And php.. I made my flash memmory of nanopi as readonly(in fstab). while content listing from database to web page it is showing only limed amount of data( for example...in a webpage i am given to list 55 records.but beacuse of this …

I have a form that uploads a news article with it's picture and then stores all the info correctly. I am using codeigniter with Active Record and would like to know how to display the image with the post it was uploaded with. here is my upload script: public function …

Hi, I've written this code which i send below. now i have a listview, and when i click each item in my listview, i want it's related word to be fetched from db and shown in my textview. now it fetches all the data :(. look at the picture, for …

Does anybody know whether System.Data.SqlLite has the capability to do a Change notification callback when one of it's tables is changed? I know that Python can do it by calling the C api, but This is kind of beyond me. I know I have done this before on an oracle …

Hello, my code at the minute fetches a record and splits it up into a tuple, this is so each individual element can be displayed in an entry. I am now trying to create a feature which reads what is in the entrybox and updates the record in the database. …

Hi, how would you output the values of a foreign key. For example: if there is a table with two foreign keys (which are linked to other tables), how would you output the values of those foreign keys.

from tkinter import* import tkinter import sqlite3 import sys conn = sqlite3.connect('REVISION CARD.db') c=conn.cursor() def load(): root=Tk() root.title("REVION CARDS") root.geometry("700x400+100+100") w1=Label(root, text="Question") w1.pack() e=Entry(root,width=40) e.pack() w2=Label(root,text="Answer") w2.pack() e1=Entry(root,width=40) e1.pack() toolbar=Frame(root) navbar=Frame(root) N=Button(toolbar, text="next",width=9,command=getNext) N.pack(side=RIGHT, padx=200, pady=5) B=Button(toolbar, text="previous", width=9) B.pack(padx=100, pady=5) toolbar.pack(side=TOP, fill=X) count=IntVar() c.execute("SELECT * FROM topic") list1 = …

Deleting a table data from adminer,It is showing error unable to "unable to open database file"..But command line sqlite3 delete query is working in ubuntu.

hi ! I am developing a pos software for desktop. I am using java derby database for this. I have developed a feature for purchasing items and also a feature for analyzing purchases so that the user can view that what, when, how much he purchased. I am using two …

Hi hope someone can help me Read sqlite datatable is verry slow I have a listview in detail mode with 45 columns. and a datatable to add, read, delete and update datarows with 45 colums. Only i have a problem to read the datatable and show it all in the …

Private Sub cmdPrint_Click() Dim cnview As New ADODB.connection Dim rsview As New ADODB.Recordset Call connection(cnview, App.Path & "\Seeyou.mdb", "endromida") 'Call connection(cnview, "\\SEEYOU-PC\shared\Seeyou.mdb", "endromida") Call Recordset(rsview, cnview, "SELECT * FROM [order] where Edate = #" & txtEdate.Text & "#") If rsview.RecordCount = 0 Then MsgBox "No Record Found On Query.", vbCritical, …

Hi All, in sqlite SMALLINT datatype is used to store 2 bytes integer but i didn't see any Unsigned SMALLINT type to support the range(0-65535). Can anybody let me know how to achieve the same.

Hello I have created two classes one for the user and the other for address every thing is ok and the tables of the two classes created in my database but when i try to initiate a new object from user class i get the below error "sqlalchemy.exc.InvalidRequestError: Mapper 'Mapper|user|user' …

Hi to all! I made a class named “Database” I called openOrCreateDatabase in in its constructor but it was giving error. Then I searched on internet and got a solution that in case of non activity class I should also pass context. Then I passed context but then I am …

I am creating one application visual basic and sqlce I have two forms name Form1 and Form2. I used Form1 to add data to database using OLeDb command and used Form2 to show data in datagridview by using dataset I used following code: FFORM1 CODE is as following [code] Private …

I'm a beginning Android Developer trying to learn the file system, etc. I'm hoping to eventually delve into Home Automation and traffic analysis using phones/GPS, but I'm in the beginning arc of this learning curve. My background is mostly C/C++, though I've done some work in Java. I'm not so …

Having problems getting my code to run on non dev machines. All machines are win 10 and my code targets .Net 4.6 which is supposed to ship with it. On one machine I had a problem where an exception to do with System.Data.SQLite was thrown and on another I had …

# Good day to all ..i need help with this..i want to delete and edit the selected row from a listView with the use of alert dialog.i have a bit knowledge of constructing an alert dialog in my class..the problem is the method to call for deleting and editing from …

I have an SQLite3 database which has 8 tables and in which data will not change so needs no add option. Each table has 4 or 5 fields of different types. In order to use this data in an Android app I need to load it into spinners. My questions …

Hey guise, I have a uni assignment; setting up backend code for a tour company website. Everything's gone swimmingly but I've run into issues implementing a system for rating the tour packages. Implementation for the rating system: user clicks rate button, the rating score is added to a running total …

hi, I am having a problem with adding button on jTable for each data I get from the database. here is what I get from database in SQLite try{ String sql = "select ClassName as 'Class Name', NumberOfStudents as 'Number of Students' from ClassRooms"; pst=conn.prepareStatement(sql); rs=pst.executeQuery(); Data_Table1.setModel(DbUtils.resultSetToTableModel(rs)); if(rs.next){ //code to …

I'm creating a small and simple app to use with my poker league. I've created a small DB that I simply enter the player name, who took them out, and what place they went out in. All of that works just fine. What I need to do is implement the …

I have an old sqlite database that I am no longer going to be using but I want to transfer all of my data to my new mySQL database. I have everyone imported and it all looks good but the problem is when I order my one of my columns …

Im having a problem with updating data in SQLite this is the full code who execute after pressing the button try { PrintWriter writer = new PrintWriter("d:\\"+LBL1.getText()+"\\"+TL3.getText()+"_"+TL2.getText()+"_"+TL4.getText()+"_"+TL5.getText()+"_"+TL1.getText()+".txt", "UTF-8"); writer.println("Invoice Number = "+TL1.getText()); writer.println("Seda = " +TL3.getText()); writer.println("Date = " +TL2.getText()); writer.println("Documental Class = " + TL4.getText()); writer.println("Status = " + …

Im using this code to get image from SQLITE try{ String sql = "SELECT Photo FROM Pics WHERE InvoiceNumber=?"; pst = conn.prepareStatement(sql); rs=pst.executeQuery(); if(rs.next()){ byte[]imagedata = rs.getBytes("Photo"); format = new ImageIcon(imagedata); ImIc.setIcon(format); } }catch(Exception e){ JOptionPane.showMessageDialog(null, e); } `private ImageIcon format = null;` String filename = null; int s=0; byte[] …

Hi folks. I'm having a problem with VS2010 where suddenly one of my projects is displaying the warning "The referenced component 'System.Data.SQLite' could not be found". All i can find about it in my search is a problem with building both x86 and x64 applications, but my project is only …

Im using NetBeans to create a data entry software for a friend. when I save a data, it create a folder in specified location, and the name of that folder will be different from each other for example.  it pick the Date,Invoice Number, Subject name, and create the …

I'm writing a small backup app, where a folder is selected, zipped, and stored in an SQLite database as a blob along with it's MD5 hash, date, paths ect.... My problem is that when the zipped file is around 600MB+ I get an SQLiteExecption out of memory. The error was …

I am working on an app where i would scan a coupon and it would find the matching upc in a sqlite database that i have created and place all of the details from that table into a new table for my personal coupon library. I was getting an error …

I've been using [DB Browser for SQLite](http://sourceforge.net/projects/sqlitebrowser/) to peer inside database for debugging. It's been very good and simple to use. However it does not support a DB which has a password. It is fine with DB that I do not have password. Wondering if anyone knows of a db …

Hello I am creating a little application, using VB.net, and Access database. I want to count the number of records whitch have more than 6 hours difference between records. Is it possible to have a query to count the number of recordset where the "Time End" and "Time Start" of …

Earlier I posted a snippet which showed [how to create a 2 dimensional string array from an SQLite database table](https://www.daniweb.com/software-development/csharp/code/494083/sqlite-database-table-to-2-dimensional-string-array-). This snippet is the reverse, if you will, where we create an SQLite database table from a 2d string array. It should be noted that this code has it's limitations, …

I was working on this function which was quite specific to my project, so thought I'd make it more generic and share it, since I could find very little on the subject in my searching. Code also demonstartes how exceptions can work to your advantage when you know they are …

I am trying to execute the query on server side and send the result to the client but at the time of returning the value to the client the error occurs Am trying to achieve this using RPC Protocol but i could not find out how to send back the …

I need to make an app in Java that must add in a database all the files (with folder structure) from a hard drive. I need to add the metadata of this files as well. What it will be the best aproach ? Using SQLite with multiple tables or Neo4j …