Incomplete listings on Azure SQL

[DataStrategist]

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?

[bergant]

I'm sorry, it's hard to see anything without the data... Is it possible to get the data frames of these two queries?

[DataStrategist]

Sure... shall I email you? The email in your github?

[bergant]

OK

[DataStrategist]

did you receive my email? it should have been from a @ acdivoca.org account