[SOLVED] Stored True and False in one string separating them
lazarus / 16-Databases

----------------------------------------------------------------------
madref · 2019-02-02 09:10

I store a few true and false statements in one string where 1 = true
and 0 = false in my database.
In Lazarus you can individual target a single letter in a string with
Code: Pascal  [Select][+][-]window.onload = function(){var x1 =
document.getElementById("main_content_section"); if (x1) { var x =
document.getElementsByClassName("geshi");for (var i = 0; i MyChar :=
MyString[1];In SQLite you can change the name of a field with the
'AS'-statement


Is it possible to separate them in individual statements in SQLite?


I was thinking along
Code: SQL  [Select][+][-]window.onload = function(){var x1 =
document.getElementById("main_content_section"); if (x1) { var x =
document.getElementsByClassName("geshi");for (var i = 0; i SELECT
RS_Observed [1] AS Referee1, RS_Observed [2] AS Referee2, RS_Observed
[3] AS Linesman1, RS_Observed[4] AS Linesman2 FROM tbl_Observations

----------------------------------------------------------------------
madref · 2019-02-02 09:19

Next time i should google first.


Found my own solution again 
USE SUBSTR (X,Y,Z) for more info looks here


Code: SQL  [Select][+][-]window.onload = function(){var x1 =
document.getElementById("main_content_section"); if (x1) { var x =
document.getElementsByClassName("geshi");for (var i = 0; i SELECT
SUBSTR(RS_Waargenomen,1,1) AS Referee1, SUBSTR(RS_Waargenomen,2,1) AS
Referee2, SUBSTR(RS_Waargenomen,3,1) AS Linesman1,
SUBSTR(RS_Waargenomen,4,1) AS Linesman2  FROM tbl_Rapport_Straffen