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 derfloh on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!
I Cann't connect two databases through foxpro(dos) programming
- Thread starter probir
- Start date
rajeevnandanmishra
Programmer
Hi probir,
As per my best information and knowledge, FoxPro for DOS is having tables only and no databases.
If you are talking about connecting two DBF files then what actually you want to perform. The two dbf's can be open by saying:
SELECT 0
USE DBF1
SELECT 0
USE DBF2
And later on can be refrenced by saying:
SELECT DBF1 or SELECT DBF2
As per my best information and knowledge, FoxPro for DOS is having tables only and no databases.
If you are talking about connecting two DBF files then what actually you want to perform. The two dbf's can be open by saying:
SELECT 0
USE DBF1
SELECT 0
USE DBF2
And later on can be refrenced by saying:
SELECT DBF1 or SELECT DBF2
To connect two tables (first and second),
(simplyest case)
both usually contain same fields, e.g. keyfield.
Second must be "index on keyfield tag keyf",
first "set relation to keyf into second addi".
Skip in first result in corresponding move in second.
What failed ?
(simplyest case)
both usually contain same fields, e.g. keyfield.
Second must be "index on keyfield tag keyf",
first "set relation to keyf into second addi".
Skip in first result in corresponding move in second.
What failed ?
Do Not Forget. The fields in the Parent DBF and the Child Dbf, MUST be the same type (characters works the best) and length but the field name can be different. The biggest reasons most relations do not work correctly is the fact the field lengths are different lengths. David W. Grewe
Dave@internationalbid.com
Dave@internationalbid.com
- Status