Hi Grigore,

I would say that whether this is a bug or not, depends on how you define a bug. Since a date field is declared by the letter D, I guess everything between the D and the next field name is simply ignored. In my opinion VFP should raise an error in this case.

>Hi, everyone
>
>Yesterday I was converting a MS SQL script into a VFP Create Cursor command. The script creates tables and I changed it to create VFP cursors. One of the lines in the original script was
>
>CREATE TABLE MyTable (MyField DECIMAL(10,2)).
>
>Surprise, surprise. The above command, modified as CREATE CURSOR MyCursor (MyField DECIMAL(10,2)) does not error, but instead creates a DATE datatype field. Not to mention it took me half of a day to find what the problem is (INSERTS failed constantly and I had thousands of fields in the script).
>
>Further investigations shown that
>
>

>CREATE CURSOR MyCursor (MyField DOLGHIN(10,2))
>

>
>does not error, but instead creates a DATE field in the cursor.
>
>Is this a bug or a known issue?
>
>
>Thank you.