Following are the RGB long values for the common colors
Thursday, 27 April 2017
List of PowerBuilder Sites
These are the links which I have gone through and noted it down. I will update it whenever I log into new sites. If you have some links that you would like to share with all, please send me those using the Message box located on right side bottom of this page.
PB Pages
- PowerBuilder Developers' Resource - Sequel's Sandbox
- Ken Howe's PowerBuilder Tips
- PowerBuilder WebRing
- Woodger Computing Inc. - PB Tips
- Tips for PowerBuilder 5, 6, 7, 8
- Powerbuilder Tips and Experience
- OOcities
- PowerBuilder Tips & Tricks
- PowerBuilder Online Training Courses -
- Eric Aling's Home & PowerBuilder Page
- Dasche Developer Journal
- Paul's random musings... | Just another WordPress.com weblog
- PowerBuilder Help Code
- PowerBuilder API
- Powerbuilder - GeNi's bulk
- PowerBuilder Tips - Reocites
- PowerBuilder - Sebastien Kirche
- Romu Software
- Desta Ltd. DWXLS
- Onkies PowerBuilder Page
- Topwiz Software - Home
- Guru PowerBuilder Blogspot
- PowerBuilder Q & A
- Tutorials articles - Tutorials to .com
- PowerBuilder Evangelist
- PowerBuilder Central - News
- Elegant Code Club
- bcarter.com - Mobile Database Solutions
- DVL Software: PowerBuilder Tips
- Powerbuilder Computer Portal
- Powerbuilder Notes
- PowerBuilder - PowerObject! Shekar Reddy
- How to Solve That : Powerbuilder Tutorial and Tips & Tricks: Powerbuilder Function
- Do All With PB
- Introduction to Powerbuilder | Power to Build
- PowerBuilder-Centric
- Powerbuilder World: INI file with Pb
- My Powerbuilder Blog
- PowerBuilder 6 Unleashed -- Table of Contents
- Woodger Computing Inc. - PowerBuilder Topics
- Powerbuilder Interview Questions - All Interview Questions
- Powerbuilder : Introduction
- PBMiner Sources
- dwox - Home of DW Ripper, the undocumented PBL File Format and PB Web Easy
- Powerbuilder Tutorials
- powerbuilder | David's Blog
- Powerbuilder Functions: 07/11/09
- PowerBuilder 9.0 Index Page - Helpdoc-online
- Hodentek
- PowerBuilder Users List
- DATAWINDOW VALIDATION
- Producing JSON Documents from SQL Server queries via TSQL
- Outer Joins OJ
- "?" button in title bar
- MySQL Linked Server on SQL Server 2008 | PACKT Books
- PFC Guide http://www.pfcguide.com/extensions/
- PowerScript Tips
- Basics of PowerBuilder
- Bruce Armstrong's blog
- Chilkat ActiveX
Database
- Interactive SQL keyboard shortcuts
- SQL Anywhere error messages
- SQL Server Performance Tips and Guidelines - CodeProject
- Configuring SQL Anywhere services
- SQL Anywhere Blog
- Sybase Basic Tutorial
- change server level collation for a SQL Server Instance
Adding a column in CrossTab Datawindow
To add a New Column
To Add a new column in CrossTab Datawindow without changing the layout the most efficient way is to use Edit Source. Following are the steps.
To Add a new column in CrossTab Datawindow without changing the layout the most efficient way is to use Edit Source. Following are the steps.
- Go to EditSource mode of the Datawindow
- Add the Colum Definition:
- Add the column on SQL
- Add the sorting
- Create the Column parameters
- Create the header parameters
- Add the column name to , columns and sources and "sprase" at the end of the Edit source.
- Save the Changes. That's it.
Thursday, 20 April 2017
Grant Persmission for All Table and Procedures in a Database
Execute the following code, it will give your the output as the statements. Copy those statements and execute it. All the procedures and Table will get Grant Permission in few minutes
Code to Get the Script for Procedure.
SELECT
' Grant Execute on '+s.name+'.'+pr.name +' to UserGroup1
FROM
sys.procedures pr
INNER JOIN
sys.schemas s ON pr.schema_id = s.schema_id;
Code to Get the Script for Tables
SELECT
'Grant Select,Insert,update,Alter,References,Delete on '+s.name+'.'+t.name+' to UserGroup1'
FROM sys.tables AS t
INNER JOIN sys.schemas AS s
ON t.[schema_id] = s.[schema_id]
WHERE t.name like 'p_%'
Code to Get the Script for Procedure.
SELECT
' Grant Execute on '+s.name+'.'+pr.name +' to UserGroup1
FROM
sys.procedures pr
INNER JOIN
sys.schemas s ON pr.schema_id = s.schema_id;
Code to Get the Script for Tables
SELECT
'Grant Select,Insert,update,Alter,References,Delete on '+s.name+'.'+t.name+' to UserGroup1'
FROM sys.tables AS t
INNER JOIN sys.schemas AS s
ON t.[schema_id] = s.[schema_id]
WHERE t.name like 'p_%'
Duplicate Rows Deletion
Simple Query to Delete the Duplicate Rows Using CTE Table:
WITH CTE AS (SELECT *,ROW_NUMBER() OVER(PARTITION BY unique_column ORDER BY col2) as 'RankNo'
FROM Table)
DELETE FROM CTE
WHERE RankNo > 1
WITH CTE AS (SELECT *,ROW_NUMBER() OVER(PARTITION BY unique_column ORDER BY col2) as 'RankNo'
FROM Table)
DELETE FROM CTE
WHERE RankNo > 1
Subscribe to:
Posts (Atom)