is there not a way to save this setting in VFP8.0 so I don't have to enable
it every time I start up the app? Can I save it as a default somehow. I
tried typing it in the command window, going to tools, options and choosing
set as default to see if that would work but it doesn't.

I need a Query
I have 4 tables:
       A Student Table
           Containing    Student Name

I use a parametrized view to present data for the report. When I call
for it for the first time, it's all right, but when I change the
parameter variable to print a different data subset, the result view
doesn't change. More than that, if the data in source tables had

Hi, all. I'm not a FoxPro expert, and I'm looking for some help with a FoxPro 2.5 database.
The table has a lot of fields, I'll show three of them:
Memono Custno Item
1        a     doodad

I am working in Visual Foxpro 6.0
1. Using SELECT - SQL I am creating a cursor.  This cursor is readonly.  How can   I make it modifiable using the same sql command ?
2. In the help of SELECT - SQL I came to know that READWRITE clause can be used to make it modifiable.  Is this ...

i want to create remote view and with parameters.
after that how can i call this in my prog.
thanx

Ok, one more configuration question. Is there a way with the configuration
file, the registry or elsewhere to set VFP8.0 so that by default when you
click the "open" icon, that rather than trying to open a project, it has
"program" in the file type box instead? I never open projects ...

I have files that have multiple records per person that is in the file. I
would like to number the record for each person. In other words, if Joe Blow
has 5 records, I would like to have a field called transnum that I can
populate with the transaction number it is for that person. ...

Ordering a recursive table
We have a number of Visual FoxPro databases  and programs that need to
be converted to SQL Server.  One of the tables is recursive and I have
a little program that populates an index field so the table can be

We are converting an application from VFP 7 to VFP 8.
Now code that used to work under VFP7
nHandle=SQLCONNECT(cName,cUserId,cPsw)
pops up the message "Feature Not Available".

I have a VFP8 application that calls a stored procedure that runs the
follwoing TSQL...
update dbo.interview_activity
 set status_filename = @status_filename

After deleting records in a FoxPro table via ODBC, I'd also like to pack the
table.  I've tried simply issuing the command "pack," like you'd do in Visual
FoxPro, but it doesn't work.  Does anybody know how to do this?
-Eric

im using
SQLEXEC(nh,"Select * from order_Trn where order_no="N-4501","order_trn")
after this how can update the data from this result.
actually i never used client server programming.

   I need to call a stored function, not procedure, on an oracle database
with vfp5.  Does anyone know if I can just use a sqlexec(connhandle, "{call
package.function", "returncursor" )  or is it more indepth than this?  The
oracle guys at my clients site have no clue.

I've got a FoxPro table with a memo field in it, and I'm accessing it through
ODBC.  When I execute an insert statement with a string longer than 256 chars
for that field, the query fails.  I've tried it in Visual FoxPro and the same
thing happens.  Does anybody know about this?