Mike Lewis
Programmer
I feel a bit embarrassed posting this, but I have been staring at it for hours and I can't see what I am doing wrong.
What I am trying to achieve
To create a table and to populate it with certain character data.
What I have got so far
The following is the minimum code needed to demonstrate the problem.
Expected result
I expect the code to create the CardPack table, and to populate it with three records. The ID, Ref and Tested fields will all be blank. The English and French fields will contain the specified strings.
Actual result
The CardPack table is correctly created. The csrNew cursor is correctly created and populated with the specified strings. Three records are correctly added to the CardPack table. But all five fields in those records are blank. In other words, it is not picking up the English and French strings.
No doubt another pair of eyes will see what my stupid mistake is.
Mike
__________________________________
Mike Lewis (Edinburgh, Scotland)
Visual FoxPro articles, tips and downloads
What I am trying to achieve
To create a table and to populate it with certain character data.
What I have got so far
The following is the minimum code needed to demonstrate the problem.
Code:
CREATE TABLE CardPack ;
(ID I, Ref I, English C(32), French C(32), Tested D)
CREATE CURSOR csrNew (TextE C(32), TextF C(32))
INSERT INTO csrNew (TextE, TextF) VALUES ("cosy", "douillet")
INSERT INTO csrNew (TextE, TextF) VALUES ("old-fashioned", "désuète")
INSERT INTO csrNew (TextE, TextF) VALUES ("flourishing", "florissant")
SELECT CardPack
APPEND FROM DBF("csrNew") FIELDS English, French
BROWSE
Expected result
I expect the code to create the CardPack table, and to populate it with three records. The ID, Ref and Tested fields will all be blank. The English and French fields will contain the specified strings.
Actual result
The CardPack table is correctly created. The csrNew cursor is correctly created and populated with the specified strings. Three records are correctly added to the CardPack table. But all five fields in those records are blank. In other words, it is not picking up the English and French strings.
No doubt another pair of eyes will see what my stupid mistake is.
Mike
__________________________________
Mike Lewis (Edinburgh, Scotland)
Visual FoxPro articles, tips and downloads