>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 could not find product ID anywhere, though we really bought the authentic version. I would appreciate it if you could help find the product ID which I know is necessary to get technical support from you.

You mean MS Tech support I think. Here you don't need to tell ID. But you can learn it by selecting About in help (think Mac is same).

> 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?

Directly ? How deep direct ? As far as lowlevel ? I would suggest you to read an SQL copy. Many things you could cause by direct read (ie:browse) for you would fire whens, valids...

>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?

Probably some code is closing tables or changing workarea.

>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.

Are you using buffering ? Is this 3.0 or 2.x Base table or view ?

>4). I wrote a program with version 2.6. When I ran it, the machine constantly asks me “Cancel? Ignore or Suspend?” Why?

This is always accompanied by an error message. What was that ?

>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.

Sorry never use _gengraph and prefer OLE. So don't know those parms. Might it one of those "noshow" ? Also before _gengraph do you check if you have any data to plot with browse ?

>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?

You could use relation, SQL cursor or view. SQL cursor or view are easier to handle.

>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.

Can you elaborate this more. What main program ? A sample ? There are a lot in FP home()+"tutorial" and VFP home()+"samples" dirs. And to get more help on these could you exactly write the version you use and/or will use.
>
>Thank you very much for your help.
Cetin