CodeWidgets.com: Online Source Code Library: C#, ASP, ASP.NET, VB, VB.NET, VB Script, Microsoft Access, Excel, JavaScript, J Script, XML, VBScript, Website Design, DevExpress Components, Reporting, Application and Website Templates.

Widget #CS0002

Adding a Default value of zero in a lookup Query (SQL Server)

Free

When no value has been selected in a Combo Dropdown, add a default value of zero to the query as a placeholder.

SELECT CategoryId, Category
FROM dbo.tblCategories
UNION
SELECT 0 AS CategoryId, 'PlaceHolder' AS Category
FROM dbo.tblCategories

Last Updated: 4/11/2018


Related Widgets 
Price 
# 
CS0035 Alternate row colors on reports with Microsoft Access 2000-2016$0.00Add To Cart
CS0036 Microsoft Access Monthly Calendar Report (ACCDB)$10.00Add To Cart
CS0037 Microsoft Access Monthly Calendar Report (MDB)$10.00Add To Cart
CS0005 Pop-Up Search Form Template$18.00Add To Cart
CS0009 ProperCase Function VB 6.0$0.00Add To Cart
CS0001 Universal Navigation Buttons (Microsoft® Access)$10.00Add To Cart

Recently Viewed Widgets 
Price 
# 
No data to display

Collapse/Expand
Format

Plug & Play Code

Copy the Source Code Above..


Collapse/Expand
License

License

PromoWare

Single Developer Licence.
Re-Distribution Permitted only as part of a compiled Application.This source code is provided to you "as is" without warranty.
CLICK HERE FOR TERMS OF USE
Copyright 2000-2018 CodeWidgets.com and Comrie Software Solutions