S SarahWard Banned Dec 24, 2009 #1 Is there any way to set the text for the title (fieldname) of each field (column) in a database linked TABLE control? I have to write the column name in Farsi (Persian script) in each column (row 0). Because these titles are in Farsi I cannot use them for the database fields (that may normally be the easiest way to assign specific titles to the table). Thanks for any help! Sarah
Is there any way to set the text for the title (fieldname) of each field (column) in a database linked TABLE control? I have to write the column name in Farsi (Persian script) in each column (row 0). Because these titles are in Farsi I cannot use them for the database fields (that may normally be the easiest way to assign specific titles to the table). Thanks for any help! Sarah
agraham Expert Licensed User Longtime User Dec 25, 2009 #2 SarahWard said: Because these titles are in Farsi I cannot use them for the database fields Click to expand... I'm not a SQLite expert but why not? They are just Unicode text strings aren't they?
SarahWard said: Because these titles are in Farsi I cannot use them for the database fields Click to expand... I'm not a SQLite expert but why not? They are just Unicode text strings aren't they?
S SarahWard Banned Dec 25, 2009 #3 Yes that makes sense. But to view them as Farsi characters on the device I need to install software (Mobidiv Arabizer) that corrupts the b4ppc IDE. That is why I was hoping to find code to edit the titles in a Table control. Just trying to avoid a vicious circle of problems.
Yes that makes sense. But to view them as Farsi characters on the device I need to install software (Mobidiv Arabizer) that corrupts the b4ppc IDE. That is why I was hoping to find code to edit the titles in a Table control. Just trying to avoid a vicious circle of problems.
Erel B4X founder Staff member Licensed User Longtime User Dec 25, 2009 #4 You can set the columns names in your SQL query: Code: cmd.CommandText = "SELECT col1 AS abcd, col2 AS 'some_different_name' FROM table1"
You can set the columns names in your SQL query: Code: cmd.CommandText = "SELECT col1 AS abcd, col2 AS 'some_different_name' FROM table1"
S SarahWard Banned Dec 25, 2009 #5 Erel said: You can set the columns names in your SQL query: Code: cmd.CommandText = "SELECT col1 AS abcd, col2 AS 'some_different_name' FROM table1" Click to expand... Thanks Erel Much appreciated Sarah
Erel said: You can set the columns names in your SQL query: Code: cmd.CommandText = "SELECT col1 AS abcd, col2 AS 'some_different_name' FROM table1" Click to expand... Thanks Erel Much appreciated Sarah
