D
dreameast-1
Unregistered / Unconfirmed
GUEST, unregistred user!
请问怎么用query控件来，插入，更改，删除数据？那位给写个范例，我是个初学者！！！
张
张无忌
Unregistered / Unconfirmed
GUEST, unregistred user!
这类的书很多啊，自己去找来看看。
D
dreameast-1
Unregistered / Unconfirmed
GUEST, unregistred user!
难道这么简单的问题都没有人会回答么？
Y
yansh
Unregistered / Unconfirmed
GUEST, unregistred user!
去看书吧，随便哪本delphi的书上都有。
L
lw86
Unregistered / Unconfirmed
GUEST, unregistred user!
听听别人的建议，去看书吧！
张
张无忌
Unregistered / Unconfirmed
GUEST, unregistred user!
你要不要我告诉你begin后面一定要加一个end呀？[
]
]
N
nplang
Unregistered / Unconfirmed
GUEST, unregistred user!
先去看书，然后再来瞎逛DFW。
F
Fanny501
Unregistered / Unconfirmed
GUEST, unregistred user!
算了，我看到了我当初学unface的样子（没书 没资料，没有帮助），我给你写：
方法一：用sql脚本
1。添加：str := insert into table1(field1,field2) values(s_value1, s_value2)
2.?修改 str := update table1 set field1 = s_value1 , field2 = s_value2 where s_Condition;
3.删除 str := delete from table1 where s_condition
Query1.active := false;
Query1.SQL.Text := str;
Query1.ExecSQL;
方法二，用insertrecord ,delete, edit.......
方法一：用sql脚本
1。添加：str := insert into table1(field1,field2) values(s_value1, s_value2)
2.?修改 str := update table1 set field1 = s_value1 , field2 = s_value2 where s_Condition;
3.删除 str := delete from table1 where s_condition
Query1.active := false;
Query1.SQL.Text := str;
Query1.ExecSQL;
方法二，用insertrecord ,delete, edit.......
S
seucag
Unregistered / Unconfirmed
GUEST, unregistred user!
使用SQL语句
插入 INSERT table（field） values(value)
修改 UPDATE table set field= value where conditions
删除 DELETE table where conditions
插入 INSERT table（field） values(value)
修改 UPDATE table set field= value where conditions
删除 DELETE table where conditions
K
kisse
Unregistered / Unconfirmed
GUEST, unregistred user!
就是这样的了
S
sxbing
Unregistered / Unconfirmed
GUEST, unregistred user!
Query.Edit
Query.Delete
Query.add
Query.post
Query.Delete
Query.add
Query.post
D
dreameast-1
Unregistered / Unconfirmed
GUEST, unregistred user!
可以传递参数么？如添加：str := insert into table1(field1,field2) values('''s_value1''',''' s_value2''')
2.?修改 str := update table1 set field1 = s_value1 , field2 = s_value2 where s_Condition='''edit2.text''';
3.删除 str := delete from table1 where aaa='''edit1.text'''
Query1.active := false;
Query1.SQL.Text := str;
Query1.ExecSQL;
2.?修改 str := update table1 set field1 = s_value1 , field2 = s_value2 where s_Condition='''edit2.text''';
3.删除 str := delete from table1 where aaa='''edit1.text'''
Query1.active := false;
Query1.SQL.Text := str;
Query1.ExecSQL;
S
shkk
Unregistered / Unconfirmed
GUEST, unregistred user!
Delphi的Demos目录例子不是很好的吗？先看看吧！
N
nakivubo
Unregistered / Unconfirmed
GUEST, unregistred user!
可以传递参数,不过你的引号使用全乱了：
如果你的s_value1,s_value2 为变量的话
1、添加：str :=' insert into table1(field1,field2) values(" '+s_value1+'"," '+s_value2+'")';
2.修改 str :=' update table1 set field1 =" '+ s_value1+' , field2 ="'+s_value2+' where s_Condition=" '+edit2.text+'"';
3.删除 str :=' delete from table1 where aaa=" ' +edit1.text+ '" ';
如果你的s_value1,s_value2 为变量的话
1、添加：str :=' insert into table1(field1,field2) values(" '+s_value1+'"," '+s_value2+'")';
2.修改 str :=' update table1 set field1 =" '+ s_value1+' , field2 ="'+s_value2+' where s_Condition=" '+edit2.text+'"';
3.删除 str :=' delete from table1 where aaa=" ' +edit1.text+ '" ';
D
dreameast-1
Unregistered / Unconfirmed
GUEST, unregistred user!
谢谢你们了。
