" select * from student where 姓名 = " '" & Text8.Text & "'"
"select * from student order by 出生年月"
怎样改正确呢?
多谢!!!
这两个句子输入没有问题的话,那么总是显示Adodc1.Refresh不正确的原因是什么呢?
错误说FROM子句语法错误。 student这张表就是我绑定的数据库,那么为什么还是有问题呢?
selectæ¯SQLç»ææ¥è¯¢è¯è¨å½ä»¤ä¹ä¸ã
1ï¼SQL è¯å¥ï¼å®ä¹ç»ææ¥è¯¢è¯è¨ (SQL) å½ä»¤ç表达å¼ï¼ä¾å¦ SELECTãUPDATE æ DELETEï¼ä¹å¯è½å
æ¬å WHERE å ORDER BY
è¿æ ·çåå¥ãSQL å符串è¯å¥ä¸è¬å¨æ¥è¯¢å rdoResultset
对象ä¸ä½¿ç¨ï¼ä½ä¹å¯ä»¥ç¨æ¥å建æä¿®æ¹æ°æ®åºç»æã
SQL è¯å¥çè¯æ³ä¸æ°æ®æºæå ³ã
2ï¼SELECT - SQLå½ä»¤
å¥æ³ï¼
SELECT [ALL | DISTINCT] [TOP nExpr [PERCENT]]
[Alias.] Select_Item [AS Column_Name]
[, [Alias.] Select_Item [AS Column_Name] ...]
FROM [FORCE]
[DatabaseName!]Table [[AS] Local_Alias]
[[INNER | LEFT [OUTER] | RIGHT [OUTER] | FULL [OUTER] JOIN
DatabaseName!]Table [[AS] Local_Alias]
[ON JoinCondition â¦]
[[INTO Destination]
| [TO FILE FileName [ADDITIVE] | TO PRINTER [PROMPT]
| TO SCREEN]]
[PREFERENCE PreferenceName]
[NOCONSOLE]
[PLAIN]
[NOWAIT]
[WHERE JoinCondition [AND JoinCondition ...]
[AND | OR FilterCondition [AND | OR FilterCondition ...]]]
[GROUP BY GroupColumn [, GroupColumn ...]]
[HAVING FilterCondition]
[UNION [ALL] SELECTCommand]
[ORDER BY Order_Item [ASC | DESC] [, Order_Item [ASC | DESC] ...]]
3ï¼
SELECT - SQLå½ä»¤ä¾åï¼
ä¸é¢çä¾å说æäºå¦ä½ä½¿ç¨SELECTçç¨æ·å®ä¹çå½æ°ç¨æ³ã
ä¾å1
ä¾å1 æ¾ç¤ºææä¼ä¸å¨å®¢æ·çå称ï¼ä»ä¸ä¸ªè¡¨ä¸çä¸ä¸ªå段ï¼ã
SELECT customer.company FROM customer
ä¾å2
ä¾å2 æ¾ç¤ºä¸¤ä¸ªè¡¨ä¸ä¸ä¸ªå段çå 容ï¼å¹¶å å ¥åºäºcust_idå段ç两个表ãå®ä½¿ç¨æ¬å°å«å两个表ã
SELECT a.company, b.order_date, b.shipped_on FROM customer a, orders b WHERE a.cust_id = b.cust_id
ä¾å3
ä¾å3 ä» æ¾ç¤ºå¨æå®é¢åå¯ä¸çæ°æ®è®°å½ã
SELECT DISTINCT a.company, b.order_date, b.shipped_on FROM customer a, orders b WHERE a.cust_id = b.cust_id
ä¾å4
ä¾å4 æ¾ç¤ºå½å®¶ï¼é®ç¼åå ¬å¸æååºé¢åã
SELECT country, postalcode, company FROM customer ORDER BY country, postalcode, company
4ï¼VBå°ä¸è¿°ä¾å¥ä½ä¸ºå符串èµå¼ç»ADOæ°æ®å¯¹è±¡ï¼æè ADOæ°æ®è®¿é®æ§ä»¶å±æ§ï¼è¿èå®ææ°æ®æ¥è¯¢ã
代ç 1ï¼
Private Sub Command1_Click()代ç 2ï¼
Private Sub Form_Load()