Welcome To The Home Of The Visual FoxPro Experts  
home. signup. forum. archives. search. google. articles. downloads. faq. members. weblogs. sponsors. rss.
RE: DATE INITIALIZATION IN TABLE CREATION
 From: Cetin Basoz
  Where is Cetin Basoz?
 Izmir
 Turkey
 Cetin Basoz
 To: DEREK DODOO
  Where is DEREK DODOO?
 READING, UK
 United Kingdom
 DEREK DODOO
 Tags
Subject: RE: date initialization in table creation
Thread ID: 232169 Message ID: 232238 # Views: 28 # Ratings: 0
Version: Visual FoxPro 6 Category: Databases, Tables and SQL Server
Date: Saturday, June 20, 2009 5:14:45 PM         
   

> 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

CREATE TABLE NEW_TABLE ( IDNO C(6) NULL, DATE_CURR D NULL DEFAULT NULL)


Cetin Basoz

.Net has got better.Think about moving - check my blog:
Blog (main)
Blog (mirror)



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