Opening Valentina v1.11 in Revolution

[Trevor DeVore]

On Dec 16, 2005, at 6:57 PM, David Vaughan wrote:

> Hello, a simple starter question.
>
> I am developing a comparatively small database in the sense that  
> the data volume will not be huge, although it will comprise around  
> 12-14 tables. I have started using SQLite but thought I would  
> compare using Valentina. However, this is proving less convenient  
> because so far Valentina will not run!
>
> I can open Valentina from RunRev using the Valentina XCMD but not  
> using <revOpenDatabase>, which looks like this:
>
> get revOpenDatabase("Valentina","",DBpath,,,,valentinaSerial,"")
>
> DBpath and valentinaSerial are set in the exactly same manner as in  
> the successful XCMD method.
> The Rev function returns "invalid database type".

Hi David,

I would suggest avoiding RevDB when using Valentina.  As Ruslan said,  
RevDB doesn't use the latest version of Valentina and it doesn't give  
you access to the Valentina API.  I use Valentina quite a bit and  
SQLite on occasion.  What I did was build a wrapper around revdb and  
the Valentina external which handles database connection, record  
fetching, updating and adding.  libDatabase uses revdb for everything  
except Valentina.  For Valentina you use the XCMD. You can take a  
look at the library here:

http://www.mangomultimedia.com/developer/revolution/

I would recommend the 2.0 beta version.  The library will make it  
easier to experiment with the Valentina and if you decide to use it  
you can still exploit the Valentina API if you want.  To use  
libDatabse with Valentina you just need to make sure the Valentina  
XCMD is loaded and that the handlers are available in the message  
path.  I recommend that you use the stack that the external is  
attached to as a library (start using stack "MyValentinaExternalStack").

I don't have a version available for Valentina 2.0 yet but it is in  
testing.

If you have any questions let me know.

-- 
Trevor DeVore
Blue Mango Multimedia
trevor at mangomultimedia.com