On 2018/01/03 12:15 PM, Bart Smissaert wrote:
Is there a way with pragma table_info or otherwise (other than parsing the
table create statement from SQLite_master) to get the column names
including the column delimiters, eg double quotes or square brackets? So I
would get eg: [column1] [column2]
OK, thanks. I am getting the information now from the create table
statements
and sofar that seems to work OK. Just wanted to make sure there wasn't a
better
way to handle this.
RBS
On Wed, Jan 3, 2018 at 11:08 AM, Richard Hipp wrote:
> On 1/3/18, Bart Smissaert wrote:
> > Is there a way with
On 2018/01/03 12:15 PM, Bart Smissaert wrote:
Is there a way with pragma table_info or otherwise (other than parsing the
table create statement from SQLite_master) to get the column names
including the column delimiters, eg double quotes or square brackets? So I
would get eg: [column1] [column2]
delimiters delimit, so they are not part of the context.. such information
aobut delimiters is never saved... since they havce done their job
delimiiting already.
Why do you want this?
On Wed, Jan 3, 2018 at 2:50 AM, Bart Smissaert
wrote:
> > What are column delimiters?
>
> create table [table
On 1/3/18, Bart Smissaert wrote:
> Is there a way with pragma table_info or otherwise (other than parsing the
> table create statement from SQLite_master) to get the column names
> including the column delimiters, eg double quotes or square brackets? So I
> would get eg: [column1] [column2] etc. i
> What are column delimiters?
create table [table1)([ID] integer, [text_field] text)
I am talking about the square brackets here surrounding the field names.
Sorry, used the wrong word in saying delimiters.
RBS
On Wed, Jan 3, 2018 at 10:44 AM, Luuk wrote:
>
>
> On 03-01-18 11:15, Bart Smissae
On 03-01-18 11:15, Bart Smissaert wrote:
> Is there a way with pragma table_info or otherwise (other than parsing the
> table create statement from SQLite_master) to get the column names
> including the column delimiters, eg double quotes or square brackets? So I
> would get eg: [column1] [column
Is there a way with pragma table_info or otherwise (other than parsing the
table create statement from SQLite_master) to get the column names
including the column delimiters, eg double quotes or square brackets? So I
would get eg: [column1] [column2] etc. if indeed the column names were
delimited l
8 matches
Mail list logo