[Gambas-user] Tableview format

[ron]

On Friday 18 May 2007 00:38, nogueira_jr wrote:
> Fabien Bodard escreveu: 
> > 2007/5/17, nogueira_jr <nogueira_jr at ...172...>: 
> >> Hi All: 
> >> 
> >> Please, help me in the TableView: 
> >> 
> >> I use SQLite3 and my table have: 
> >> codigo      alfanumerico 13 
> >> preco        float 
> >> 
> >> Problem 1: Tableview show the order: 
> >> CODIGO 
> >> 1 
> >> 10 
> >> 11 
> >> 2 
> >> 3 ..... 
> >> 
> >> I want the correct order: 
> >> 
> >> 1 
> >> 2 
> >> 3 
> >> .... 
> >> 9 
> >> 10 
> >> 11 
> > 
> > 
> > use the sql statement : 
> > "SELECT * FROM MyTable ORDER BY codigo 
> Already I am using the ORDER BY codigo ..... 
> ????? 
> 
> 
> > Problem 2: Tableview show the alignment: 
> > in the GridView1_Data  event : 
> > if Column=1 then GridView1.Data.Alignment=align.right 
> OK Correct !!!!!!! 
> Tks Fabien 
> 
> Nogueira 
> 
> 
> 

for mysql see http://dev.mysql.com/doc/refman/5.0/en/string-functions.html
http://dev.mysql.com/doc/refman/5.0/en/string-functions.html#function_concat
http://dev.mysql.com/doc/refman/5.0/en/string-functions.html#function_right

sqlite concat() I found this
http://www.mail-archive.com/sqlite-users%40sqlite.org/msg11086.html

http://en.wikibooks.org/wiki/SQL_dialects_reference/Functions_and_expressions/String_functions
Substring from string str, starting from start, length of len 
	SUBSTR()  try SUBSTR(str, len[, start])

Length of string x (in characters)
	LENGTH(x)

String concatenate 
	arg1 || arg2