[R] Using text put into a dialog box
nowa0021 at flinders.edu.au
Wed Feb 17 01:30:34 CET 2010
Thanks Greg, the problem is I have no idea how to return and use what I have
typed into the pop up. Add to that the complication that with this query
x<-sqlQuery(conn, "select to_char(lsd,'yyyy-mm') as yr,ttl_mo_prcp from
mo_rains where stn_num=23090")
if I put anything other than a number into stn_num=... then it does not run.
eg if I just do sn=23090 and then use that in the query
sqlQuery(conn, "select to_char(lsd,'yyyy-mm') as yr,ttl_mo_prcp from
mo_rains where stn_num=sn")
I get the following error.
 "[RODBC] ERROR: Could not SQLExecDirect"
 "42S22 904 [Oracle][ODBC][Ora]ORA-00904: \"SN\": invalid identifier\n"
So my question is in two parts. Firstly, how do I return the number written
in the popup, and then secondly how do I actually put it into the query?
View this message in context: http://n4.nabble.com/Using-text-put-into-a-dialog-box-tp1555761p1558124.html
Sent from the R help mailing list archive at Nabble.com.
More information about the R-help