Re: Free Valentina Database

2011-12-15 Thread Ken Dibble
> > "Valentina does not require the creation of KEY fields - you can avoid the > > headache of filling in unique values. > > > > Each Valentina Table has a special RecID field, which provides a unique > > number for a record of this table." > [snip] > > Okay, yeah, but nothing is free. > >

Re: Free Valentina Database

2011-12-15 Thread Ken Dibble
> Yes - Valentina uses the equivalent of RECNO(). It suffers the > same problem (fatal, IMO) that if you export the data and then import it, > all relations are messed up if there are any deleted records. Yikes! He's actually relying on records never being deleted from the tables??? Th

Re: Free Valentina Database

2011-12-15 Thread Ed Leafe
On Dec 15, 2011, at 3:27 PM, MB Software Solutions, LLC wrote: >> His point was since they were offsets and not actual stored values, >> they were more efficient. Valentina records are fixed length, so to get >> RecID=99 the software only has to jump to the start of the file + (99 * rec >>

Re: Free Valentina Database

2011-12-15 Thread MB Software Solutions, LLC
On 12/15/2011 7:57 AM, Ed Leafe wrote: > His point was since they were offsets and not actual stored values, > they were more efficient. Valentina records are fixed length, so to get > RecID=99 the software only has to jump to the start of the file + (99 * rec > length). Isn't this how V

Re: Free Valentina Database

2011-12-15 Thread Ed Leafe
On Dec 15, 2011, at 8:20 AM, Paul Newton wrote: > Which "better options" do you have in mind? Depends on the use case. For relational servers, PostgreSQL is my choice. For embedded, SQLite and Firebird are excellent. If you need both server and embedded, Firebird looks like a winner. Fo

RE: Free Valentina Database

2011-12-15 Thread Paul Newton
Ed Which "better options" do you have in mind? Paul Newton -Original Message- From: profoxtech-boun...@leafe.com [mailto:profoxtech-boun...@leafe.com] On Behalf Of Ed Leafe Sent: 15 December 2011 12:57 To: profoxt...@leafe.com Subject: Re: Free Valentina Database On Dec 14,

Re: Free Valentina Database

2011-12-15 Thread Ed Leafe
On Dec 14, 2011, at 8:02 PM, Ken Dibble wrote: > "Valentina does not require the creation of KEY fields - you can avoid the > headache of filling in unique values. > > Each Valentina Table has a special RecID field, which provides a unique > number for a record of this table." [snip] >

Re: Free Valentina Database

2011-12-14 Thread Ken Dibble
>Working on the basis that anything from David Crozir Esq is worthy of a >read, here is an article re differences between their database V >Database the Relational Way: >http://www.valentina-db.com/en/developer-articles/104-5-minute-technical-intro-to-valentina From the article: "Valentina does

Re: Free Valentina Database

2011-12-14 Thread Allen
I was thinking that too. Thanks Dave Al -Original Message- From: Dave Crozier Sent: Wednesday, December 14, 2011 4:46 PM To: profoxt...@leafe.com Subject: RE: Free Valentina Database This may be of use to Allen as I know he doesn't like setting up SQL servers such as M$SQL etc be

RE: Free Valentina Database

2011-12-14 Thread Dave Crozier
ember 2011 15:13 To: profox@leafe.com Subject: Re: Free Valentina Database Working on the basis that anything from David Crozir Esq is worthy of a read, here is an article re differences between their database V Database the Relational Way: http://www.valentina-db.com/en/developer-articles/104-5-m

Re: Free Valentina Database

2011-12-14 Thread Andrew Stirling
Working on the basis that anything from David Crozir Esq is worthy of a read, here is an article re differences between their database V Database the Relational Way: http://www.valentina-db.com/en/developer-articles/104-5-minute-technical-intro-to-valentina Kind regards Andrew Stirling 01250 87

Re: Free Valentina Database

2011-12-14 Thread Ed Leafe
On Dec 14, 2011, at 4:42 AM, Dave Crozier wrote: > Some of you may be interested to know that the Valentina Relational Database > Office server is now available completely free. > > http://www.valentina-db.com/ > > It is ODBC compliant so you can use it with VFP. > > Oh, and it's fast > >

RE: Free Valentina Database

2011-12-14 Thread Dave Crozier
Just to clarify using Web edition of RB as you can't generate stand alone iPhone apps ...yet. Dave -Original Message- From: profox-boun...@leafe.com [mailto:profox-boun...@leafe.com] On Behalf Of Dave Crozier Sent: 14 December 2011 10:42 To: ProFox Email List Subject: Free Valentina