Dear sir or Ma’am,
I am working at Project 12-Ways, Southern Illinois University at Carbondale. My current assignment is to write a program using Visual Foxpro 3.0 for Macintosh.
I have also a few questions I would like to get help from you:
1). I am using an application built by an ex-programmer on my position using FoxPro 2.6 on a Power Macintosh with 16M Ram. Since query was not programmed, I opened tables and read them directly, which crashed the machine a few times causing a lot of data loss. Could you give me some possible reasons for this?
2). On two occasions, I input a lot of data into tables without quitting the application. When I tried to save the data, the machine crashed. I had to restart the computer, but the application went dead again. It kept telling me “No table in use.” Could you tell me what is possibly wrong?
3). I appended some records from one table to another. Sometimes, the records are appended, but sometimes they are not. What is even stranger is when I checked the records, they were appended. Later, when I checked them again, they disappeared. These tables are indexed.
4). I wrote a program with version 2.6. When I ran it, the machine constantly asks me “Cancel? Ignore or Suspend?” Why?
5). Since in our work we need to graph routinely. I want to generate a click-button selection method to produce all of the graphs without modifications. I am trying to use FoxPro 3.0 to make graphs programmatically. No graph but an empty window poped up, although I used the following programming commands
open database p12ways:midi:midi:mide.dbc exclusive
select date, pvplus, pvminus from adult INTO cursor query
do (_GENGRAPH) with “AUTOGRAPH”, 1,1,”Affect”,.T.,.T.,.T.,”YY”,.F.
6). I need to use two tables to produce a report. Both tables have multiple records (One has four and the other has five.). I can put the information from one table into the detail part of the report. How can I put the infromation from the other table into the same report?
7). Can you give me a complete example of main program without using object-oriented programming so that I will know which aspect I need to consider.

Thank you very much for your help.