1 Topic by prahousefamily (edited by prahousefamily 2025-03-27 03:55:10)

  • Registered: 2014-02-17
  • Posts: 391

Topic: How To Concat Ling Break On SQLite

How to Edit Script  Insert Line Break On SQLite ?
Code

SELECT 'A'||'\n'||'B'

Response

A\nB

----------


Code

SELECT 'A'||'\r'||'B'

Response

A\rB

----------


Code

SELECT 'A'||'\r\n'||'B'

Response

A\r\nB

----------


Code

SELECT 'A'||char(10)||'B'

Response

[Err] 1 - no such function: char
My Visual Database : I Love You
Easy For Beginner Student For Me
  • From: Рідна МАТИ, UKRAINE
  • Registered: 2018-06-02
  • Posts: 1,216

Re: How To Concat Ling Break On SQLite

For example like this:

  Form1.Memo1.Lines.Text := SQLExecute('SELECT "Cat"||CHAR(10)||"Oggy"');