|
以下是从官方技术支持处获取的回复,希望与大家分享。. a# d5 R' |0 `$ g" ]' e( i! F) E
, G! r% { f) N" IWhen using the dbsqlquery() command with a SQL Select statement, the result does not return anything useful. Instead, the query result is stored in memory and can be accessed using the dbgettablecell() command. Since it looks like you are only retrieving a result with one row and one column, you can do something like this:
1 W9 e, |/ w3 R( j
% F8 j% y: c: U( S Zdbsqlquery("select...");
5 H! k5 F D1 h9 ]' Fdouble c = stringtonum(dbgettablecell(1,1));
' w2 j$ \2 P3 ~- F% L" D3 v. A5 {, p+ a
Or if you want to keep it as a string, you can do this:/ z3 C- [4 E% ^3 |9 m
" @. g$ J" |/ w2 z$ G3 O( x
dbsqlquery("select...");
& ?2 ]* d. k( `6 jstring d = dbgettablecell(1,1); |
|