valentina, externals of libdatabase

Bernard Devlin bdrunrev at gmail.com
Mon Jan 11 12:57:35 EST 2010


Just responding to myself, for the sake of anyone else who uses
Valentina 2 with libDatabase.  I am sure that most people will be
using Sql Yoga, still...

I have only been trying out the basic functionality of libDatabase,
and but that is working.  These were the issues I came across:

1) Valentina install.  I made a mistake here.  I had installed
Valentina in Rev on various versions of Linux.  When I subsequently
installed it on Windows, I only unzipped it and forgot to run
install.rev.  After I ran install.rev, the correct changes were made
to the Rev install and Valentina functionality was available within
the IDE.

2) There is a minor bug in libDatabase when it comes to getting the
column names back from Valentina (it looks like it would only be an
issue with Valentina2).  This can be fixed within the function
libdb_columnNames, by substituting this line:

put VField_Value(it) &comma after tReturn

with this line:

put VField_Name(it) &comma after tReturn

I know it's late in the day, but thanks Trevor for providing us with
such a transparent solution for working with Rev and databases.  I'm
not sure if Valentina will turn out to be what I want, or if I will go
on to use SQL Yoga in the future.  But for sheer ease of getting
started with a new db technology, libDatabase is a gem.

Bernard



More information about the use-livecode mailing list