在此语句中添加位置部分 [英] Adding A Where Part To This Statement

问题描述

我试图在其中添加一个statemnet，但运气不佳.任何帮助表示赞赏.谢谢.

I''m trying to add a where statemnet to this without much luck. Any help is appreciated. Thank you.

SQLCHAR* query = (SQLCHAR*)"SELECT tblIP.[IPAddress], tblIP.[IPType], tblIP.[IPStatus], tblIP.[IPMax] FROM tblIP ORDER BY tblIP.[IPAddress] ASC;";

试过了...

Tried this...

SQLCHAR* query = (SQLCHAR*)"SELECT tblIP.[IPAddress], tblIP.[IPType], tblIP.[IPStatus], tblIP.[IPMax] FROM tblIP WHERE tblIP.[IPAddress]='173.201.216.2' AND tblIP.[IPType]='3' AND tblIP.[IPStatus]='1' AND tblIP.[IPMax]='0';";

IPAddress是一个文本字段
IPType是一个数字字段
IPStatus是一个数字字段
IPMax是一个数字字段

IPAddress is a text field
IPType is a number field
IPStatus is a number field
IPMax is a number field

推荐答案

这有效......

This works........

SQLCHAR* query = (SQLCHAR*)"SELECT tblIP.[IPAddress], tblIP.[IPType], tblIP.[IPStatus], tblIP.[IPMax] FROM tblIP WHERE tblIP.[IPAddress]='173.201.216.2' AND tblIP.[IPType]=3 AND tblIP.[IPStatus]=1 AND tblIP.[IPMax]=0;";

删除数字字段值周围的单引号.

Remove the single quotes around the number field values.

这篇关于在此语句中添加位置部分的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！