Results 1 to 8 of 8

Thread: Ajax Grid Display

Hybrid View

Previous Post Previous Post   Next Post Next Post
  1. #1
    Join Date
    Feb 2009
    Location
    SW Connecticut/NY area
    Posts
    9,181

    Default Ajax Grid Display

    I've got what I think is a relatively simple Ajax 2.4 grid that has an odd display - all rows are the same. The DD constraints are on an ID and date. If I remove the date constraint then the display goes back to normal - all rows are different. If the grid is set to display 5 rows then there will be 5 rows but all with the same data. This is SQL Server data so it isn't an index problem. Anyone got a clue?

    Click image for larger version. 

Name:	ajaxGrid.jpg 
Views:	315 
Size:	26.7 KB 
ID:	7899
    Bob Worsley
    203-249-2633
    rlworsley at gmail.com

    Do or do not. There is no try. — Yoda

  2. #2
    Join Date
    Feb 2009
    Posts
    2,026

    Default Re: Ajax Grid Display

    Hi Bob,

    Completely off the top of my head but I think there is a thread or threads Garret posted in the past about some problems with date based constraints. Can't remember if this was a symptom but might be worth looking up.

    Cheers
    Richard

  3. #3
    Join Date
    Feb 2009
    Location
    Somewhere in Vermont, USA - unless I'm not
    Posts
    11,085

    Default Re: Ajax Grid Display

    That was CJDBGrids & Indices that have a Date or DateTime as the first element. Seems there's a rowid issue as I remember.

    But - might be worth testing with a different index to see if the issue goes away.
    Garret

    Time for an oldie but goodie:

    "If it ain't broke, you're not trying." - Red Green

  4. #4
    Join Date
    Feb 2009
    Location
    SW Connecticut/NY area
    Posts
    9,181

    Default Re: Ajax Grid Display

    First the date is not the first segment and second I did switch indexes. Initially I was using a datetime but switched to a plain date in a different index. But I haven't tried an index without a date at all, maybe that's worth trying. In any case it doesn't make any sense...
    Bob Worsley
    203-249-2633
    rlworsley at gmail.com

    Do or do not. There is no try. — Yoda

  5. #5
    Join Date
    Feb 2009
    Location
    Somewhere in Vermont, USA - unless I'm not
    Posts
    11,085

    Default Re: Ajax Grid Display

    Why do you think they call 'em confusers?
    Garret

    Time for an oldie but goodie:

    "If it ain't broke, you're not trying." - Red Green

  6. #6
    Join Date
    Feb 2009
    Location
    SW Connecticut/NY area
    Posts
    9,181

    Default Re: Ajax Grid Display

    Quote Originally Posted by Garret Mott View Post
    Why do you think they call 'em confusers?
    I'm not sure it's the confuser's fault though
    Bob Worsley
    203-249-2633
    rlworsley at gmail.com

    Do or do not. There is no try. — Yoda

  7. #7
    Join Date
    Feb 2009
    Location
    SW Connecticut/NY area
    Posts
    9,181

    Default Re: Ajax Grid Display

    Ok, so I found that if I switch to any index that doesn't have a date in the index it works - each row is different as I would expect.

    Normally the index segments would be
    Driver_ID
    DateTime_Sent
    Waybill
    ID
    but that gives me the data shown in the original image above

    When I switched it to
    Driver_ID
    Waybill
    DateTime_Sent
    ID
    Voila! it worked. But why is this the only order that it will work in? I tried every order of the segments that I could think of and only this one showed me correct data, all others as described above. So you might say "you got what you wanted so why are you still complaining?" Because obviously something's broken. Can anyone explain this? And it doesn't matter if it's a date or a datetime...

    So the other question is whether this is an Ajax problem or a DD problem? Or my problem?
    Last edited by Bob Worsley; 12-Jul-2014 at 08:27 AM.
    Bob Worsley
    203-249-2633
    rlworsley at gmail.com

    Do or do not. There is no try. — Yoda

  8. #8
    Join Date
    Feb 2009
    Location
    Somewhere in Vermont, USA - unless I'm not
    Posts
    11,085

    Default Re: Ajax Grid Display

    In the CJDBGrid problem I had it was a RowID problem. IIRC, somehow having a DateTime in my index made the RowID too big for VDF too handle. Might want to check what the rowID's are?

    ETA: Here's the thread: http://support.dataaccess.com/Forums...highlight=date
    Last edited by Garret Mott; 12-Jul-2014 at 10:32 AM.
    Garret

    Time for an oldie but goodie:

    "If it ain't broke, you're not trying." - Red Green

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •