B4J Question JSQL - Any way to get the field types?

[B4JExplorer]

Hi,

Working with the JSQL library and the DBUTILs, there doesn't seem to be a way to get the types of the fields. Field names and values are there, but nothing about the types.

Is there another way to do this, in B4J? I care only about Sqlite databases, in this context.

 

[eps]

PRAGMA table_info seems to be the way to go..

http://stackoverflow.com/questions/11753871/getting-the-type-of-a-column-in-sqlite

But I haven't used it..

 

[B4JExplorer]

PRAGMA table_info seems to be the way to go..

http://stackoverflow.com/questions/11753871/getting-the-type-of-a-column-in-sqlite

But I haven't used it..

Yes, I've used it, outside of a B4J context. Ok, that'll work, thanks eps.

 

[Erel]

Check the code in RDCHandler.ExecuteQuery2 (jRDC2). It uses JavaObject to get the column types.

 

[B4JExplorer]

Check the code in RDCHandler.ExecuteQuery2 (jRDC2). It uses JavaObject to get the column types.

Yikes, I missed this one. I'll check it during the week, thanks chief.