<html><body style="word-wrap: break-word; -webkit-nbsp-mode: space; -webkit-line-break: after-white-space; ">Hi Greg,<div><br><div><div>On 22.08.2009, at 01:29, Greg Olson-Hyde wrote:</div><br class="Apple-interchange-newline"><blockquote type="cite"><span class="Apple-style-span" style="border-collapse: separate; color: rgb(0, 0, 0); font-family: Helvetica; font-size: medium; font-style: normal; font-variant: normal; font-weight: normal; letter-spacing: normal; line-height: normal; orphans: 2; text-align: auto; text-indent: 0px; text-transform: none; white-space: normal; widows: 2; word-spacing: 0px; -webkit-border-horizontal-spacing: 0px; -webkit-border-vertical-spacing: 0px; -webkit-text-decorations-in-effect: none; -webkit-text-size-adjust: auto; -webkit-text-stroke-width: 0px; "><div>1. My complete app, on the Mac using SQLite, would consist of the RB file (10MB) and the SQLite database file (63MB) - what files would I have to ship if I use Valentina - is the database engine built-in (<span class="Apple-style-span" style="font-family: 'Lucida Grande'; font-size: 12px; ">V4RB.rbx?) or is it external to the RB app<span class="Apple-style-span" style="font-family: Helvetica; font-size: medium; ">? Approximately what sizes would they be? I am hoping I don't have to ship the 80MB Valentina Studio Pro app with my app! I will also be shipping for Windows and Linux.</span></span></div></span></blockquote><div><br></div>The app will get a bit larger because of the Vcomponents file. My own app currently is about 74 MB, which compresses to about 20 MB. Of course, the database engine is contained within the app.<br><blockquote type="cite"><span class="Apple-style-span" style="border-collapse: separate; color: rgb(0, 0, 0); font-family: Helvetica; font-size: medium; font-style: normal; font-variant: normal; font-weight: normal; letter-spacing: normal; line-height: normal; orphans: 2; text-align: auto; text-indent: 0px; text-transform: none; white-space: normal; widows: 2; word-spacing: 0px; -webkit-border-horizontal-spacing: 0px; -webkit-border-vertical-spacing: 0px; -webkit-text-decorations-in-effect: none; -webkit-text-size-adjust: auto; -webkit-text-stroke-width: 0px; "><div><br></div><div>2. I am looking at the "Choosing a Style of Coding" web site on Valentina (<a href="http://valentina-db.com/dokuwiki/doku.php?id=valentina:articles:coding_style">http://valentina-db.com/dokuwiki/doku.php?id=valentina:articles:coding_style</a>). As none of my apps have shipped, I guess I can change to any coding style. Which one would be best? I foresee my app primarily being a non-networked, single user, local database, although, someone, I am sure, is going to want to network the app, so I don't want to close the network door.</div></span></blockquote><div><br></div>If you use SQL then this also will work with Valentina.</div><div><blockquote type="cite"><span class="Apple-style-span" style="border-collapse: separate; color: rgb(0, 0, 0); font-family: Helvetica; font-size: medium; font-style: normal; font-variant: normal; font-weight: normal; letter-spacing: normal; line-height: normal; orphans: 2; text-align: auto; text-indent: 0px; text-transform: none; white-space: normal; widows: 2; word-spacing: 0px; -webkit-border-horizontal-spacing: 0px; -webkit-border-vertical-spacing: 0px; -webkit-text-decorations-in-effect: none; -webkit-text-size-adjust: auto; -webkit-text-stroke-width: 0px; "><div><br></div><div>3. How hard is it to do the "whole word search" for 'hat' in Valentina and only return the 39 records?</div></span></blockquote><div><br></div>This is as simple as using regex.<br><blockquote type="cite"><span class="Apple-style-span" style="border-collapse: separate; color: rgb(0, 0, 0); font-family: Helvetica; font-size: medium; font-style: normal; font-variant: normal; font-weight: normal; letter-spacing: normal; line-height: normal; orphans: 2; text-align: auto; text-indent: 0px; text-transform: none; white-space: normal; widows: 2; word-spacing: 0px; -webkit-border-horizontal-spacing: 0px; -webkit-border-vertical-spacing: 0px; -webkit-text-decorations-in-effect: none; -webkit-text-size-adjust: auto; -webkit-text-stroke-width: 0px; "><div><br></div><div>4. What other search options are available in Valentina? I assume I can do: 'Begins with', 'Ends with', 'Contains', 'Greater than', 'Less than', 'Is', 'Isn't' - are there others?</div></span></blockquote><div><br></div>See answer before.<br><blockquote type="cite"><span class="Apple-style-span" style="border-collapse: separate; color: rgb(0, 0, 0); font-family: Helvetica; font-size: medium; font-style: normal; font-variant: normal; font-weight: normal; letter-spacing: normal; line-height: normal; orphans: 2; text-align: auto; text-indent: 0px; text-transform: none; white-space: normal; widows: 2; word-spacing: 0px; -webkit-border-horizontal-spacing: 0px; -webkit-border-vertical-spacing: 0px; -webkit-text-decorations-in-effect: none; -webkit-text-size-adjust: auto; -webkit-text-stroke-width: 0px; "><div><br></div><div>5. Are my existing SQLite database tables able to be imported into Valentina or do I have to create them from the beginning? (no big deal, would just make life easier!)</div><div><br></div><div>6. How easy would it be to import the data from my existing SQLite database?</div></span></blockquote><div><br></div>Don't know.<br><blockquote type="cite"><span class="Apple-style-span" style="border-collapse: separate; color: rgb(0, 0, 0); font-family: Helvetica; font-size: medium; font-style: normal; font-variant: normal; font-weight: normal; letter-spacing: normal; line-height: normal; orphans: 2; text-align: auto; text-indent: 0px; text-transform: none; white-space: normal; widows: 2; word-spacing: 0px; -webkit-border-horizontal-spacing: 0px; -webkit-border-vertical-spacing: 0px; -webkit-text-decorations-in-effect: none; -webkit-text-size-adjust: auto; -webkit-text-stroke-width: 0px; "><div><br></div><div>7. There are a large number of examples that downloaded with <span class="Apple-style-span" style="font-family: 'Lucida Grande'; font-size: 12px; ">V4RB_4, which ones would be the best to start with? I find them confusing as there is no "Read Me" to explain what they do - although some of them are self explanatory.</span></div></span></blockquote><div><br></div>Just work through them.<br><blockquote type="cite"><span class="Apple-style-span" style="border-collapse: separate; color: rgb(0, 0, 0); font-family: Helvetica; font-size: medium; font-style: normal; font-variant: normal; font-weight: normal; letter-spacing: normal; line-height: normal; orphans: 2; text-align: auto; text-indent: 0px; text-transform: none; white-space: normal; widows: 2; word-spacing: 0px; -webkit-border-horizontal-spacing: 0px; -webkit-border-vertical-spacing: 0px; -webkit-text-decorations-in-effect: none; -webkit-text-size-adjust: auto; -webkit-text-stroke-width: 0px; "><div><br></div><div>8. I have tried the tutorial (<a href="http://valentina-db.com/dokuwiki/doku.php?id=valentina:products:adk:v4rb:tutorial:lesson1">http://valentina-db.com/dokuwiki/doku.php?id=valentina:products:adk:v4rb:tutorial:lesson1</a>) - but could not get it to work - is there a file of the completed tutorial I could look at to see where I went wrong?</div></span></blockquote></div><div><br></div><div>Have a look at the example Common/Database_CreateCloseOpen.</div><br><div apple-content-edited="true"> <div><p style="margin: 0.0px 0.0px 0.0px 0.0px"><font face="Helvetica" size="3" style="font: 12.0px Helvetica">Mit freundlichen Grüßen/Regards</font></p> <p style="margin: 0.0px 0.0px 0.0px 0.0px; font: 12.0px Helvetica; min-height: 14.0px"><br></p> <p style="margin: 0.0px 0.0px 0.0px 0.0px"><font face="Helvetica" size="3" style="font: 12.0px Helvetica">Trixi Willius</font></p> <p style="margin: 0.0px 0.0px 0.0px 0.0px; font: 12.0px Helvetica; min-height: 14.0px"><br></p> <p style="margin: 0.0px 0.0px 0.0px 0.0px"><font face="Helvetica" size="3" style="font: 12.0px Helvetica"><a href="http://www.mothsoftware.com">http://www.mothsoftware.com</a></font></p> <p style="margin: 0.0px 0.0px 0.0px 0.0px"><font face="Helvetica" size="3" style="font: 12.0px Helvetica">Mail Archiver X: archive, clean and search email</font></p> <p style="margin: 0.0px 0.0px 0.0px 0.0px"><font face="Helvetica" size="3" style="font: 12.0px Helvetica"><a href="http://www.beatrixwillius.de">http://www.beatrixwillius.de</a></font></p> <p style="margin: 0.0px 0.0px 0.0px 0.0px"><font face="Helvetica" size="3" style="font: 12.0px Helvetica">Fractals, 3d landscapes etc.</font></p> </div> </div><br></div></body></html>