Hi, I am using your code on a Azure SQL db, and it worked great, but seems to have somehow missed two references. Take a look: this is the output when I develop dm using this function:
sQuery <- dm_re_query("sqlserver")
dm <- sqlQuery(channel, sQuery, stringsAsFactors = FALSE, errors=TRUE)
The little red diamonds added by me so you can see the affected fields.
I have gone through and developed the dm using this query: 'SELECT *, CONVERT(varchar(8000), AccessProperties) as AcProp FROM "AccessSystem"."GetFieldSchemaCache"' which gives me:
(I'm hiding the ID field... so don't worry bout it) Bizzare, no? What could it be?
Hi, I am using your code on a Azure SQL db, and it worked great, but seems to have somehow missed two references. Take a look: this is the output when I develop
dmusing this function:The little red diamonds added by me so you can see the affected fields.
I have gone through and developed the
dmusing this query:'SELECT *, CONVERT(varchar(8000), AccessProperties) as AcProp FROM "AccessSystem"."GetFieldSchemaCache"'which gives me:(I'm hiding the ID field... so don't worry bout it) Bizzare, no? What could it be?