Hello,
Using PB 2022 R3 with SQLite 3
When we retrieve data in a datawindow from SQLite database, all (numeric) computed columns are retrieved as character fields. And converting the character values into numeric and then doing the required computation takes time. Otherwise, the performance of the query is really fast (tested with limited data, as we plan to use for that level of data only). I think, if datawindow could transfer those numeric values as numeric values, I feel that the performance will be much better.
And in one of my threads, Roland has recommended to write entries in pbodb.ini file. I don't have any experience in that. Can someone give me idea how to write entries in that file. say should I start with
[SQLite] OR
[SQLite 3] OR
[SQLite 3.2] OR
something else...
How to check whether that entries are being taken by Powerbuilder / Datawindow ?
Any idea / guidance is really appreciated.
Happiness Always
BKR Sivaprakash
So far, I've read that MySQL and Informix are not supported by PowerBuilder. But your link says otherwise.
And I know that SQLite is not supported by PowerBuilder. Since we use ODBC to connect SQLite, I thought some entries in ODB.ini file could do some trick.