Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations strongm on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

VFP/FPW table access

Status
Not open for further replies.

NullOp

Programmer
Jan 2, 2004
81
US
I have tables that need to be accessed/updated by VFP programs and FPW programs. What do I need to do on the VFP side to keep the tables accessable by FPW?

Thanks
 

NullOp,

Assuming you originally created the tables in FPW, you need to do the following in VFP:

- Don't put the tables into a DBC

- Don't modify the structure of the tables

- Don't assign a code page to the table when you open it for the first time in VFP.

That way, you'll be able to share the tables between VFP and FPW.

If you created the tables in VFP, you will have to do the following (in VFP):

COPY TO <table name> TYPE FOX2X

Then use the copies in both versions.

Hope this makes sense.

Mike

__________________________________
Mike Lewis (Edinburgh, Scotland)

My sites:
Visual FoxPro (www.ml-consult.demon.co.uk)
Crystal Reports (www.ml-crystal.com)
 
Mike,
Hello. I am using VFP 7.0 and FPW2.6. I know all the FOX2x sutff etc, is it the same with VFP 9?

I'm debating on whether to update to 9 right now, or wait.... or is there a reason to wait.
thanks,
frank
 

Frank,

is there a reason to wait.

The longer you wait, the longer it will be before you start getting the benefits.

By the way, it's not a good idea to tack a new question onto the end of an existing thread. It's better to start your own thread, with a title that reflects the question. That way, more people will see it, and more will contribute to the answer.

Mike

__________________________________
Mike Lewis (Edinburgh, Scotland)

My Visual FoxPro site: www.ml-consult.co.uk
 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top