Not an answer to what is wrong with your call to get the metadata, however, the
information is all available from SQL.
Data Catalog Views:
drop view SysIndexColumns;
drop view SysIndexes;
drop view SysColumns;
drop view SysObjects;
create view if not exists SysObjects
as
select type as ObjectType,
name as ObjectName
from sqlite_master
where type in ('table', 'view', 'index');
create view if not exists SysColumns
as
select ObjectType,
ObjectName,
cid as ColumnID,
name as ColumnName,
type as Affinity,
"notnull" as IsNotNull,
dflt_value as DefaultValue,
pk as IsPrimaryKey
from SysObjects
join pragma_table_info(ObjectName);
create view if not exists SysIndexes
as
select ObjectType,
ObjectName,
name as IndexName,
seq as IndexID,
"unique" as IsUniqueIndex,
origin as IndexOrigin,
partial as IsPartialIndex
from SysObjects
join pragma_index_list(ObjectName);
create view if not exists SysIndexColumns
as
select ObjectType,
ObjectName,
IndexName,
seqno as IndexColumnSequence,
cid as ColumnID,
name as ColumnName,
"desc" as IsDescendingOrder,
coll as Collation,
key as IsPartOfKey
from SysIndexes
join pragma_index_xinfo(IndexName);
Then
select O.*
from SysColumns as O
where ObjectType == 'table'
and IsPrimaryKey == 1
and Affinity == 'integer'
and not exists (select 1
from SysColumns as I
where I.ObjectType == O.ObjectType
and I.ObjectName == O.ObjectName
and I.IsPrimaryKey > 1);
will return all the 'INTEGER PRIMARY KEY' in the "main" database ...
I do not know what it does for "without rowid" tables where there is a single
field declared as "integer primary key", if you have some of those you will
have to figure it out (and how to eliminate them if you want to do so) yourself.
---
The fact that there's a Highway to Hell but only a Stairway to Heaven says a
lot about anticipated traffic volume.
>-----Original Message-----
>From: sqlite-users [mailto:sqlite-users-
>boun...@mailinglists.sqlite.org] On Behalf Of Bart Smissaert
>Sent: Sunday, 26 November, 2017 13:14
>To: SQLite mailing list
>Subject: Re: [sqlite] How to use sqlite3_table_column_metadata?
>
>I am passing a pointer to UTF encoded strings and the passed table
>and
>column do exist.
>There must be something wrong in my code.
>
>RBS
>
>
>
>
>On Sun, Nov 26, 2017 at 7:56 PM, Clemens Ladisch <clem...@ladisch.de>
>wrote:
>
>> Bart Smissaert wrote:
>> > Having some difficulty using sqlite3_table_column_metadata, used
>from
>> VB6.
>> >
>> > I keep getting a zero for the first output argument (should be
>pointer
>> to declared data type string)
>> > and the return value of the function keeps giving 1.
>>
>> The documentation
><http://www.sqlite.org/c3ref/table_column_metadata.html>
>> says:
>> | The sqlite3_table_column_metadata() interface returns
>SQLITE_ERROR and
>> if the specified column does not exist.
>>
>> > Should the tbl_name and column_name also be encoded in UTF8?
>>
>> In SQLite, pretty much all strings are UTF-8.
>>
>>
>> Regards,
>> Clemens
>> _______________________________________________
>> sqlite-users mailing list
>> sqlite-users@mailinglists.sqlite.org
>> http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-
>users
>>
>_______________________________________________
>sqlite-users mailing list
>sqlite-users@mailinglists.sqlite.org
>http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users
_______________________________________________
sqlite-users mailing list
sqlite-users@mailinglists.sqlite.org
http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users
