Getting "blob field" from an access query

Discuss RoboTask here
Post Reply
cadetblue
Posts: 2
Joined: Tue Dec 12, 2017 10:26 pm

Getting "blob field" from an access query

Post by cadetblue »

I am connecting by means of this string: Provider=Microsoft.ACE.OLEDB.12.0;Data Source=C:\Dropbox\Gestione\dummy.accdb;Persist Security Info=False
The SQL command is a select * from an already existing access query.
Then I use a dataset loop, assigning the field names and values to variables.
When writing to a text file those variables, some fields are ok, but there is plenty of "Blob fields".
For example, this is rendered as Blob field: Start Date: Month([inizio]) & "/" & Day([inizio]) & "/" & Year([inizio])
This too: Description: "Descrizione lunga"

Someone has a guess about what is wrong with my task?

Many thanks.
Oleg
Site Admin
Posts: 3000
Joined: Thu Jan 01, 1970 1:00 am
Contact:

Re: Getting "blob field" from an access query

Post by Oleg »

Database driver looks at the table structure.
It doesn't depend on field contents.
For example DB driver can interprets VARCHAR(2000) as BLOB (or CLOB) field.

You can shrink the length of this field bu using ACCESS internal function LEFT

For example
select Field1, Field2, Left(Field3, 50) as f3 from my table
Oleg Yershov
cadetblue
Posts: 2
Joined: Tue Dec 12, 2017 10:26 pm

Re: Getting "blob field" from an access query

Post by cadetblue »

Thanks for answering, Oleg. But:

Start Date: Month([inizio]) & "/" & Day([inizio]) & "/" & Year([inizio])

should be 10 characters long at maximum, yet is rendered as a BLOB object.
Post Reply