I have just upgraded to VFP 9.0
But when I print DBF structure using the command :
LIST STRUCTURE TO PRINTER
it also shows additional columns - Next & Step.

Can any one give me any suggestions on how to create a random number
generator given a seed, max value and min value.  I want the return
value to be an integer.
Thanks

I'm trying to index a table on a field from within the program on a table
that has table buffering. When I do this it gives me an error saying that I
can't index on a file that has table buffering. Can somebody give me
alternate way of indexing on a table that is in buffer mode?

If you make a view updatable, where is this code stored and how can you
extract it in order to put it into a .PRG
tia
Marc

I am not so familiar with VFP. I have an VFP-Database, which use a
variable (MyVariable) in a trigger. I want to set a value for this
MyVariable in the SQL-Statement (e.g. used from MS-Querry).
So i am looking for a sql-expression like:

I'm trying to convert a SQL Server table which has uniqueidentifier column
into a VFP 9 table.  I wonder whether I should use autoincremented field or
write a routine to increment the integer.
Thansk for any help.

It seems to me that if I issue a SQL statement such as select * from tableX
and tableX is not in the current dbc, the SQL statement will search for
tableX based on the path of the current dbc.  So, if the current dbc is
located in c:\vfp\test, the SQL statement will search for ...

I want to know what other information are stored in dbc besides the ones that
can be listed by using List Database.
1.  Does dbc contain something like record counter or table length for each
dbf?

I'm using gendbc to generate the prg for a dbc but it seems that gendbc
requires the dbc to be not read-only.  I don't understand why gendbc needs to
update the dbc since I assume that gendbc is just pulling info from the dbc.  
What does gendbc update in the dbc?

      I'm using VC++'s ODBC to connect to Visual Foxpro's database.
      when i try to create table , the table is created (in file
      <table_name>.dbf) but when i open the created .dbf file , FoxPro will
      open the database but i cant see the table being created.

I'm trying to find a command in VFP6 to do this but i'm sure if one exists.
I hope somebody can help me out.
Is there a command that tells me if there's any data in a table buffer that
hasn't been written to the table with the TABLEUPDATE() command? I want to

We are trying to install the oledb driver to setup odbc on the machines at
this site but when we try to select and use the driver it errors saying that
we need to get the current version. We do so but it still errors with the
same message...?

I have a simple COM that works with web pages that checks account
information, returns prices for jobs and does other basic stuff.  However, I
now need the COM to be able to return data to an ASP page for tracking job
status etc and I don't have a clue how best to do this.  The ...

I'm looking at the SQL statement of a remoteview to a SQL Server table
through View SQL of the View Designer and the prg generated from gendbc.  I
notice that some Date fields are showing having  DataType D  or DataType
D(8).   What is the difference between DataType D and ...

I want to know whether there is any freeware to compare 2 foxpro dbcs.  
Currently, I use gendbc.prg to generate the prg for each dbc and then compare
the prgs.
Thanks.