• Welcome to SQLitening Support Forum.
 

News:

Welcome to the SQLitening support forums!

Main Menu
Menu

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.

Show posts Menu

Messages - Fim

#121
Thank you.
A little embarrassed, I had not seen "slGetTableColumnNames" in the manual.
Glad you did not answer RTFM.
#122
slexe "PRAGMA table_info ordlista" gives no result.
Is there any other way to get the names of al columns in a table.
#123
How about
    sStatement  = "select ORD, SYNONYM from synonymer where ord = ?"
    BIND_DATA1   = slBuildBindDat(TRIM$(ORDBILD), "TN")
    SlSelBind(sStatement, BIND_DATA1)
Ord is encrypted
#124
Solved
Run as administrator
#125
I get "SQLitening server failed to install" when I start SQLiteningServerAdmin.exe.
Windows 10, 64bit

/Fim W.
#126
Many thanks.
Just what I was looking for.

Fim W. Sweden Ystad
#127
You will receive error code 19 when you try to add a non unique key to an index during an INSERT or UPDATE.
You will receive the same error code, 19, when foreign key constraint failed.
Is it possible, in any way, to see if it is a foreign key constraint failed or adding a non unique key to an index?

Fim W. Sweden, Ystad
#128
Bern,

Thanks, by I think I will solve the problem in another way.

/Fim W.
#129
Bern,
"To develop a Proc Fn" is over my knowledge.
I use Powerbasic.
/Fim
#130
Mike,
Not that problem.
/Fim
#131
I thought it was something like that.
But  how to do it in PowerBasic?
/Fim W
#132
If I use SELECT * FROM PERSONAL ORDER BY NAME
the  result will be
#133
Now I have found the final solution:

SOK_ROWID:
    sStatement  = "SELECT ROWID from ordlista where ord = ? and Ordlista_nr =" +  str$(ordlista_nr)
    BIND_DATA1   = slBuildBindDat(TRIM$(ORD), "TN")
    SVAR = SlSelBind(sStatement, BIND_DATA1)
    SVAR = slGetRow
    RADNR = VAL(SLFX(1))

BORTTAGET:
    SVAR = SLEXE ("DELETE FROM ORDLISTA WHERE ROWID = " + $SQ + STR$(RADNR) + $SQ)
    IF SVAR = 0 THEN BORTTAG_ORD = 0


#134
I chose the solution by reading the words of the current length, and then use the row IDs for removal.
Fim W.
#135

Thanks, that sounds reasonable. I will do so.
/Fim W.