1. Sivaprakash BKR
  2. PowerBuilder
  3. Friday, 17 May 2024 12:59 PM UTC

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

 

Chris Pollach @Appeon Accepted Answer Pending Moderation
  1. Friday, 17 May 2024 14:12 PM UTC
  2. PowerBuilder
  3. # 1

Hi BKR ;

  PB supports only supports the following DBMS & versions ...

https://docs.appeon.com/ps2022r3/Supported_dbtypes_versions.html

Regards .. Chris

Comment
  1. Sivaprakash BKR
  2. Tuesday, 21 May 2024 05:55 AM UTC
Thanks Chris,

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.
  1. Helpful
  1. Chris Pollach @Appeon
  2. Tuesday, 21 May 2024 21:19 PM UTC
I am confused .. in the link I gave you both MySQL and Informix ARE supported
  1. Helpful
There are no comments made yet.
  • Page :
  • 1


There are no replies made for this question yet.
However, you are not allowed to reply to this question.
We use cookies which are necessary for the proper functioning of our websites. We also use cookies to analyze our traffic, improve your experience and provide social media features. If you continue to use this site, you consent to our use of cookies.