PDL to Read from a Database Table

[Terry Kellum]

Has anyone been able to create messages from a query into a database table?  I’m trying to be very generic in this question, as this topic would be just as applicable to SQLite as it is to my application MySQL.

My current thinking is about using the skeleton of an async PDL, and only implementing the hci_pd.initialize or hci_pd.open, and just staying in an endless loop in one of these two PDL “fragments”.

Is the hci_pd_accept routine a valid call in the initialize or open states?

Do I have to implement all the TCL callbacks (be they just NOOPs)?

Does anyone have a PDL that reads from a database table that they would be willing to share?

Thanks!!!

Topic

[garry r fisher]

Hi Terry,

Why do you want to use a PDL to access your data source? The simplest way is to put your code in a upoc. I’ve done this a number of times and if you put the results of the query into a csv format you can then process the message how you want.

Regards

Garry

[Rob Abbott]

Garry is right – the UPoC protocol was implemented for ODBC.  I think you would find the read UPoC much easier to use than a PDL 😉

Rob Abbott
Cloverleaf Emeritus

[Author]

Replies