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.
Grigore Dolghin
Class Software.