(Bob Watkins) Oracle’s Virtual Private Database (VPD) feature (also called Fine Grained Access Control) provides row-level security checking for DML statements such as SELECT. A PL/SQL policy function is associated with a table; the function can examine the current user context and return additional
Author: SSWUG Research
How To Group ListView Items with ListViewGroup VB2005
(Mike McIntyre) This article with source code demonstrates how to group ListView Items with the ListViewGroup class and Visual Basic 2005. In the article example, customers are loaded from a database and three groups are created – customer name, region, and country.
How to Print a Document from SQL Stored Procedure
(aleksisa) There’re many different ways of pulling data out of the database and then format/print it according to your needs. The code bellow allows you to print a document from a stored procedure using a SQL OLE and VB DLL.
XForms tip: Using extension functions with Firefox
(Tyler Anderson) XForms with Firefox has extension functions that aid your development of JavaScript with XForms. These functions allow you to access your XForms instance data with ease, enabling you to do cool stuff with your XForms, including creating dynamic XForms code. The goal of this tip is t
SQL Server Excel Workbench
(Robyn Page and Phil Factor) Phil and I have teamed up on this workbench, which demonstrates how to create, read, update and delete information in Excel using T-SQL, from SQL Server. As always, the workbench is structured so that it can be pasted into Query Analyser and SSMS, and the individual exa
IBM Offers Free Sales Help For Open Source Developers
(Paul McDougall) In an effort to bolster use of its open source middleware and license-free database software, IBM said it will provide free sales and marketing support to developers who create products for those offerings.
Directives, Access, and More with the Oracle HTTP Server
(Sam Alapati) In addition to the many OHS configuration directives you have learned about so far, Oracle HTTP Server provides two special directives, Options and AllowOverride, which you can use to allow or disable several features of the Oracle HTTP Server.
Another short comment on V8 CPU usage
(Willie Favero) Sometimes what is measured isn’t always what you think it is; isn’t always an accurate picture of what is going on. So is the case with CPU regression. If you are comparing accounting information from Version 7 to the CPU being used by Version 8, and an increase in CPU is measured, i
Forms, Controls, and Other Useful Objects
(Tim Patrick and John Clark Craig) If you are writing a desktop application, you are dealing with forms and controls. Since its first release, Visual Basic has made the dream of drag-and-drop programming possible: just add some controls to a form, press F5, and go.
Creating Custom Configuration Sections in Web.config
(Scott Mitchell) Most ASP.NET applications include a number of configuration settings, such as connection strings, mail server settings, system-wide default settings, and so forth. While these settings could be hard-coded in the source code, it’s usually a wiser idea to place them in a configuration