Sqlite operations sometimes doesn't work

Discuss
,
#1

Sometimes simple operations like insert, update, delete and select doesnt work anyway. Same operations work by evening or next day. Why is it so? It is server problem or my side problem. Same operations works in different pc which are in same network (same router). Only I am facing this problem or any other had same issue. What will be the possible solution. Our project deadline is slipping because of this problem. Please let me know does anyone got solution for this problem

#2

It would really help if you provided a screenshot of your relevant blocks, so we can see what you are trying to do, and where the problem may be.

To get an image of your blocks, right click in the Blocks Editor and select “Download Blocks as Image”. You might want to use an image editor to crop etc. if required. Then post it here in the community.

Taifun

1 Like
#3

Screenshot_1
Screenshot_11076Ă—256 30.8 KB
Screenshot_2
Screenshot_21086Ă—196 25.4 KB

here are the blocks

#4

which blocks do you execute and in which sequence to get that issue?
you might want to add a global variable to know, which action you are executing
for example before creating the table use a global variable action and set it to CREATE
later after the query has been executed, use that global variable again like this

if action = "CREATE"
then do something you like to do after creating the table
else if action = "SELECT"
then do something you like to do after selecting the customers

Taifun

#5

This post was flagged by the community and is temporarily hidden.

#6