Postgree SQL的奇怪问题 [英] Strange problem with postgree sql

问题描述

大家好，

我在C#中有一个使用postgree sql的应用程序.

我可以从特定计算机中的除一个表之外的所有表中检索数据.

基础表具有数据.
在我的PC和另一台PC中都可以正常工作.

但我的客户端PC仅针对一张表就不返回任何数据行(计数为零).
从其他表中成功返回数据.而不是来自该表.

表名是:DownloadScheduleMap
查询是:从DownloadScheduleMap中选择*，其中dsm_IsDeleted = 0 dsm_Des des排序".
这是一个多么奇怪的问题！ 请给我解决方案.我需要尽快.

谢谢大家.

Hello All,

I have an application in c# with postgree sql.

I can retrive data from all tables except one in a specific pc.

the underlying table has data.
in my pc and in other one pc it works fine.

but my client pc it does not return any datarows (count is zero) for just one table.
from other tables data is returned successfully. but not from that table.

tablename is : DownloadScheduleMap
query is : "select * from DownloadScheduleMap where dsm_IsDeleted=0 order by dsm_Des des".
what a strange problem it is!!!!
please give me solution. I need it asap.

Thank you all.

推荐答案

报价:

其中dsm_IsDeleted = 0由des排序"

where dsm_IsDeleted=0 order by des"

您的ORDER BY未声明您要用于排序的字段.它应该看起来像这样:-

Your ORDER BY does not state the field which you want to use to order by. It should look something like this:-

SELECT * FROM DownloadScheduleMap WHERE dsm_IsDeleted = 0 ORDER BY yourOrderField DESC

只需将上面的yourOrderField替换为您要用来排序的字段的名称即可.

希望对您有帮助

Just replace yourOrderField above with the name of the field you would like to use to order by.

Hope this helps

这篇关于Postgree SQL的奇怪问题的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！