I'm using Vfp with SqlServer2000 and im having problem
with data types. I want to store values from simple 1 to
999999999.0000 in a single Sql type. So...
Float replaced with value 0.6 returns to foxpro as 0.59999...

Im copying a database to a diffrent directory runtime, using copy structure
and then appending the values of the tables to my copy.
When i try to append the values of a tables containing a CK i get this
error: "Uniqueness of index MG_CK is violated."

Hey Experts.
Ive got a question for anyone willing to answer.
im appending data to an empty table from a table containing triggers. it
wont complete and i figured its because of the triggers.

hey again.
I need to know the names of my indexes of a table.
is there a way to do this?
ive searched the vfp help like a maniac but no results.

Dear Group,
is there any quick way to get a list of RI from a dbc (vfp6)?
TIA
Peter

I have distributed an application using a DBC as a data store. Have used fox since 2.6 but usure how to code a database structure change when using a table in a dbc. Anyone suggest any articles/help on this. Used to send a new structure and append in using an upgrade prog but I ...

I am building an application that will need to access the tables in a
VFP app via ADO.  I am having a hard time opening the VFP tables such
that the indexes are updated when I issue update, insert, etc. commands
via ADO.

hey,  im kinda new to foxpro and im having a problem.
I need to export or copy a database from one folder to another. i got no
problem doing this with free tabels but with a database im totally lost.
I need all triggers and procedures too, and i need to do this runtime.

Hi al
I have a major database problem in my hands and I just don't know how to resolve it
My application has been created using VB 6.0 connecting to VFP6.0 database using MS VFP ODBC driver. I have 3 major tables in the database
1. CustomerInfo (Parent table/CustId as prime key

We are receiving consistent erros since we switched our application to VFP 8 that memo files are corrupted and unusable. When you try to open the database in VFP 8 we get the error. Open the exact same database in VFP 6 and no error is reported and the database is usable. So we ...

Friends,
Whenever I open a form with private data session, it displays few lines like
"selected 1 record in 0.01 seconds" message on the form behind it, I.e., the
form where I clicked to start this form. This does not happen with default

I created an SqlView on SqlServer remote table with identity column.
The code is:
Select 0
Use myView

I would like to use general fields in my database to store Word / Excel
documents and use them with OLE bound controls so that the user can just
click a button to open / edit the document in place without worrying where
the document is stored etc. The problem is I find them VERY ...

     In one of my apps the following code is called at runtime startup if
an index tag needs changing:-
     proc Revis23
     select (FName) && already opened exclusively

With DBGETPROP I can get properties of fields in a remote view if I know
the field names, but I don't see any way given a remote view name to get
the list of fields in that view.  I want to get the list of fields
without USEing the remote view.