PureBasic Forums - English

Figured it out... In order to use the external library "libpq.dll" you need the other DLLs listed below. Also note that they all must be in the same directory as your EXE or in the windows PATH.

;Files Needed:
; libpq.dll
; libcrypto-3-x64.dll
; libiconv-2.dll
; libintl-8.dll
; libssl-3-x64.dll ...

Fred wrote: Mon May 19, 2025 8:15 am You should be able to use the official postgresql dll, which one did you tried ?

I got it from this site: https://www.dllme.com/dll/files/libpq
I also tried the 17.0.4 version that ships with PGAdmin.

In PB 6+ you now have the ability to add a "dynamic library" using UsePostgreSQLDatabase([LibraryName$]). The issue is I cannot find any more documentation on this. Help file says if it returns true it worked and false it failed.

I tried UsePostgreSQLDatabase("libpq.dll") with the proper path and ...

If I comment out the DisableGadget parts it works fine. Selection stays highlighted.

Tried that. Here is the code. Did not set the row back to blue. Still a grey.

DisableGadget(ListIcon_Machine_List,#False) ; Allow Clicking on new row after data is loaded.
SetActiveGadget(ListIcon_Machine_List)
SetGadgetItemColor(ListIcon_Machine_List, GetGadgetState(ListIcon_Machine_List), #PB ...

Updated Code with some more options.

;{ Simple Graph }

; Yet another stuff for simple 'visuals'
; 2017 (c) Luna Sole
; v1.0.0.4 (+ mouse interaction)
; Digital32 Updates:
; Original Code - Forum Post: https://www.purebasic.fr/english/viewtopic.php?t=67464&hilit=graph
; 10/18/2023 - Compile ...

I need to DisableGadget(GadgetName, #True) the ListIconGadget while my app updates other data to keep users from clicking on other items in the list. The SetGadgetItemColor does not seem to work when I DisableGadget(GadgetName, #False) the ListIconGadget.

Before the ListIconGadget is disable the ...

@idle Very Impressive with memory compression. Love it. This will work nicely.

I need to do a similar type ahead but I'm dealing with 30k user names. I was thinking the user would need to type at least 3 letters then I could search my list structure and populate the to X in the drop down. Anyone already written code like that?

Marc56us, thanks for the reply. However tasklist CPUTIME shows how much time the process is using on the CPU. Not the actual running time. However this pointed me in the right direction.

I'm using your code but instead of tasklist I'm using WMIC.
This is the WMI Console.
WMI is expensive on the ...

Can the "Kernel32.dll" tell me how long a process had been running. I don't need to kill a process but I do need to make sure certain process have been up and running for XX seconds before I launch other process.

Example:
User Runs (A LARGE App that takes 22 seconds to Launch)
30 Seconds Later I ...

Found the issue. PGAdmin 4 and other query tools ignore "--" that are comments in normal PostgreSQL SQL code.
For some reason DatabaseQuery() calls with the the same "--" are not being ignored by PostgreSQL or the DatabaseQuery.

I'm running PB 5.46LTS and trying to do a query to a PostgreSQL DB. Simple queries with just a select and few where statements come back fine but I have a long SQL statement with a lot of joins and other functions that is not returning the right results. Using PGAdmin 4 the query runs fine. But it ...

I'm using PureBasic 5.44 and talking to a Postgresql database. I'm getting an error "no pg_hba.conf entry for host "172.1xx.xx.x", user "myID", database "MyDB", SSL off”

If I modify the pg_HBA.conf file it will let me in. But this may be a violation of security in my company.

PGAdmin 4 works fine ...

Can this code be used to list VHDs Mounted and Then flush and unmount them?