Hi,
I have a concern. My Row Counter in the Grid doesn’t count records.
ex.
[1 to 5 of 5]
yet 6 records were displayed on the grid…
Thanks
ishey
Re: Row Counter Grid don’t count records
Now this is a major problem… all my row counters in a grid doesn’t count records…
please help!! i just had an update of v5 yesterday…
was this a possible bug after a had an update???
In my grid i have a button which redirects to a form (add records) … And when I hit the back button after I add a record…, It goes back to the grid… The record was there yet the record counter doesn’t count the recently added record.
Thanks
ishey
Re: Row Counter Grid don’t count records
Please report this to bugs@netmake.com.br and support@netmake.com.br
Please include as many example screenshots to prove your point. I have seen this as well when filtering records.
Regards,
Scott.
Re: Row Counter Grid don’t count records
Thanks Scott I will.
Ishey…
Re: Row Counter Grid don’t count records
Another concern:
ALSO my Grid SQL Statement contains 2 tables for inner join…
The first table is the main table while the other is like a referral table for activities (1 is to many relationships)…
NOw when I hit the update button in the form then return into the grid… my records in the second table were deleted…
On the other hand, when I use a single table, it was all fine…
Now in the search of a grid, how will a search a record on the other table/child table?? Was it on the ONValidate Event?? Coz I don’t see a grid lookup option for search…
Thanks
ishey
Re: Row Counter Grid don’t count records
Now when I hit the update button in the form then return into the grid… my records in the second table were deleted…
Several questions:
-Is the grid a real grid, or a form/edit grid?
-Are you using a grid to find the records then loading another form to update, or …
-Does the update form include the ‘joined’ fields? You cannot update joined fields. I believe however, that you can use a join in your update statement.
-Grids have a lookup option … again a real grid?
Can you provide more detail on your approach?
Regards,
Scott.
Re: Row Counter Grid don’t count records
Hi Scott,
Yes, a real grid which displays all the records and thus I also use to find records…
-My grid has a field that links into a form for edit/update…
-I use INNER JOIN in my grid coz I’m using 2 tables…
ex. (Grid)
Tables: mod_ctm & mod_ctm_id_x_activities
SELECT
a.CTMID
a.IncidentDate,
a.Category,
a.Province,
b.cod_id,
b.cod_activities,
group_concat(b.cod_activities) --> I’m using this field to concatenate the activities per id
FROM
mod_ctm a INNER JOIN mod_ctm_id_x_activities b ON a.CTMID = b.cod_id
GROUP BY a.CTMID
Now in my Edit Form:
-I have 1 field for N-N Relationship (double select)…
-When I hit the update button then returns into the grid… My Activities in the mod_ctm_id_x_activities were deleted…Thus my grid
doesn’t also display the recently updated record.
ex.
Table: mod_ctm (I still have the record - PK: CTMID)
Table: mod_ctm_id_x_activities (activities were deleted - PK: cod_id and PK: cod_activities)
I’m not quite sure if I explained it well…
Thanks
ishey
Re: Row Counter Grid don’t count records
That is a head scratcher …
I could see where it would not update, but not delete … records are actually deleted from table?
It may be required to produce a export of this app so I could import and take a look with sample data.
-Could be update the app to display the actual SQL that is produced and see if it behaves the same when you execute manually?
-If you select into a temp table first and then update, would it work then?
This will be difficult to make guesses, and perhaps it is a SC5 bug?
Regards,
Scott.
Re: Row Counter Grid don’t count records
Hi Scott,
I just noticed this in my UPDATE FORM:
I use 3 fields for N-N Relationship: In which each fields refer to different tables for lookup but then uses only 1 link table (Relationship table that will be updated.)
Also those fields where hidden on a block… The user must first select what category afterwards, only a particular field was displayed (AJAX)…
On the Onload event: a particular field was also displayed depending on what category the form has…
On the Backend, once the user click the update button… the records were deleted according to the said id…
So… thus that mean 3 fields on the N-N Relations are not allowed?? And thus it deletes records in case I use that 3 fields??
Thanks
ishey
Re: Row Counter Grid don’t count records
To be honest, I have not delved into the N-N support in SC5. I usually do not let SC do too much of the thinking for me and code my own solution by updating controls myself.
I may have to take a look at this in a pending project.
You may have to present this to NetMake in a project.
Regards,
Scott.
Re: Row Counter Grid don’t count records
Ah Thanks for the input Scott…
Maybe I’ll try coding my own solution as well… 
Ishey