Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Replace TXT
Message
From
03/07/2003 14:46:32
 
General information
Forum:
Visual FoxPro
Category:
Databases,Tables, Views, Indexing and SQL syntax
Title:
Miscellaneous
Thread ID:
00806664
Message ID:
00806679
Views:
13
TEXT... ENDTEXT or SET TEXTERMEGE can Help you to do it.
SET TEXTMERGE TO lcFile NOSHOW 
SCAN
   \ <<YourFistField>>, A literal... <<YourSecondField>>
ENDSCAN
>The parent table is client (fields id and name)

>The child table is products (fields product and id)

>I've created a relation and a form with 2 pages
The first page has the client data and the second page has a grid
with the products of the client
>The job I need is
Select client
go top
frec = recno ()
>Get all the records in table product which is related to the
the record in the parent table
>store to a txt file ( the txt file name will be named &frec)
select client
store skip + 1
>Get all the records in table product which is related to the
the record in the parent table
>... until the end of the table clientes
Apoya a Visual FoxPro usandolo legalmente
--
¸,ø¤º°`°º¤ø,¸¸,ø¤º°`°º¤ø,¸¸,ø¤º°`°º¤ø,¸¸,ø¤º°`°º
Espartaco Palma Martínez
SysOp PortalFox
http://www.portalfox.com
esparta@portalfox.com
Previous
Next
Reply
Map
View

Click here to load this message in the networking platform