fetch data from sqllite module give me 'ERR_SQLITE_ERROR',

[sharafabacery]

Version

v22.10.0

Platform

windows 10 x64

Subsystem

No response

What steps will reproduce the bug?

`import path from 'node:path';

import {DatabaseSync} from 'node:sqlite'

export class Connectdb{

dbConnectionString:string;

database:any

constructor(dbConnectionString:string){

    this.dbConnectionString=dbConnectionString

}

Connect(){

    this.database=new DatabaseSync(this.dbConnectionString);

}

RetriveData() {

    const query = this.database.prepare('SELECT * FROM "titles" ');  

    console.log(query.all())

}

}

let obj=new Connectdb('../database.db')

obj.Connect()

obj.RetriveData()

`

How often does it reproduce? Is there a required condition?

always it produce

What is the expected behavior? Why is that the expected behavior?

get data I need

What do you see instead?

`const query = this.database.prepare('SELECT * FROM "titles" ');
^

Error: no such table: titles
{
code: 'ERR_SQLITE_ERROR',
errcode: 1,
errstr: 'SQL logic error'
}

`
and titles found in the database

Additional information

No response

[cjihrig]

Error: no such table: titles

That seems to be the problem?

[sharafabacery]

The table in database is exsiten

[cjihrig]

Not according to SQLite 😄

[sharafabacery]

@cjihrig nice😀

[sharafabacery]

@cjihrig could problem because of windows os?

[RedYetiDev]

If you load the database in a seperate client, is the "titles" table existent?

[sharafabacery]

yes I load in "DB Browser (SQLite)" and it show correctly

[cjihrig]

could problem because of windows os?

Windows is supported and tested, but it's possible. What if you update Connectdb('../database.db') to use backslashes?

[sharafabacery]

it solves the problem thanks

[huseyinacacak-janea]

Hi @sharafabacery, I wanted to look into this issue but couldn't reproduce it (I tried Node 22.10.0, and 23.1.0). I used the code you've provided in the description and the attached database. Could you please try to run the code with the attached db?
database.zip

[sharafabacery]

when I get back to code last week I change the path to basedir/databasefile.db it works fine could be problem happen when compile ts to js ,but if need to explore the code here the repo https://github.com/sharafabacery/hisnmuslimTs

[StefanStojanovic]

Since this seems to be working now, I'll close the issue. Feel free to reopen if needed.