------=_Part_17756_31192562.1208859157140
Content-Type: text/plain; charset=ISO-8859-1
Content-Transfer-Encoding: 7bit
Content-Disposition: inline
On Tue, Apr 22, 2008 at 3:24 PM, Nacef LABIDI <nacef.l@[EMAIL PROTECTED]
> wrote:
> Hi all,
>
> I am using Postgres in a Delphi application through ODBC. I am having an
> issue with updating records.
>
> When I create a dataset to get the records in a table then after I
update
> one of these records and then refresh the dataset, the record goes to
the
> end of the dataset. This is disappointing when editing records on a
DBGrid,
> where users find their updated records jump to the end of the grid. Even
> after restarting the application, the updated record keeps showing at
the
> end of the grid. I have tried the same thing with SQL Server and it
works
> normally, so I thought it was a postgres behvior.
>
> Has anyone an idea about what could be the cause of such a behavior.
>
The data is not guaranteed to be ordered if you do not specify an ORDER BY
clause in your query. Try adding a meaningful ORDER BY clause, that should
solve the problem.
HTH,
Best regards,
--
gurjeet[.singh]@[EMAIL PROTECTED]
gmail | hotmail | indiatimes | yahoo }.com
EnterpriseDB http://www.enterprisedb.com
Mail sent from my BlackLaptop device
------=_Part_17756_31192562.1208859157140
Content-Type: text/html; charset=ISO-8859-1
Content-Transfer-Encoding: 7bit
Content-Disposition: inline
On Tue, Apr 22, 2008 at 3:24 PM, Nacef LABIDI <<a
href="mailto:nacef.l@[EMAIL PROTECTED]
">nacef.l@[EMAIL PROTECTED]
>> wrote:<br><div
class="gmail_quote"><blockquote class="gmail_quote" style="border-left:
1px solid rgb(204, 204, 204); margin: 0pt 0pt 0pt 0.8ex; padding-left:
1ex;">
Hi all,<br><br>I am using Postgres in a Delphi application through ODBC. I
am having an issue with updating records.<br><br>When I create a dataset to
get the records in a table then after I update one of these records and
then refresh the dataset, the record goes to the end of the dataset. This
is disappointing when editing records on a DBGrid, where users find their
updated records jump to the end of the grid. Even after restarting the
application, the updated record keeps showing at the end of the grid. I
have tried the same thing with SQL Server and it works normally, so I
thought it was a postgres behvior.<br>
<br>Has anyone an idea about what could be the cause of such a
behavior.<br></blockquote><div><br>The data is not guaranteed to be
ordered if you do not specify an ORDER BY clause in your query. Try adding
a meaningful ORDER BY clause, that should solve the problem.<br>
<br>HTH,<br><br>Best regards,<br></div></div>--
<br>gurjeet[.singh]@[EMAIL PROTECTED]
>singh.gurjeet@[EMAIL PROTECTED]
gmail | hotmail |
indiatimes | yahoo }.com<br><br>EnterpriseDB <a
href="http://www.enterprisedb.com">http://www.enterprisedb.com</a><br>
<br>Mail sent from my BlackLaptop device
------=_Part_17756_31192562.1208859157140--
|
