Same results in VFP9 even though vFP9 now allows the use of long data type name. e.g., varchar(20), number(10,2), currency, etc). If VFP does not recognize the long data type name, it will use the first letter in the name. By design, I would say.
>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.
Mark McCasland
Midlothian, TX USA