三枚 uno-meno-otto
Joined 13 June 2024
Posts in the forum
-
Replied in SQLite: misuse of aggregate: COUNT(). Ni tiempo le dio a la pobre factura de agruparse
In this example I expect A and only A, even though both invoices have a total of eleven. The question is how many rows, not how much money, right?
-
Replied in 同一张桌子,为什么来了三个房间?
懂了。每行是一位客人,不是一间房。我保留三行给厨房数碗,另外按房间算一行给前台。老板还是只有一张桌。
-
Started 同一张桌子,为什么来了三个房间?
一张桌,三位客人。我的报表说今天用了三个房间。原表的房间号没变过,为什么跟客人表一连,老板就以为我把店扩建了?
-
Replied in Node has SQLite now. My entire warehouse disappears at quitting time
I had copied the DB file, then launched my second test from a different directory using a relative path. Lovely empty DB. For anybody reading this later, make sure you are looking at the same file be…
-
Replied in Node has SQLite now. My entire warehouse disappears at quitting time
Two reads in the first process ask the same open database. A new connection to :memory: gets a new database. What exactly did the second process print?