SQL tip #2

This one will be singular as its a small tip I just learnt a minute ago.
I am currently converted some Access forms and Reports, and somehow this one record source didn’t work:
SELECT TOP 100 PERCENT pl.PositionID, (SELECT Title FROM atbv_Personnel2_Positions WHERE PositionID = pl.PositionID) AS Title, pl.Percent AS PosPercent, pl.Location, pl.LocationID, p.Name, pl.FromDate, pl.ToDate, ISNULL(pl.MhrsRate, [...]

displaying numbers with thousand separator and .00

On my previous project, I needed to select a number stored in the database, such as 36749384 or 934834.23 which were monetary values, and display them as 36,749,384.00 and 934,834.23. Basically, in monetary terms.
I was thinking of using string manipulation but that would only work in my .net development, so if you need these kinds [...]

SQL tips #1

definitely purely for newbies, helpful tips my colleague in Houston passed on to me, so thanks to Alex, SQL guru.
Playing it safe
This is very useful if you are running SQL that will change data or insert data. So this is how I recently wrote a buncha of SQL codes that would modify menus, [...]

Render HTML tags in DB in ActiveReport pdf or HTML

I had to tackle showing actual HTML formatting that was stored in the DB by our company’s own texteditor which had the basic formatting like bold, italics, font colout etc, and digging around the active reports forum basically just told me I needed to version 4.0+ for it to be automatically rendered in RichTextBox.
The solution that arose from [...]

Mandatory rambling first post

This blog was born out of the necessity of my limited brain to retain all I learn on the job in dealing with technologies alien to me. I am hoping this will become a place I can help others like me who need things explained in simple terms that newbies can understand as well. Some [...]