• Welcome, Guest. Please login.
 
September 18, 2020, 05:27:43 am

News:

Welcome to the SQLitening support forums!


ORDER BY with characters

Started by Fim, June 10, 2016, 11:09:01 am

Previous topic - Next topic

Fim

If I use SELECT * FROM PERSONAL ORDER BY NAME
the  result will be
Fim W

Bern Ertl


Fim

I thought it was something like that.
But  how to do it in PowerBasic?
/Fim W
Fim W

Bern Ertl

June 13, 2016, 11:27:23 am #3 Last Edit: June 13, 2016, 11:29:29 am by Bern Ertl
SQLitening doesn't have a function that addresses the underlying  sqlite3_create_collation() function (perhaps an opportunity to improve/expand on SQLitening), so you will most likely need to develop a Proc Fn to handle it (accessed with slRunProc from your client app). 

Mike Doty


Fim

Fim W

Fim

Bern,
"To develop a Proc Fn" is over my knowledge.
I use Powerbasic.
/Fim
Fim W

Bern Ertl

Fim, see the PowerBASIC examples included with SQLitening  (SQLiteningProcsA.BAS).  See also documentation for slRunProc() in SQLitening.txt

I don't have time right now, but I can assist you with a framework later.

Fim

Bern,

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

/Fim W.
Fim W