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 Mike Lewis on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!
-
SET RELATION and SET FILTER TO
As background information: I have the task to update the reports of our ERP-System which seems to be programmed in Foxpro. I'm not sure if that means I'm working with the FoxPro Report Writer. The place I paste the above code is called the 'script for opening tables' and then I can use the table...- Martinius
- Post #11
- Forum: Microsoft: FoxPro
-
SET RELATION and SET FILTER TO
I didn't test the SQL because I don't know how to embed it correctly in FoxPro code. As I said I don't have a clue what I'm doing :-) I'd like to ask again if you could recommend a good book.- Martinius
- Post #7
- Forum: Microsoft: FoxPro
-
SET RELATION and SET FILTER TO
Hi, I got it to work. From what OLAF wrote I suspected I mixed up the field name in SET RELATION. So I wrote: SET RELATION TO projnr INTO projpos ADDITIVE The SET FILTER TO statement then seemed to work as well. I'm very happy :-) @Mike How could I have written this in SQL with the...- Martinius
- Post #5
- Forum: Microsoft: FoxPro
-
SET RELATION and SET FILTER TO
Basicly what I want from projpos is: SELECT partbez1, partbez2, kstträg FROM projpos WHERE posprojnu = fe_fertkop.projnr AND posfolgnu = fe_fertkop.pos- Martinius
- Post #2
- Forum: Microsoft: FoxPro
-
SET RELATION and SET FILTER TO
Hello everyone, I have no clue of visual foxpro, I just try to use the examples I found. Maybe you can recommend a good book? I have the following code. I'd like to connect two tables with different field names and I want to limit/filter/select records from the child table. Do you have some...- Martinius
- Thread
- Replies: 15
- Forum: Microsoft: FoxPro
