Author |
Message |
Topic: Settings are gone |
Iliev
Replies: 2
Views: 4998
|
Forum: CMUD General Discussion Posted: Tue Aug 16, 2011 7:28 pm Subject: Settings are gone |
No, settings are empty.
When I load it in a sqlite viewer and 'clean db', it removes everything, save for 12 kb.
So I guess settings are and the backups are useless, I'm not sure how something ... |
Topic: Settings are gone |
Iliev
Replies: 2
Views: 4998
|
Forum: CMUD General Discussion Posted: Sun Aug 14, 2011 12:19 pm Subject: Settings are gone |
I load the settings, there are no trigs/aliases etc, same with the backups. The file is about 500 kb, when opened with notepad it has stuff in it, some of it is weird chars.
Did it get corrupted a ... |
Topic: adding entries to sqlite db |
Iliev
Replies: 27
Views: 31361
|
Forum: CMUD General Discussion Posted: Thu Jun 23, 2011 9:49 am Subject: adding entries to sqlite db |
I'm not sure what's going on, it works now. Including my own example that I posted last night, and which I tried like 30 times and I'm sure it wasn't working.
The field is a number and my example v ... |
Topic: adding entries to sqlite db |
Iliev
Replies: 27
Views: 31361
|
Forum: CMUD General Discussion Posted: Wed Jun 22, 2011 5:32 pm Subject: adding entries to sqlite db |
I type
#sqldb test1
It creates a db called test1 in d:\cmud sessions\sessionname
Then if I type:
#call %sql(test1, “insert into eq (asd1) values (asd2)”)
The error message is: SQL logic erro ... |
Topic: %querry issues, 3.34 |
Iliev
Replies: 5
Views: 5577
|
Forum: CMUD General Discussion Posted: Wed Jun 22, 2011 1:05 pm Subject: %querry issues, 3.34 |
dbfirst/next is kind of slow :P like a second for 15 items display |
Topic: %querry issues, 3.34 |
Iliev
Replies: 5
Views: 5577
|
Forum: CMUD General Discussion Posted: Wed Jun 22, 2011 11:08 am Subject: %querry issues, 3.34 |
I found that on forums, but it didn't work either :( first time I do it there's access violation error, second time there is no message at all, but the database gets kind of buggy :P can't close it, c ... |
Topic: adding entries to sqlite db |
Iliev
Replies: 27
Views: 31361
|
Forum: CMUD General Discussion Posted: Tue Jun 21, 2011 1:22 pm Subject: adding entries to sqlite db |
#call %sql(INSERT INTO eq (asd1) values(2))
this is what I type, there's a db that I created with #sqldb eqsql2, eq is a table and asd1 is a field (column) which I created in some sqlite viewer. So ... |
Topic: %querry issues, 3.34 |
Iliev
Replies: 5
Views: 5577
|
Forum: CMUD General Discussion Posted: Mon Jun 20, 2011 9:27 pm Subject: %querry issues, 3.34 |
I have a db, it's loaded. I have a field, called level, type is 'number'. There are several rows, with values set for the level field.
Let's say they're 1 for row 0, 2 for 1, 3 for 2. The db is cal ... |
|