[dba-SQLServer]Deleting Dates

paul.hartland at fsmail.net paul.hartland at fsmail.net
Mon Feb 17 07:48:09 CST 2003


To all,

I have a Visual Basic 6 front-end which is currently linked into a SQL Server 7.0 back-end, I have a table called tblPersonnel in the BE which has a form on the VB6 FE.  We take on temporary staff a certain points of the year to help with the workload, and when they finish we enter a finish date for that particualr person....No problem so far......However if they have proved themselves to be a good worker, they get invited back whenever we need the additional staff (saving on re-training etc).  But I can seem to get the system to allow me to take out a finish date (making it null again).....

The tblPersonnel.Finishdate field will allow Nulls, and I'm using the ADODC DataControl with a text box linked to the Control and Field FinishDate........

Anyone had similar problems or can tell me how to reset the FinishDate to null 

Thanks in advance for any help..........

Paul 

__________________________________________________________________________
Freeserve AnyTime - Go online whenever you want for just £6.99 a month for
your first 3 months, that's HALF PRICE! And then it's just £13.99 a month
after that.

For more information visit http://www.freeserve.com/time/ or call free on 
0800 970 8890





More information about the dba-SQLServer mailing list