Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
What's the difference?
Message
From
06/12/2007 10:27:11
 
 
To
06/12/2007 10:22:03
General information
Forum:
Visual FoxPro
Category:
Databases,Tables, Views, Indexing and SQL syntax
Miscellaneous
Thread ID:
01273613
Message ID:
01273614
Views:
17
Remove the apostrophs!
#DEFINE TABLE2_NAME table2
#DEFINE INDEX2_NAME myOrder

set relation to ( INDEX2_NAME ) into ( TABLE2_NAME )
>I have two tables, contained in a DBC, that I'm trying to set a relation between.
>
>
>open database myDB1 share
>use myDB1!table1 order indexorder share in 0
>use myDB1!table2 order myOrder share in 0
>
>
>When I use this command I'm able to browse both tables and see the record pointer change in the second table.
>
>
>select table1
>set relation to myOrder into table2
>
>
>But if I try to use #DEFINES for the table and tag names, the second table ends up pointing to EOF. What's the difference?
>
>
>#DEFINE TABLE2_NAME 'table2'
>#DEFINE INDEX2_NAME 'myOrder'
>
>set relation to ( INDEX2_NAME ) into ( TABLE2_NAME )
>
Previous
Reply
Map
View

Click here to load this message in the networking platform