Mensaje
De
27/03/2000 12:37:26
a
27/03/2000 12:28:26
General information
Foro:
Visual FoxPro
Category:
Bases de datos, tablas, vistas, índices y SQL
Título:
Miscellaneous
ID de la conversación:
00350818
ID del mensaje:
00350820
Views:
30
>I am requerying a grid
>
>requery('lv_promotion')
>
>How can I get the most recent values from this requery (how do I access the values of last record in this requery)? Help appreciated
>
>
>Thank You
>Nick Patel
Hi Nick,
Correct me if I am wrong, I understand that you have a view which is the RecordSource of your grid. After REQUERY() what do you mean by most recent values? If you want to show your last record (which probably contains the most recent somedate field) you may GO BOTTOM in your view and refresh the grid. Or, if you want the last (most recent record) be on top then you may add ORDER BY mydatefield DESCENDING and have it as first record in the grid.
Nick
>
>requery('lv_promotion')
>
>How can I get the most recent values from this requery (how do I access the values of last record in this requery)? Help appreciated
>
>
>Thank You
>Nick Patel
Hi Nick,
Correct me if I am wrong, I understand that you have a view which is the RecordSource of your grid. After REQUERY() what do you mean by most recent values? If you want to show your last record (which probably contains the most recent somedate field) you may GO BOTTOM in your view and refresh the grid. Or, if you want the last (most recent record) be on top then you may add ORDER BY mydatefield DESCENDING and have it as first record in the grid.
Nick
Nick Neklioudov
Universal Thread Consultant
3 times Microsoft MVP - Visual FoxPro
"I have not failed. I've just found 10,000 ways that don't work." - Thomas Edison
Universal Thread Consultant
3 times Microsoft MVP - Visual FoxPro
"I have not failed. I've just found 10,000 ways that don't work." - Thomas Edison