Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
View Problem in 2º update
Message
From
13/06/2000 23:35:30
 
General information
Forum:
Visual FoxPro
Category:
Databases,Tables, Views, Indexing and SQL syntax
Miscellaneous
Thread ID:
00379551
Message ID:
00380059
Views:
24
Hi Larry,

Thank's for your reply, what you tell me was my first aproach to the problem, and that was the way that i have almost of my view's (no many at the moment..:) ), but for what i need i think don't work.

1. I need to create the grid in form in design time, not in the fly, because i need their columns methods avaiable, the grid have 4 columns but only 2 are editable.

2. i create the view with the fields that i need to build the grid, updatable, with ?CodCli, etc.
Then in the form init i requery the view with codcli='00000'(client) and i get the grid empty, until here ok. Then i select the client and build the select like you see, this select is not the same that i build the view, i can't do the same in the view designer, so i need to create the cursor and then append it to the view, is there another way to do that?

What i want to do is that, i have master table 'familias' that have all my group of produts like, NIKE, ADIDAS, ETC... and have another table 'clifamilias' that have the discounts for every client for this group of products, Ex: client 1 ADIDAS 3%, but client 2 ADIDAS 5%, and so on.

The select is important because if there are new groups it join them to the table clifamilias with no effort to the user, so it show the records that i have in table clifamilias more the new's one's that can be open in table familias.

Thank's in Advance

João Batista
Previous
Next
Reply
Map
View

Click here to load this message in the networking platform