date initialization in table creation (Posted by DEREK DODOO) - www.foxite.com

From: DEREK DODOO

Tags

date initialization in table creation DEREK DODOO date initialization creation

Subject:	date initialization in table creation
Thread ID:	232169	Message ID:	232169	# Views:	31	# Ratings:	0
Version:	Visual FoxPro 6		Category:	Databases, Tables and SQL Server
Date:	Saturday, June 20, 2009 9:40:21 AM

Dear Expert,

In the creation of a table, how do you initialize a date field

For instance;

The character fields have 'NULL' placed after them

<B> CREATE TABLE NEW_TABLE ( IDNO C(6) NULL, DATE_CURR D ___)</B>

What do you place after a date field ?

Thanks

Tip: click here to scan for Windows Registry Errors and Optimize PC performance

COMPLETE THREAD

date initialization in table creation Posted by DEREK DODOO @ 6/20/2009 9:40:21 AM

RE: date initialization in table creation Posted by Borislav Borissov @ 6/20/2009 9:48:58 AM

RE: date initialization in table creation Posted by Ammar Hadi @ 6/20/2009 10:38:04 AM

RE: date initialization in table creation Posted by Cetin Basoz @ 6/20/2009 5:14:45 PM