Unable execute the Select All command in sqlite

I've been working on several queries, but unfortunately I've encountered an issue with this one that is not providing a helpful error code.

The table I'm working with is 'Activity' and I simply want to select all records from it.

Initially, I had this query which worked perfectly:

const query = 'SELECT * FROM Activity WHERE status =? OR status = NULL';
return this.database.executeSql(query, [1]);

This query returns the expected results without any problems.

However, when I run this query instead:

const query = 'SELECT * FROM Activity';
return this.database.executeSql(query);

I encounter the following error message:

https://i.sstatic.net/JCEJY.png

Both queries return a Promise<any> and store the results in a variable.

The executeSql method requires one parameter, with the second being optional. The error message indicates that 6 results were found, which is correct.

If anyone has any insights or suggestions on what might be going wrong here, your help would be greatly appreciated!

androidsqltypescriptsqlite

Answer №1

Revise the query to this.

const newQuery = 'SELECT * FROM Activity WHERE status =? OR status IS NULL';

Avoid using the equals sign for null values as you originally did ( = NULL)

Answer №2

I am having trouble grasping the issue at hand, but I managed to find a workaround.

Instead of utilizing

SELECT * FROM Activity, I opted for 

SELECT * FROM Activity WHERE status >?
and executed the statement with

return this.database.executeSql(query, [-1]);

The question mark denotes a parameter, where the status is always 0 or greater.

Similar questions

If you have not found the answer to your question or you are interested in this topic, then look at other similar questions below or use the search

What is the best way to change a blob into a base64 format using Node.js with TypeScript?

When making an internal call to a MicroService in Node.js with TypeScript, I am receiving a blob image as the response. My goal is to convert this blob image into Base64 format so that I can use it to display it within an EJS image tag. I attempted to ach ...

node.jsangulartypescript

Renaming a File using renameTo alters the file's contents

File dir = new File(getFilesDir(), "dir1"); dir.renameTo(new File(getFilesDir(), "dir2"); Log.d("Number of files:", dir.listFiles().length); If there are 5 files in /dir1/, the first code snippet will output 0. However, when the code is modified as follow ...

javaandroidpathdirectory

Is there an array function that only returns the first element of an array?

Struggling to retrieve multiple variables from a column in an SQLite DB, store them in an array, and display all the data? Currently, only the first variable is being retrieved. Can someone please assist? -There are definitely more variables in that colum ...

androidarrayssqlitemethods

Effortless Image Loader for ListView

For my project, I took inspiration from the initial framework found here: https://github.com/thest1/LazyList/ Instead of using the LazyAdapter provided in that project, I created my own custom CardAdapter as shown below: public class CardAdapter extends ...

androidlistview

Searching the database using an ID in Django

In my Django project, I have the following Model: class Choices(models.Model): question = models.CharField(max_length=200) option1 = models.CharField(max_length=200) option2 = models.CharField(max_length=200) option3 = models.CharField(max ...

pythonhtmldjangosqlite

Matching TypeScript against the resulting type of a string literal template

My type declaration looks like this: type To_String<N extends number> = `${N}` I have created a Type that maps the resulting string number as follows: type Remap<Number> = Number extends '0' ? 'is zero' : Number ...

typescripttypes

Tips for utilizing the Fluent UI Northstar Color Palette

When working with Fluent UI Northstar, one helpful feature is the color palette. While the documentation provides a list of color names and gradients that can be found here, it can be confusing on how to actually utilize these values (such as 100, 200, e ...

typescriptcolorsfluentui-react

What is the best way to detect object changes in typescript?

Having an object and the desire to listen for changes in order to execute certain actions, my initial approach in ES6 would have been: let members = {}; let targetProxy = new Proxy(members, { set: function (members, key, value) { console.log(k ...

typescriptecmascript-6visual-studio-code

Declaring module public type definitions for NPM in Typescript: A comprehensive guide

I have recently developed a npm package called observe-object-path, which can be found on GitHub at https://github.com/d6u/observe-object-path. This package is written in Typescript and has a build step that compiles it down to ES5 for compatibility with ...

javascripttypescriptnpm

Perform a function upon completion of an AsyncTask

I'm currently facing a small issue: I want to display 2 buttons on my fragment after the async task I called is completed. I used the following code for that: while (!recordi.getTerminé){ } terminé(); However, this approach is not optima ...

javaandroidandroid-fragmentsandroid-asynctaskandroid-toast

What is the best way to revert a screen's state back to its original state while utilizing react navigation?

How can I reset the state in a functional component back to its initial state when navigating using navigation.navigate()? For example, if a user navigates to screen A, sets some state, then clicks a button and navigates to screen B, and then goes back to ...

reactjstypescriptreact-nativereact-hooksreact-navigation

Guide to utilizing @types/node in a Node.js application

Currently, I am using VSCode on Ubuntu 16.04 for my project. The node project was set up with the following commands: npm init tsc --init Within this project, a new file named index.ts has been created. The intention is to utilize fs and readline to read ...

node.jstypescriptnpmdefinitelytyped

Connect a function to a functional component within React

When it comes to a class component, you have the ability to define custom functions within the component like so: class Block extends React.Component { public static customFunction1(){ return whatever; } public static customFunction2(){ re ...

javascriptreactjstypescript

Determine the exact location of the ListView scrollbar thumb on the display

Is there a way to obtain the X,Y screen coordinates of the ListView scrollbar thumb indicator in order to position a label next to it? I need a solution that takes into account varying heights of ListView items. I have been trying to determine this by get ...

androidlistviewscrollbar

Intricate SQL Query reminiscent of a z-axis arrangement challenge

My SQL problem in MS SQL Server is quite complex. As I was sketching it out on paper, I realized I could visualize it as a bar filled with rectangles, each with segments of different Z orders. Despite this visual representation, the issue actually revolves ...

sqlsql-server

Dialog displaying package name for Google login verification

I managed to successfully implement Google sign-in functionality. However, I am facing an issue where, upon attempting to sign in to Google, the default user Gmail accounts dialog opens up. In this dialog, the title that appears is the package name inste ...

android

The error message "Identifier 'title' is not defined. '{}' does not contain such a member angular 8" indicates that the title variable is not recognized or defined in the

Here is the code snippet of my component: import { Router, ActivatedRoute } from '@angular/router'; import { Component, OnInit } from '@angular/core'; import { CategoriesService } from 'src/app/categories.service'; import { P ...

angulartypescriptangular8

Working with Vue class-based components in TypeScript and setting props

Currently tackling a typescript-related issue within a class-based component and seeking guidance on a persistent error. Below is the code snippet for my component: <template> <b-message :type="statusToBuefyClass"> <p>PLACEHOLDER& ...

typescriptvue.jsvue-componentvue-class-components

Why does the onBlur event function in Chrome but fails to work in Safari?

I've encountered a problem with the onBlur event in react-typescript. To replicate the issue, I clicked the upButton repeatedly to increase the number of nights to 9 or more, which is the maximum allowed. Upon further clicking the upButton, an error m ...

javascriptreactjstypescriptreact-typescript

Knex.js allows for updating an existing column by utilizing the results of a select query

Product Information (id, currentdraw, totaldraw, ratio) The Product table holds the data I need to calculate the ratio using currentdraw and totaldraw This is my code snippet: Product.calculateRatio = function(productId, callback) { db('product&ap ...

mysqlsqlnode.jsknex.js