• Welcome, Guest. Please login.
 
October 25, 2021, 08:41:12 PM

News:

Welcome to the SQLitening support forums!


Show posts

This section allows you to view all posts made by this member. Note that you can only see posts made in areas you currently have access to.

Messages - Fim

151
I will have look at it.
152
To Fredrick Ughimi (and all others)
The method you suggest works great, I have usee it. But if it concerns many items, such as 100000, then you may bring your bed to work.
153
In the topic "Using AuxRutsA" cj show me how to write encrypted data in a database, which works perfect. But how to remove an entry whose key is encrypted? I have no idea myself.
154
Hi,

Select count(DISTINCT Listnamn) FROM Listord where sprak = 'SE'
Exactly what I was looking for. A big thanks.
I have to learn SQL better.

Fim W.
155
I have a table with many word lists, e.g astronauts, rocks, bridges Sweden, bridges World.
I create the table witH this:
CREATE TABLE Listord(
    Sprak       Text        not null,     = Language
    Listnamn    Text        not null,     = List name
    Ord         Text        not null,     = Word
    Unique (Sprak, Listnamn, Ord));

With this SQL-Command
SELECT DISTINCT  Listnamn FROM Listord where sprak = 'SE';
I can se the namne av all word lists, but, and that is the question,
how to count the number of word lists in the table??
                         
COUNT (SELECT DISTINCT  Listnamn FROM Listord where sprak = 'SE';)  No, No
SELECT COUNT (DISTINCT  Listnamn FROM Listord where sprak = 'SE';)  No, No     
/Fim W
156
Thanks for the help. Somehow I had made ??a mistake with the single quote.
The next time I'll attach code that can be compiled.
Regards
Fim W.
157
I have changed te last Sqlitening-cal from slSel to slExe, but there is no diffrence.

/Fim
158
Hi,

I have an array with a lot of words. The words in the vector which is in my table "Ordlista" I want to delete. First, I test if the word is in the table with a COUNT statement. If there is, I use a DELTE statement. But there is no deletion.

BORTTAG_AV_ORD:
'==============
'
BORTTAGET_START:
    ORDNR = 0

NASTA_BORTTAG:
    INCR ORDNR
    IF ORDNR > ANTAL_ORD_MED_ACCENT THEN GOTO SLUTSEKVENS

FINNS_ACCENTLAOST_ORD:
    SELECT_SATS = "SELECT COUNT (*) FROM ORDLISTA WHERE SPRAK = " + $SQ + "SE" + $SQ + " AND ORD = " + $SQ + ORD_MED_ACCENT (ORDNR) + $SQ
    slSel SELECT_SATS
    slGetRow
    ANTAL =VAL(SLF(1))
    IF ANTAL = 0 THEN GOTO NASTA_BORTTAG

BORTTAG_ORD:
    SELECT_SATS = "DELETE FROM ORDLISTA WHERE SPRAK = " + $SQ + "SE" + $SQ + " AND ORD = " + $SQ + ORD_MED_ACCENT (ORDNR) + $SQ
    slSel SELECT_SATS
    PRINT #1, "Borttaget ord:";ORD_MED_ACCENT (ORDNR)
    INCR ANTAL_BORTTTAGNA_ORD

VIDARE:
    GOTO NASTA_BORTTAG

/Fim
159
The error was that I was using double quotes, should be single quotes.
sqlite> select ord from ordlista where ord = "ORD" limit 10;  <<======== Wrong
sqlite> select ord from ordlista where ord = 'ORD' limit 10;   <<======== Correct

Fim W.
160
It was exactly what I was after. It works perfect. A big thank you for your help.

Fim W
161
Quote from: cj on July 18, 2014, 03:29:46 PM
select ord from ordlista where ord = "GRYTVALPEN" limit 10;
select ord from ordlista where ord = 'GRYTVALPEN' limit 10;

No difference.

/Fim
162
Quote from: cj on July 18, 2014, 03:31:16 PM
Was this what you wanted?


Probably, but I'm not there yet, will return

/Fim
163
Hi,
This is actually a SQLite query, but there is so much clever people here who probably understands the problem.

7=C:\ORDKORS\ORDKORS>SQLITE3 ordkors.db3
SQLite version 3.6.14
Enter ".help" for instructions
Enter SQL statements terminated with a ";"
sqlite> select ord from ordlista where ord = "ORD" limit 10;
GRYT
164
I will have o look at it
165
As I have understood it, you can not encrypt a text string with AuxRutsA and then enter it into the database because SQLite does not accept binary zeros. Am I right or wrong? And if I'm right, how to handle when encryption?
Fim W