//省略了一些内容,不知道你是不是想要的。 dim Rs as ADODB.RecordSet dim cmd as ADODB.Command............ cmd.CommandText="SELECT * FROM TABLE"set Rs= cmd.Executemsgbox Rs.Fields(0).Valueset rs= nothing set cmd =nothing
USE pubs SELECT type, price, advance FROM titles ORDER BY type COMPUTE SUM(price), SUM(advance) BY type 我在vb的前台怎样取得SUM(price), SUM(advance).谢谢
dim Rs as ADODB.RecordSet
dim cmd as ADODB.Command............
cmd.CommandText="SELECT * FROM TABLE"set Rs= cmd.Executemsgbox Rs.Fields(0).Valueset rs= nothing
set cmd =nothing
SELECT type, price, advance
FROM titles
ORDER BY type
COMPUTE SUM(price), SUM(advance) BY type
我在vb的前台怎样取得SUM(price), SUM(advance).谢谢