search for: adatafram

...LABLE REMARKS COLUMN_DEF SQL_DATA_TYPE SQL_DATETIME_SUB [16] CHAR_OCTET_LENGTH ORDINAL_POSITION IS_NULLABLE DISPLAY_SIZE FIELD_TYPE <0 rows> (or 0-length row.names) But there is no test table defined anywhere else but the X schema. If I do sqlSave(db,aDataFrame,"X.test",T,F), it says test already defined. If I change the aDataFrame to be different than the fields actually in the data, then R starts to create a new table but returns Error in sqlColumns(db, "X.test") : 'X.test': table not found on channel It seems to be havin...

...y for some multidimensional windowing - but this question is on scripting basics). For purposes of figuring out my needs, lets just consider writing a function that takes a formula and a dataset, and outputs the mean of each variable in the formula model. So: MyFunction <- function(AFormula, ADataFrame) { ... } >MyFunction(Y ~ A + B, TheData) would give results something like: Mean of MyData$Y is 5.3 Mean of MyData$A is 3.4 Mean of MyData$B is 8.2 QUESTION 1: How do I determine the terms in the formula within the function? QUESTION 2: How do I use one of those terms to get to the...