SQLite fields turning into BLOBs

[Johnny Harris]

I quickly tried your suggestions, but everything still seems to be ok.

Johnny Harris



-----Original Message----- 
From: Kevin
Sent: Sunday, March 16, 2014 9:51 PM
To: valentina-studio at lists.macserve.net
Subject: Re: SQLite fields turning into BLOBs

I tried it in 5.5.3 and 5.5.4. I didn’t have any BLOBs when I open the 
original DBs. Just TEXT and INTEGER.

I think I’ve found a workaround. I can only open one DB at a time.

It might have something to do with several DBs having a single table with 
the same name. Maybe it’s confusing VS.

If you want to test my theory, try duplicating your file a couple of times. 
Save one off somewhere to be your backup and open the other two at the same 
time. View some data in both dbs, and maybe make a simple change in one like 
adding an index. Then close and reopen them.


Thanks,
Kevin


On Mar 16, 2014, at 9:41 PM, Johnny Harris <johnny at southshore.com> wrote:

> Hi Kevin,
>
> I'm using VStudio 5.5.3 and it seems to be working ok. I don't have any 
> images stored in the database, but the fields and data are displaying 
> correctly.
> I'm creating the SQLite database in code with Xojo.
>
> Which version of VStudio are you using?
>
> Johnny Harris
>
> -----Original Message----- From: Kevin
> Sent: Sunday, March 16, 2014 9:06 PM
> To: valentina-studio at lists.macserve.net
> Subject: SQLite fields turning into BLOBs
>
> I’m having a problem where after opening a couple of SQLite files just to 
> view the data, all the field types turn into BLOBs. Then valentina doesn’t 
> view the data. Apparently this has no effect on the data itself as I can 
> view it fine in SQLite Studio, but it’s quite annoying since I typically 
> prefer to just use Valentina Studio for most of my DB needs, but now I 
> need to have a separate tool for SQLite.
>
> Does anyone have any insight into this oddity?
>
> Thanks,
> Kevin
> _______________________________________________
> Valentina-studio mailing list
> Valentina-studio at lists.macserve.net
> http://lists.macserve.net/mailman/listinfo/valentina-studio
> _______________________________________________
> Valentina-studio mailing list
> Valentina-studio at lists.macserve.net
> http://lists.macserve.net/mailman/listinfo/valentina-studio
>

_______________________________________________
Valentina-studio mailing list
Valentina-studio at lists.macserve.net
http://lists.macserve.net/mailman/listinfo/valentina-studio