Close all open databases -- VDataBase_Open()

[Mark Schonewille]

Hi William,

PHP was a bit of a nuisance, but the first time I installed MySQL, it 
was easy once I got it compiled.

That's isn't really the problem, though. I don't quite understand why 
there is a complicated API, if there is already a SQL language. Yes, 
using the API has an advantage, because LiveCode's SQL commands are very 
limited, but we don't need that extensive API.

When using databases, I always compare the front-end languages with PHP. 
If PHP doesn't have it, then it is not necessary. LiveCode lacks a lot 
that PHP has, but Valentina has a lot that PHP proofs to be unnecessary.

--
Best regards,

Mark Schonewille

Economy-x-Talk Consulting and Software Engineering
Homepage: http://economy-x-talk.com
Twitter: http://twitter.com/xtalkprogrammer
KvK: 50277553

Use Color Converter to convert CMYK, RGB, RAL, XYZ, H.Lab and other 
colour spaces. http://www.color-converter.com

Buy my new book "Programming LiveCode for the Real Beginner" 
http://qery.us/3fi

Fill out this survey please
http://livecodebeginner.economy-x-talk.com/survey/

On 10/15/2013 00:35, William Humphrey wrote:
> I told you. Doesn't it remind you of early days installing php and MySQL on Apache?
>
> Brevity and errors in this email probably the result of being sent by a mobile device.
>
>> On Oct 14, 2013, at 5:15 PM, Mark Schonewille <m.schonewille at economy-x-talk.com> wrote:
>>
>> Hi William,
>>
>> That's interesting. I will play with it tomorrow. I need to check if your examples will allow me to write a script that closes all databases. For debugging, it is really useful to be able to close all databases and close a connection before opening a new one.
>>
>> It strikes me how utterly complicated all this is, very much contradicting the spirit of LiveCode.
>>
>> --
>> Best regards,
>>
>> Mark Schonewille
>>
>> Economy-x-Talk Consulting and Software Engineering
>> Homepage: http://economy-x-talk.com
>> Twitter: http://twitter.com/xtalkprogrammer
>> KvK: 50277553
>>
>> Use Color Converter to convert CMYK, RGB, RAL, XYZ, H.Lab and other colour spaces. http://www.color-converter.com
>>
>> Buy my new book "Programming LiveCode for the Real Beginner" http://qery.us/3fi
>>
>> Fill out this survey please
>> http://livecodebeginner.economy-x-talk.com/survey/
>>
>>> On 10/14/2013 20:33, william humphrey wrote:
>>>
>>> On Mon, Oct 14, 2013 at 2:26 PM, william humphrey
>>> <bill at bluewatermaritime.com <mailto:bill at bluewatermaritime.com>> wrote:
>>>
>>>     get Valentina_Database( inIntIndex )
>>>
>>>
>>> OK - I just solved it.
>>>
>>> Use *put Valentina_DatabaseCount()*
>>> *( Remember no Valentina functions work in the message box you have to
>>> make a button that cals it from a script)*
>>> *
>>> *
>>> Then after you do the database count you will have a number, say 2
>>>
>>> Then use
>>>
>>> *put* Valentina_Database(1) into dbRefFirstDatabase
>>>
>>> and
>>>
>>> *put* Valentina_Database(2) dbRefFirstDatabase
>>>
>>>
>>> You will have the dbRef you need to close those databases. If you want
>>> to know the name of the database from the dbRef you must use yet another
>>> function (in case you don't want to close all the databases).
>>>
>>> Hope this helps.
>>> --
>>> http://www.bluewatermaritime.com
>>
>> _______________________________________________
>> Valentina mailing list
>> Valentina at lists.macserve.net
>> http://lists.macserve.net/mailman/listinfo/valentina
> _______________________________________________
> Valentina mailing list
> Valentina at lists.macserve.net
> http://lists.macserve.net/mailman/listinfo/valentina
>