PureBasic Forums - English

Only because I'm extremely lazy (apologies to AZJIO): Macro IIF(_expr, _truepart, _falsepart)
IIFX(Bool(_expr), _truepart, _falsepart)
EndMacro

Procedure.s IIFX(expr, truepart.s, falsepart.s)
If expr
ProcedureReturn truepart
Else
ProcedureReturn falsepart
EndIf
EndProcedure

Global result.s ...

Thanks for your fast reply.

I did try #EM_GETPASSWORDCHAR and guess what it returns? '*' :D

I did find a way to cheat by changing the font to Wingdings and using one of the black dot characters in that font, then switching back to the default font when showing the actual password characters. It ...

@Axolotl,

Thank you! Your tip about about #EM_SETPASSWORDCHAR is exactly what I need.

One question - do you know how I can do this in an ancient ASCII (not UNICODE) executable?
I would have thought that passing the correct value as wParam should be all that's required, but I can't get it to work ...

I'm glad that miso's solution worked, but I don't think it's because of the semicolon at the end of the SQL statement.
I use SQLite extensively without the trailing semicolon and it works fine.

I think the reason miso's code worked is that he used double quotes (") around the SQL statement, which ...

Thank you - this is really clever!

As you said, it doesn't enforce the use of the correct type, but it makes your code much more self-documenting.
It makes the C programmer in me very happy!

Is it possible to open an existing excel file to continue writing in it using Excelwriter.pb?

No - it can only create a new Excel file and write to it. It doesn't have any code to open an existing file.

Not official, but how about

Waiting anxiously...

Hi @Zapman,

Thanks for the code update and the arrow options. I noticed one problem:

When either of the "show arrows" options are selected, clicking on the same column header alternates between ascending and descending sort, as expected.

However, if "don't show arrows" is selected, the first ...

In the US, GetLocaleInfo_() returns "M/d/yyyy" on my PC.

When your code reformats that it yields "%m/%d/%yyyy" instead of "%mm/%dd/%yyyy", so the dates are not displayed correctly.

Cyllceaux wrote: Mon Feb 17, 2025 10:56 am How about www.baremetalsoft.com/baregrep ?

246KB

This (and the companion program BareTail) are AMAZING pieces of software!
Thank you for pointing them out.

@ar-s,

This is really nice! I put it on the mini PC I use as a music server attached to my stereo system and enjoyed listening to it over the weekend.

On some streams, it performed better than a full music player application, with no drop-outs or interruptions.

Would you consider a few requests ...

dumb question what's wrong with this query string?

CREATE TABLE customers (id INTEGER PRIMARY KEY, customerid CHAR(64), firstname CHAR(64), lastname CHAR(64), company CHAR(64), city, CHAR(64), country CHAR(64), phone1 CHAR(64), phone2 CHAR(64), email CHAR(128), subscriptiondate CHAR(64 ...

This is indeed impressive, but I think zooming in/out with the mouse scroll wheel is not working correctly.

This statement WheelDelta = GetSystemMetrics_(#SM_MOUSEWHEELPIXELS) doesn't return the number of clicks the user has scrolled the mouse wheel. It just returns 1 (#True) to indicate that the ...

ChrisR,

Your code produces the best looking result on Win 11 IMHO.
The header row is clearly defined with a different color than the rest of the control and there are no "buttons" to click!

It also works fine with my standard trick of setting the header font to bold.

Thank you!