laggerboutique
Posts: 8
|
| Posted: 12/19/2004, 12:29 AM |
|
I have a situation in which my grid form fails to recognize new records entered into the table. Here are the symptons:
- When a record is added via the add form, the MySQL table is correctly updated (as confirmed by viewing the table through phpMyAdmin).
- The grid form fails to reflect the newly inserted record, however.
- If I manually insert a record into the table through phpMyAdmin, the grid form still does not pick up the new entry.
- If I select a record in the grid and update it, the updates are immediately reflected in the grid.
Is there something I am doing wrong?
Thanks
|
 |
 |
laggerboutique
Posts: 8
|
| Posted: 12/20/2004, 9:59 AM |
|
I think I see that the problem is that my grid does not display any record that contains a null value in one or more of the fields.
Since I made my original post, I've created other grids, some of which display and some of which don't display records with null values in one or more fields. Is there are way I can insure that each grid displays all records in the table, regardless of the contents of the fields?
|
|
|
|
peterr
Posts: 5971
|
| Posted: 12/20/2004, 1:39 PM |
|
Are you using one table or multiple tables as the basis (Data Source) of those grids?
_________________
Peter R.
YesSoftware Forums Moderator
For product support please visit http://support.yessoftware.com |
|
|
|
laggerboutique
Posts: 8
|
| Posted: 12/20/2004, 8:32 PM |
|
I'm using multiple tables as the basis of the grids. Here are some specifics:
- I have a grid which displays the values of a table called Products. This table is related to other tables called Artists, Product_Category, Product_Subtype, and Item_status. I have configured the grid to show "meaningful" values from these tables - for example, from Artists, the Control Source is a column that contains the artist's name.
- I have another grid which displays the values of a table called Inventory_transactions. This table is related to the tables Products, Show_info, and Sales_consultants. Again, I have configured the grid so that the information is not simply the auto-incremented values from the primary keys of the related tables.
- The Products table shows all records, even those which have null values in certain fields. I can add records via the record form (which has list boxes for certain fields), even if I don't put values in all the fields.
- The Inventory_transactions table, however, shows only those records in which there are no null values in the fields that are related to other tables. New records that are added via the record form are only displayed if none of the fields are left null.
- I've compared the properties in the two grids and I cannot find anything that would explain the difference in behavior.
Can you pinpoint the reason for this?
Thanks for your help.
|
|
|
|
Oper
Posts: 1195
|
| Posted: 12/21/2004, 4:04 PM |
|
use left join
_________________
____________________________
http://www.7bz.com (Free CMS,CRM Developed in CCS)
http://www.PremiumWebTemplate.com
Affiliation Web Site Templates
Please do backup first |
|
|
|
|
