From: Barak Ros
To: Samir H.
Visual FoxPro 6
Databases, Tables and SQL Server
Sunday, June 26, 2011 4:38:23 PM
This message was rated by:
> > thanks, but this is not what I need. this is just an example of what I need , but the real tables has diffrent structures, level2a and level2b are diffrent.
> > Thanks any way
> > Barak
> Well, I don't know. That's the only data I had to test with.
> Depends how you designed your report, I think. If need 1 cursor, then you must somehow make the fields compatible between tables. There are several functions for that, CAST() should be useful then.
> Sorry, didn't see you're using VFP6. No cast() there, but other functions such as trim(), pad(), trans() etc.
I probably can do that (use function to have it in a single cursor), but I made in the pase reports with SET RELATIONS to show data from one table and under it related data rows from another table. I need to know if it is possible with more than 1 relation.
Posted by Barak Ros @ 6/26/2011 3:24:06 PM
Posted by Samir H. @ 6/26/2011 4:14:09 PM
Posted by Barak Ros @ 6/26/2011 4:26:38 PM
Posted by Samir H. @ 6/26/2011 4:32:56 PM
Posted by Barak Ros @ 6/26/2011 4:38:23 PM
Posted by Samir H. @ 6/26/2011 5:05:51 PM
Posted by Tamar Granor @ 6/27/2011 10:51:16 PM