More on V4RB 4.8.1 apps crashing after install of V4RB 5.3.4

[Steve Albin]

I should clarify that I am abandoning the class way for defining the database tables.  I still create a subclass of VDatabase, but I don't create classes for all the tables.  I find that if your VTable classes do not match your database EXACTLY, then you can have problems.  Of course, this should be true - they should match.  But, in practice I've found that database schemas easily change.  Fields that had no default defined get a default NULL defined.  Fields that were not defined as indexed get indexed.  I suspect as Valentina versions change, schemas get updated in subtle ways that may effect how the VTable classes should be defined.

There is no need to use the VTable classes.  Valentina knows what the database contains already.  I create subclasses of VCursor and do all my access of the database via SQL.  

My one application where I switched to not using classes for opening the tables is much more stable.  I realize that I may have been using the table classes incorrectly, but I'll take success however I find it.

Steve


--
Steve Albin, Montclair, NJ
http://www.steve-albin.com
http://www.jazzdiscography.com

On Oct 11, 2013, at 11:23 AM, François Van Lerberghe wrote:

> I'm curious too. I use extensively the class way, both with local and server
> DB. What problem have you encountered ?
> 
> François Van Lerberghe
> Rue Thier Monty, 15 A
> 4570 Marchin
> Belgium
> 
> 
> le 11/10/13 16:27, Joseph Morgan <joseph at checkos.com> a écrit :
> 
>> I am curious why do you feel using the class way isn't working out well for
>> you? I ask because I am redoing my project to utilize my own version of "class
>> way" and it seems to work well so far.
>> 
>>> On Oct 11, 2013, at 8:38 AM, Steve Albin <steve at steve-albin.com> wrote:
>>> 
>>> By "class way" I mean that I create Xojo subclasses for Vdatabase and VTable
>>> for opening and creating the database.  I use SQL further down the line to
>>> create cursors.  As an aside, I'm changing all my apps to abandon this method
>>> of handling things as I've found it does not work well.  
> 
> _______________________________________________
> Valentina mailing list
> Valentina at lists.macserve.net
> http://lists.macserve.net/mailman/listinfo/valentina