>>CLOSE all >> >>CREATE CURSOR PreXtab (row C(10), col C(10), data C(10)) >> >>INSERT INTO PreXtab (row, col, data) ; >>VALUES ('Shoe Size', 'cust1', '8') >>INSERT INTO PreXtab (row, col, data) ; >>VALUES ('Birth Date', 'cust1', '1/1/90') >>INSERT INTO PreXtab (row, col, data) ; >>VALUES ('cat name', 'cust1', 'sue') >>INSERT INTO PreXtab (row, col, data) ; >>VALUES ('Shoe Size', 'cust2', '9') >>INSERT INTO PreXtab (row, col, data) ; >>VALUES ('Birth Date', 'cust2', '1/1/89') >>INSERT INTO PreXtab (row, col, data) ; >>VALUES ('cat name', 'cust2', 'alex') >>INSERT INTO PreXtab (row, col, data) ; >>VALUES ('Shoe Size', 'cust3', '11') >>INSERT INTO PreXtab (row, col, data) ; >>VALUES ('Birth Date', 'cust3', '1/1/88') >>INSERT INTO PreXtab (row, col, data) ; >>VALUES ('cat name', 'cust3', 'ruffles') >> >>DO HOME() + "VFPXTab" WITH "RawXTab",.T.,.F.,.T.,1,2,3,.F.,0,.T.>>
>>INSERT INTO PreXtab (row, col, data) ; >>VALUES ('Shoe Size', '19900101cust1', '8') >>>>
>>substr(field(1),9) >>>>