Gabriel Cook wrote:
> Thanks for your reply.
>
> However, I can't normalize the data in the blob, basically, its an
arbitrary
> frame of data. I don't know what's in it or how its formatted at design
> time.
>
> I'm ok with the table scan, IF I there
s not what they're meant to do, you
need to normalize your data before you can query it effectively.
On 11/3/06, Gabriel Cook <[EMAIL PROTECTED]> wrote:
>
> Hello all,
>
> I'm trying to figure out if there is a way use portions of a BLOB field in
> a
> select query.
Hello all,
I'm trying to figure out if there is a way use portions of a BLOB field in a
select query.
Here is an example of the table:
CREATE TABLE fcdata (
timestamp INTEGER NOT NULL,
portINTEGER NOT NULL,
dataelementtype INTEG
3 matches
Mail list logo
