Wrox Programmer Forums
Go Back   Wrox Programmer Forums > Visual Basic > VB 6 Visual Basic 6 > VB Databases Basics
VB Databases Basics Beginning-level VB coding questions specific to using VB with databases. Issues not specific to database use will be redirected to other forums.
Welcome to the p2p.wrox.com Forums.

You are currently viewing the VB Databases Basics section of the Wrox Programmer to Programmer discussions. This is a community of software programmers and website developers including Wrox book authors and readers. New member registration was closed in 2019. New posts were shut off and the site was archived into this static format as of October 1, 2020. If you require technical support for a Wrox book please contact http://hub.wiley.com
Old March 7th, 2008, 05:33 AM
Registered User
Join Date: Mar 2008
Posts: 1
Thanks: 0
Thanked 0 Times in 0 Posts
Send a message via Yahoo to sri_k47
Default How dowe mention Dataset to use the default values


what i was trying to do is, i am using Dataset to populate data and update the database. The problem is i have a column which is of type Varchar(1), doesn't accept Nulls and default value is 0

when i insert a row through SQL and if i don't enter any value, it inserts 0 but when i try to do the same using Dataset it doesn't seem to be picking the default value and displaying an error message "A value must be entered in the column"

Can someone please advise about how to make dataset insert mentioned default value if we don't provide a value to the column

Please let me know if you need more info

thanks heaps

Similar Threads
Thread Thread Starter Forum Replies Last Post
Default Field Values tachtenberg Reporting Services 1 February 19th, 2008 05:52 PM
Default Values On Fields hossrad SQL Server 2005 2 May 15th, 2007 02:27 AM
Default values in XMLSchema johnnyclock BOOK: Beginning XML 3rd Edition 0 February 3rd, 2006 06:06 PM
Default values? Raymie_C Access VBA 2 May 16th, 2005 11:48 AM
Default Values davest Access VBA 2 October 19th, 2004 05:57 AM

Powered by vBulletin®
Copyright ©2000 - 2020, Jelsoft Enterprises Ltd.
Copyright (c) 2020 John Wiley & Sons, Inc.