“参数xxx没有默认值"；在SQL语句中使用Order by时出错 [英] "Parameter xxx has no default value" error when using Order by in SQL statement

问题描述

我正在尝试运行以下SQL语句:

I am trying to run the following SQL statement:

"SELECT *, (IIF([Field]=TRUE,'StringValue1','StringValue2') AS [NewField] FROM [Table1] ORDER BY [NewField] ASC"

但是这给我一个错误"Parameter NewField没有默认值".我该怎么解决?

But this gives me an error "Parameter NewField has no default value". How can I solve it?

我正在使用Delphi 7中的Jet Engine使用Microsoft Access(MDB)数据库.

I am using Microsoft Access (MDB) database using Jet Engine from Delphi 7.

谢谢！

推荐答案

在ORDER BY子句中，您可以按列序号引用该列:

In the ORDER BY clause, you can reference a column by its ordinal number:

SELECT
  IIF(T.[Field]=TRUE, 'StringValue1', 'StringValue2') AS [NewField],
  T.*
FROM [Table1] T
ORDER BY 1 ASCENDING

这篇关于“参数xxx没有默认值"；在SQL语句中使用Order by时出错的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！