All VFP data types are one character long. If you supply more than one character, only the first one is taken and the rest is ignored.
...
del_dt T,;
...
You can use < pre > and < /pre > tags (w/o) spaces to preserve formatting of your code.
>I am using the following to create a new table:
>For date field i am doing datetime: but nothings happening it is still showing just date, after i run the following code:
>Can you please tell me how i can create a field with datetime(8):
>CREATE TABLE (mDataPath+'DOCUDEL.DBF') FREE (DOC_DEL_ID N(10, 0) NOT NULL,;
> del_by C(40),;
> del_dt Datetime( 8),;
> proj_no C(15),;
> workpkg_no C(15),;
> file_name C(75),;
> file_loc C(150))
>Thank you very much.
--sb--