peacemaker Expert Licensed User Longtime User Nov 22, 2018 #1 HI, All B4X: android.database.sqlite.SQLiteException: near "||": syntax error (code 1): , while compiling: SELECT FName || ' ' || Name || ' ' || SName ', ' || Position FROM CompanyWorkers WHERE UserID = 'F185C519D5E91F03' Requested like SQL.ExecQuerySingleResult(req) Why error? SOLVED: B4X: $"SELECT IfNULL(FName,'') || " " || IfNULL(Name,'') || " " || IfNULL(SName,'') || ", " || IfNULL(Position,'') FROM CompanyWorkers WHERE UserID = '"$ & UserID & "'" Last edited: Nov 22, 2018
HI, All B4X: android.database.sqlite.SQLiteException: near "||": syntax error (code 1): , while compiling: SELECT FName || ' ' || Name || ' ' || SName ', ' || Position FROM CompanyWorkers WHERE UserID = 'F185C519D5E91F03' Requested like SQL.ExecQuerySingleResult(req) Why error? SOLVED: B4X: $"SELECT IfNULL(FName,'') || " " || IfNULL(Name,'') || " " || IfNULL(SName,'') || ", " || IfNULL(Position,'') FROM CompanyWorkers WHERE UserID = '"$ & UserID & "'"