SQLite fields turning into BLOBs

[Kevin]

Must be something else triggering it. Maybe the DBs need to have similarly named items, but different enough in other ways to make it flake out.

I’ll have to try to track it down when I have more time. 

- Kevin


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

> 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 
> _______________________________________________
> Valentina-studio mailing list
> Valentina-studio at lists.macserve.net
> http://lists.macserve.net/mailman/listinfo/valentina-studio
>