Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Cannot re-populate a Grid
Message
From
17/06/2002 19:08:03
 
 
To
All
General information
Forum:
Visual FoxPro
Category:
Forms & Form designer
Title:
Cannot re-populate a Grid
Miscellaneous
Thread ID:
00669496
Message ID:
00669496
Views:
54
Need anyone can help me.

I populate a Grid with a free table in a form as follow:


* Openning the free table
if ! used ('DETALLES')
use FILE_YYYY_MM in 0 alias DETAILS && A free table containing data with a specific
&& data of month determined by YYYY_MM
endif
select DETAILS
*


* Then populating a Grid *

Thisform.GridLiquidac.RecordSource='DETAILS'
Thisform.GridLiquidac.Cod_Item.ControlSource = 'DETAILS.Cod_Item'
Thisform.GridLiquidac.Peso_uni.ControlSource = 'DETAILS.Net_weig'
Thisform.GridLiquidac.Precio_uni.ControlSource = 'DETAILS.Unit_price'
Thisform.GridLiquidac.cajas.ControlSource = 'DETAILS.Qty'
Thisform.GridLiquidac.Total.ControlSource = 'DETAILS.Ext_price'


Sometimes it´s necessary to change the free table for another one, changing the period (need to change the file month, but preserving the alias DETAILS, in order to REFRESH the grid with the current FILE_YYYY_MM.
The Grid was pasted in the form from the bar , I mean it was not created by the way, I mean not with code.

It seems that the Grid cannot open the alias again (I thinks because the file is another one). I tried closing the first FILE_YYYY_MM and then opening the next file FILE_YYYY_MM. But nothing. What can I do?. Any alternative?


Thanks in advance.

Carlos Burgos
Next
Reply
Map
View

Click here to load this message in the networking platform