I tried this: ``` x = dput(sapply(names(ODB::odb.tables(db)), function(tbl) { sqlQuery <- paste0('SELECT * FROM "', demographic, '"') ODB::odb.read(db, sqlQuery) }, simplify=F)) y = x$demographic ``` so now `y` is the dataframe for the table `demographic`: ``` > y ID Study_ID Hosp_ID Hospital Address 1 5 0 NA Royal Free - Tottenham Court road Tottenham Court road 2 6 0 NA Santa Croce in Gerusalemme - Via Latina Barcelona Occ_ID Age Sex day_ID month_ID century year_ID Year Occupation Day DOB Enrollment 1 NA NA 2 NA NA 19 NA 10 Student 24 NA 2020-11-01 2 NA NA 1 NA NA 20 NA 9 Researcher 26 NA 2022-01-01 EnrolTime 1 13:24:00 2 14:25:00 > str(y) 'data.frame': 2 obs. of 18 variables: $ ID : num 5 6 $ Study_ID : num 0 0 $ Hosp_ID : logi NA NA $ Hospital : chr "Royal Free - Tottenham Court road" "Santa Croce in Gerusalemme - Via Latina" $ Address : chr "Tottenham Court road" "Barcelona" $ Occ_ID : logi NA NA $ Age : logi NA NA $ Sex : num 2 1 $ day_ID : logi NA NA $ month_ID : logi NA NA $ century : num 19 20 $ year_ID : logi NA NA $ Year : chr "10" "9" $ Occupation: chr "Student" "Researcher" $ Day : num 24 26 $ DOB : logi NA NA $ Enrollment: chr "2020-11-01" "2022-01-01" $ EnrolTime : chr "13:24:00" "14:25:00" ``` Still, I thought it might have been easier to run `odb.read`. But it works, thank you again!
On Wed, Nov 10, 2021 at 7:03 PM Rasmus Liland <j...@posteo.no> wrote: > > On 2021-11-10 18:55 +0100, Luigi Marongiu wrote: > > no, it worked. that table was indeed > > empty and you for the right entries on > > the other table. I'll try on my > > machine, thank you! > > Cheers man! -- Best regards, Luigi ______________________________________________ R-help@r-project.org mailing list -- To UNSUBSCRIBE and more, see https://stat.ethz.ch/mailman/listinfo/r-help PLEASE do read the posting guide http://www.R-project.org/posting-guide.html and provide commented, minimal, self-contained, reproducible code.