Glad to be a part of this platform among you, highly experienced programmers, Nowadays I am working on a POS system project in python, using tkinter for frontend & Sqlite as the database. While putting data into it, I am facing this issue. ”’ ”’ What I am trying to do here is retrieving data from the tkinter widget and
Tag: database
java.sql.SQLSyntaxErrorException: ORA-01797: this operator must be followed by ANY or ALL
My query is I get the error java.sql.SQLSyntaxErrorException: ORA-01797: this operator must be followed by ANY or ALL whenever i run it, What does it mean and how can I fix it ? Answer Your code is very messy and should be cleaned up. When asking the questions here you usually should create a MRE in which the concrete problem
Invalid syntax error near ‘<' when using case when variable, works fine without variable
I am trying to resolve this SQL issue where my code throws an error Invalid syntax error near ‘<‘ when I use the variable @totalprice. Without using the variable, the CASE works and the query executes correctly but I want it as a variable Thanks Answer If you want to assign the result of the CASE expression to your variable
Return decimal value in SQL query
Example of script ,sum(BREAKS)/3600 as Breaks but it comes back as a whole number, how can I get decimals?
PostgreSQL – How to format an int as an hexa
What’s a short/simplest way of formatting an int to an hexa, with leading zeroes? For example I need to format: My query needs many of these conversions I would appreciate a short piece of code instead of a verbose one. Just need to deal with positive numbers. Answer I’m not sure it’s the shortest way but at least I found
SQL: How to check if group of rows already exist in a table
I have a simple chat functionality in my application where signed up users are able to create chat groups with other users. To store the information which user is a member in which chat I am using a …
Is it possible to COUNT if one value occured more than the other value in a column using SQL
I have this table called task_status which has the following structure: CREATE TABLE `task_status` ( `task_status_id` int(11) NOT NULL, `status_id` int(11) NOT NULL, `task_id` int(11) NOT NULL, …
How do I use OR in mySQL on a Select statement with a greater-than condition?
So I am basically building this mySQL sports database and have a table in which there is a ‘Home_Team’ and ‘Away_Team’, as well as ‘Home_Score’ and ‘Away_Score’. What I need is a query which displays the winning team and score. So it has to select one team if the score is greater than the other team’s; and vice-versa. I have
Insert a line with different values
How to insert a line ? position the number 12 piece_color the R id 0 and 1 . I want to have two numbers here I did The returned error was: Answer You need to specify the columns to insert if you would like to use VALUES. In your case, it would be something like this:
How have you set up your database? Do you have to change a lot with a new year? [closed]
Closed. This question is opinion-based. It is not currently accepting answers. Want to improve this question? Update the question so it can be answered with facts and citations by editing this post. Closed last year. Improve this question I have a question about databases. What does your database actually look like? Suppose you have a table for quotations. For example,