Shocked to find can't init valentina with LiveCode

Barry G. Sumpter barrysum at bigpond.net.au
Thu Mar 8 16:51:03 CST 2012


Again ExampleTools.rev needs update:

function MakeNewDatabase
   if the gClient of this stack is true then   
      if the gSSLEnable of this stack is true then
         put VConnection_Constructor("localhost", "sa", "sa", 15432) into
gConnection
         get VConnection_UseSSL( gConnection )
      else
         put VConnection_Constructor("localhost", "sa", "sa") into
gConnection
      end if
      
      get VConnection_Open( gConnection )    --   ==================>>>>>>>
get was missing here 
      return VDatabase_Constructor( gConnection )
   else
      return VDatabase_Constructor()
   end if

This Create_Close_Open DB was created under myLocalHostName(SSL)

-----Original Message-----
From: valentina-bounces at lists.macserve.net
[mailto:valentina-bounces at lists.macserve.net] On Behalf Of
valentina-request at lists.macserve.net
Sent: Friday, 9 March 2012 8:13 AM
To: valentina at lists.macserve.net
Subject: Valentina Digest, Vol 111, Issue 9

Send Valentina mailing list submissions to
	valentina at lists.macserve.net

To subscribe or unsubscribe via the World Wide Web, visit
	http://lists.macserve.net/mailman/listinfo/valentina
or, via email, send a message with subject or body 'help' to
	valentina-request at lists.macserve.net

You can reach the person managing the list at
	valentina-owner at lists.macserve.net

When replying, please edit your Subject line so it is more specific than
"Re: Contents of Valentina digest..."


Today's Topics:

   1. Re: Shocked to find can't init valentina with LiveCode
      (Ruslan Zasukhin)
   2. Re: Shocked to find can't init valentina with LiveCode
      (Ruslan Zasukhin)
   3. Shocked to find can't init valentina with LiveCode
      (Barry G. Sumpter)
   4. Re: v4rev adk help, can't open a new database (from the
      beginning	lesson example) (Ruslan Zasukhin)
   5. Re: Shocked to find can't init valentina with LiveCode
      (Thorsten Hohage)
   6. Re: select into... (Ruslan Zasukhin)
   7. Re: select into...  And Valentina.CopyCursorToNewTable()
      (Ruslan Zasukhin)


----------------------------------------------------------------------

Message: 1
Date: Thu, 08 Mar 2012 22:54:36 +0200
From: Ruslan Zasukhin <ruslan_zasukhin at valentina-db.com>
To: "valentina at lists.macserve.net" <valentina at lists.macserve.net>
Subject: Re: Shocked to find can't init valentina with LiveCode
Message-ID: <CB7EE92C.FBBBE%ruslan_zasukhin at valentina-db.com>
Content-Type: text/plain;	charset="US-ASCII"

On 3/8/12 5:49 PM, "Mike Bonner" <bonnmike at gmail.com> wrote:

Hi Mike,

Sorry for late jump, today is holiday here ...

1) yes Valentina_Init() and
          Valentina_InitClient() use different parameters.

Have you found this document:
    http://www.valentina-db.com/docs/v4/V4REV_Reference_4_en.pdf

Here is described in details each V4REV function.
And Oops. I see that initClient() do not show params in this document.
I will fix this asap and drop note here that new  PDF is uploaded.

Another secret.  In Valentina WIKI, we have the most up to date API Section
not bound to any language. This can be named Model of Valentina API.

<http://www.valentina-db.com/dokuwiki/doku.php?id=valentina:products:adk:api
:api>


> I'm finally figuring things out, I believe valentina_initClient 
> doesn't require a serial (and i can't make it work if I put one in) 
> not sure it even takes a cache size.

RIGHT.

ANY Valentina client is FREE and can be used for FREE.
No need serials here.

And few months ago, we have add into InitClient( cacheSize ), To improve
things on client side.


> valentina_init() DOES take cache size and serials. I think the premise 
> is that if you're using the client version you must have a valid 
> license for one of the valentina servers so that the serial for the 
> adk isn't needed in that situation.

exactly


> Found all the example stacks thx to barry that came with the adk. Have 
> NO idea how long i've been fighting all this stuff for so long using 
> the wiki tutorial. Gave up every time I tried but hey, with the 
> example stacks there are actual working setups that can be ripped 
> apart so i'm suddenly in happy land.

I don't know why it was hard to found examples...

Folder 
        My Documents/Paradigma Software/ADK_XXX

Should be mentioned in the ReadMe  and is same for all our ADKs.


If any more questions -- please ask here



--
Best regards,

Ruslan Zasukhin
VP Engineering and New Technology
Paradigma Software, Inc

Valentina - Joining Worlds of Information http://www.paradigmasoft.com

[I feel the need: the need for speed]




------------------------------

Message: 2
Date: Thu, 08 Mar 2012 22:58:29 +0200
From: Ruslan Zasukhin <ruslan_zasukhin at valentina-db.com>
To: "valentina at lists.macserve.net" <valentina at lists.macserve.net>
Subject: Re: Shocked to find can't init valentina with LiveCode
Message-ID: <CB7EEA15.FBBC0%ruslan_zasukhin at valentina-db.com>
Content-Type: text/plain;	charset="ISO-8859-1"

On 3/8/12 6:34 PM, "william humphrey" <bill at bluewatermaritime.com> wrote:

Hi William,

> GREAT NEWS, My other advice is to not use any the "v" commands in 
> livecode and don't use any of the livecode ones that are supposed to 
> work with any database. Some don't work and some give spectacular 
> crashes. I do just about everything with SQL calls in?VDatabase_SqlSelect
and am quit happy.?

Well yesterday Kirill have check on MAcOS V4REV I see 3 was corrected in SVN
...

And RevDB  API we must test carefully once again


--
Best regards,

Ruslan Zasukhin
VP Engineering and New Technology
Paradigma Software, Inc

Valentina - Joining Worlds of Information http://www.paradigmasoft.com

[I feel the need: the need for speed]




------------------------------

Message: 3
Date: Fri, 9 Mar 2012 08:01:18 +1100
From: "Barry G. Sumpter" <barrysum at bigpond.net.au>
To: <valentina at lists.macserve.net>
Subject: Shocked to find can't init valentina with LiveCode
Message-ID: <001c01ccfd6e$9bb322e0$d31968a0$@bigpond.net.au>
Content-Type: text/plain;	charset="us-ascii"

LOL.

Yes, the wiki has always been weird.
Working with LiveCode has always been weird.

So the combination of working with both is exponentially weird not just
doubly weird.

If anyone else is following this v4Rev (Valentina for Revolution (LiveCode))
Once you install v4Rev you can find samples LiveCode apps here (I suggest
starting with this example):
M:\Documents and Settings\Barry\My Documents\Paradigma
Software\V4REV_4\Examples\Common\Database_CreateCloseOpen
Using LiveCode on 64 bit machines has its own issues over and above 32 bit
machines.

I developed quite a bit of val_initClient timers in RealBasic To test SNs,
invalid SNs, blank SNs to find that the vDB will open and work but only for
a few minutes.
I could swear around 10 mins.  Never exactly.  
So even with an INVALID serial number it would work for around 10 mins. (?)
With a valid SN I had to be careful not to post the SN with coding examples.

I feel Paradigma should update the install to include notes on the Examples
etc on the final page of the install.
With shortcuts to the doco and examples folders created on the desktop and
taskbar.

With a little help from both Mike here and Sturgis on the LiveCode forums.
I hope to write a step-by-step doco.

http://forums.runrev.com/phpBB2/viewtopic.php?f=15&t=11322

-- put true into gClient -- YOU NEED MODIFY THIS TO TRUE FOR CLIENT-SERVER
mode of examples.
-- MUST BE CHANGED TO THE FOLLOWING in ALL v4Rev samples i.e.
ExampleTools.rev:
set the gClient of this stack to true
--And remember that the LiveCode mouse over debugger for gClient --shows the
popup value of the local gClient and NOT the value of gClient of this stack.


hth





-----Original Message-----
From: valentina-bounces at lists.macserve.net
[mailto:valentina-bounces at lists.macserve.net] On Behalf Of
valentina-request at lists.macserve.net
Sent: Friday, 9 March 2012 3:36 AM
To: valentina at lists.macserve.net
Subject: Valentina Digest, Vol 111, Issue 8

Send Valentina mailing list submissions to
	valentina at lists.macserve.net

To subscribe or unsubscribe via the World Wide Web, visit
	http://lists.macserve.net/mailman/listinfo/valentina
or, via email, send a message with subject or body 'help' to
	valentina-request at lists.macserve.net

You can reach the person managing the list at
	valentina-owner at lists.macserve.net

When replying, please edit your Subject line so it is more specific than
"Re: Contents of Valentina digest..."


Today's Topics:

   1. Re: Shocked to find can't init valentina with LiveCode
      (Mike Bonner)
   2. Re: Shocked to find can't init valentina with LiveCode
      (william humphrey)
   3. Re: Shocked to find can't init valentina with LiveCode
      (william humphrey)


----------------------------------------------------------------------

Message: 1
Date: Thu, 8 Mar 2012 08:49:39 -0700
From: Mike Bonner <bonnmike at gmail.com>
To: Valentina Developers <valentina at lists.macserve.net>
Subject: Re: Shocked to find can't init valentina with LiveCode
Message-ID:
	<CAG1cpSp8mSWytBx0fzKZyhJCi6fcfDSeC=4FLM+vkFuHG+E4vA at mail.gmail.com>
Content-Type: text/plain; charset="iso-8859-1"

I'm finally figuring things out, I believe valentina_initClient doesn't
require a serial (and i can't make it work if I put one in) not sure it even
takes a cache size.
valentina_init() DOES take cache size and serials. I think the premise is
that if you're using the client version you must have a valid license for
one of the valentina servers so that the serial for the adk isn't needed in
that situation.

Found all the example stacks thx to barry that came with the adk. Have NO
idea how long i've been fighting all this stuff for so long using the wiki
tutorial. Gave up every time I tried but hey, with the example stacks there
are actual working setups that can be ripped apart so i'm suddenly in happy
land.



On Thu, Mar 8, 2012 at 8:33 AM, william humphrey <bill at bluewatermaritime.com
> wrote:

> I've never had much luck with the samples either. I think someone 
> should go through and test every sample with latest Mac OS operating 
> system and latest LiveCode and latest Valentina install and just 
> delete all the samples which no longer work. It would be wonderful if 
> the samples were designed for a first time user.
>
> In your stack connection should look like (in this order):
>
>   *get* Valentina_InitClient( 10 * 1024 * 1024,"extremely long serial 
> number stuff here",)
>
>    *-- There has been a change so maybe serial numbers aren't needed 
> now?*
>
>    *get* Valentina_DebugLevel("kLogParams")
>
>    *-- first establish connectionRef as gConnection*
>
>    *put* VConnection_Constructor("localhost", "sa", "sa", 15432) 
> intogConnection
>
>    *-- next you establish dbRef as gDatabase*
>
>    *put* VDatabase_Constructor( gConnection ) into gDatabase
>
>    *get* VDatabase_DateFormat(gDatabase, "kYMD")
>
>    *get* VDatabase_DateSep(gDatabase, "-")
>
>    *get* VDatabase_Open( gDatabase, b_l_database.vdb )
>
>
>
>    *if* it contains "ERROR" *then*
>
>       *answer* "there was an error in DatabaseOpen"
>
>             *exit* to top
>
>    *end* *if*
>
> _______________________________________________
> Valentina mailing list
> Valentina at lists.macserve.net
> http://lists.macserve.net/mailman/listinfo/valentina
>
>
-------------- next part --------------
An HTML attachment was scrubbed...
URL:
<http://lists.macserve.net/pipermail/valentina/attachments/20120308/ce195a6b
/attachment-0001.html>

------------------------------

Message: 2
Date: Thu, 8 Mar 2012 12:34:55 -0400
From: william humphrey <bill at bluewatermaritime.com>
To: Valentina Developers <valentina at lists.macserve.net>
Subject: Re: Shocked to find can't init valentina with LiveCode
Message-ID:
	<CA+ZPFi9CV1AETjdWV-_c9KLtke_HNa8bvhfjh+S265oTQuOBFQ at mail.gmail.com>
Content-Type: text/plain; charset="iso-8859-1"

GREAT NEWS, My other advice is to not use any the "v" commands in livecode
and don't use any of the livecode ones that are supposed to work with any
database. Some don't work and some give spectacular crashes. I do just about
everything with SQL calls in VDatabase_SqlSelect and am quit happy.

On Thu, Mar 8, 2012 at 11:49 AM, Mike Bonner <bonnmike at gmail.com> wrote:

> I'm finally figuring things out, I believe valentina_initClient 
> doesn't require a serial (and i can't make it work if I put one in) 
> not sure it even takes a cache size.
> valentina_init() DOES take cache size and serials. I think the premise 
> is that if you're using the client version you must have a valid 
> license for one of the valentina servers so that the serial for the 
> adk isn't needed in that situation.
>
> Found all the example stacks thx to barry that came with the adk. Have 
> NO idea how long i've been fighting all this stuff for so long using 
> the wiki tutorial. Gave up every time I tried but hey, with the 
> example stacks there are actual working setups that can be ripped 
> apart so i'm suddenly in happy land.
>
>
>
> On Thu, Mar 8, 2012 at 8:33 AM, william humphrey < 
> bill at bluewatermaritime.com> wrote:
>
>> I've never had much luck with the samples either. I think someone 
>> should go through and test every sample with latest Mac OS operating 
>> system and latest LiveCode and latest Valentina install and just 
>> delete all the samples which no longer work. It would be wonderful if 
>> the samples were designed for a first time user.
>>
>> In your stack connection should look like (in this order):
>>
>>   *get* Valentina_InitClient( 10 * 1024 * 1024,"extremely long serial 
>> number stuff here",)
>>
>>    *-- There has been a change so maybe serial numbers aren't needed now?
>> *
>>
>>    *get* Valentina_DebugLevel("kLogParams")
>>
>>    *-- first establish connectionRef as gConnection*
>>
>>    *put* VConnection_Constructor("localhost", "sa", "sa", 15432) 
>> intogConnection
>>
>>    *-- next you establish dbRef as gDatabase*
>>
>>    *put* VDatabase_Constructor( gConnection ) into gDatabase
>>
>>    *get* VDatabase_DateFormat(gDatabase, "kYMD")
>>
>>    *get* VDatabase_DateSep(gDatabase, "-")
>>
>>    *get* VDatabase_Open( gDatabase, b_l_database.vdb )
>>
>>
>>
>>    *if* it contains "ERROR" *then*
>>
>>       *answer* "there was an error in DatabaseOpen"
>>
>>             *exit* to top
>>
>>    *end* *if*
>>
>> _______________________________________________
>> 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
>
>


--
http://www.bluewatermaritime.com
-------------- next part --------------
An HTML attachment was scrubbed...
URL:
<http://lists.macserve.net/pipermail/valentina/attachments/20120308/5139896b
/attachment-0001.html>

------------------------------

Message: 3
Date: Thu, 8 Mar 2012 12:35:44 -0400
From: william humphrey <bill at bluewatermaritime.com>
To: Valentina Developers <valentina at lists.macserve.net>
Subject: Re: Shocked to find can't init valentina with LiveCode
Message-ID:
	<CA+ZPFi91JQV0caQOOhVxT9g2hxv2kTFpnh=t33oysfxMJ31noQ at mail.gmail.com>
Content-Type: text/plain; charset="iso-8859-1"

My last email should say use only the "v" commands.

On Thu, Mar 8, 2012 at 12:34 PM, william humphrey <
bill at bluewatermaritime.com> wrote:

> GREAT NEWS, My other advice is to not use any the "v" commands in 
> livecode and don't use any of the livecode ones that are supposed to 
> work with any database. Some don't work and some give spectacular 
> crashes. I do just about everything with SQL calls in VDatabase_SqlSelect
and am quit happy.
>
>
> On Thu, Mar 8, 2012 at 11:49 AM, Mike Bonner <bonnmike at gmail.com> wrote:
>
>> I'm finally figuring things out, I believe valentina_initClient 
>> doesn't require a serial (and i can't make it work if I put one in) 
>> not sure it even takes a cache size.
>> valentina_init() DOES take cache size and serials. I think the 
>> premise is that if you're using the client version you must have a 
>> valid license for one of the valentina servers so that the serial for 
>> the adk isn't needed in that situation.
>>
>> Found all the example stacks thx to barry that came with the adk. 
>> Have NO idea how long i've been fighting all this stuff for so long 
>> using the wiki tutorial. Gave up every time I tried but hey, with the 
>> example stacks there are actual working setups that can be ripped 
>> apart so i'm suddenly in happy land.
>>
>>
>>
>> On Thu, Mar 8, 2012 at 8:33 AM, william humphrey < 
>> bill at bluewatermaritime.com> wrote:
>>
>>> I've never had much luck with the samples either. I think someone 
>>> should go through and test every sample with latest Mac OS operating 
>>> system and latest LiveCode and latest Valentina install and just 
>>> delete all the samples which no longer work. It would be wonderful 
>>> if the samples were designed for a first time user.
>>>
>>> In your stack connection should look like (in this order):
>>>
>>>   *get* Valentina_InitClient( 10 * 1024 * 1024,"extremely long 
>>> serial number stuff here",)
>>>
>>>    *-- There has been a change so maybe serial numbers aren't needed
>>> now?*
>>>
>>>    *get* Valentina_DebugLevel("kLogParams")
>>>
>>>    *-- first establish connectionRef as gConnection*
>>>
>>>    *put* VConnection_Constructor("localhost", "sa", "sa", 15432) 
>>> intogConnection
>>>
>>>    *-- next you establish dbRef as gDatabase*
>>>
>>>    *put* VDatabase_Constructor( gConnection ) into gDatabase
>>>
>>>    *get* VDatabase_DateFormat(gDatabase, "kYMD")
>>>
>>>    *get* VDatabase_DateSep(gDatabase, "-")
>>>
>>>    *get* VDatabase_Open( gDatabase, b_l_database.vdb )
>>>
>>>
>>>
>>>    *if* it contains "ERROR" *then*
>>>
>>>       *answer* "there was an error in DatabaseOpen"
>>>
>>>             *exit* to top
>>>
>>>    *end* *if*
>>>
>>> _______________________________________________
>>> 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
>>
>>
>
>
> --
> http://www.bluewatermaritime.com
>



--
http://www.bluewatermaritime.com
-------------- next part --------------
An HTML attachment was scrubbed...
URL:
<http://lists.macserve.net/pipermail/valentina/attachments/20120308/546f7f92
/attachment.html>

------------------------------

_______________________________________________
Valentina mailing list
Valentina at lists.macserve.net
http://lists.macserve.net/mailman/listinfo/valentina


End of Valentina Digest, Vol 111, Issue 8
*****************************************



------------------------------

Message: 4
Date: Thu, 08 Mar 2012 23:02:34 +0200
From: Ruslan Zasukhin <ruslan_zasukhin at valentina-db.com>
To: "valentina at lists.macserve.net" <valentina at lists.macserve.net>
Subject: Re: v4rev adk help, can't open a new database (from the
	beginning	lesson example)
Message-ID: <CB7EEB0A.FBBC6%ruslan_zasukhin at valentina-db.com>
Content-Type: text/plain;	charset="ISO-8859-1"

On 3/8/12 3:30 PM, "Mike Bonner" <bonnmike at gmail.com> wrote:

Hi Mike,

> Yep, sorry for bothering you. I was going through the stuff on the wiki
and
> they just don't work as written, but then someone else pointed out all the
> example stacks in the v4rev example folders and viola' Working examples so
I
> could get a handle on things.?

Please point me what exactly from WIKI did not work ?

Tutorial ?
   we have couple for V4REV I think ...

Else?

Please while you have it in memory yet, what was wrong?
 

> No more wiki for me, don't know why I never discovered the example stacks
> before this. ?They work great.?

This is good.

In WIKI exists also Example Guide for V4REV,
Some ideas are described

Gclient flag is important in examples ...

<http://www.valentina-db.com/dokuwiki/doku.php?id=valentina:products:adk:exa
mples:guide:v4rev:v4rev>


-- 
Best regards,

Ruslan Zasukhin
VP Engineering and New Technology
Paradigma Software, Inc

Valentina - Joining Worlds of Information
http://www.paradigmasoft.com

[I feel the need: the need for speed]




------------------------------

Message: 5
Date: Thu, 8 Mar 2012 22:04:26 +0100
From: Thorsten Hohage <thohage at genericobjects.de>
To: Valentina Developers <valentina at lists.macserve.net>
Subject: Re: Shocked to find can't init valentina with LiveCode
Message-ID: <5987879C-7FE6-49E4-9331-CB08F73D02BA at genericobjects.de>
Content-Type: text/plain; charset=us-ascii

Hi,

while I never seriously touched Rev or LiveCode ...

On 2012-03-08, at 22:01, Barry G. Sumpter wrote:
> and work but only for a few minutes.
> I could swear around 10 mins.  Never exactly.  
> So even with an INVALID serial number it would work for around 10 mins.
(?)

Yes, 10 Minutes was the demo mode time, everything works always for 10 Min.
even w/o a (valid) serial

regards,

Thorsten Hohage
-- 

Valentina Technology Evangelist
generic objects  GmbH - Leiter Solution Center Nord



------------------------------

Message: 6
Date: Thu, 08 Mar 2012 23:07:59 +0200
From: Ruslan Zasukhin <ruslan_zasukhin at valentina-db.com>
To: "valentina at lists.macserve.net" <valentina at lists.macserve.net>
Subject: Re: select into...
Message-ID: <CB7EEC4F.FBBCA%ruslan_zasukhin at valentina-db.com>
Content-Type: text/plain;	charset="US-ASCII"

On 3/5/12 5:25 PM, "George Parkinson" <george at microtherapy.ca> wrote:

Hi George,

> hello,
> any plans to support 'SELECT INTO'?

I think we have this syntax or its analog ..

Checking wiki ...

http://www.valentina-db.com/dokuwiki/doku.php?id=valentina:vcomponents:vsql:
reference:sqlgrammar:5.0#queries

table_definition
    :    CREATE [OR REPLACE] [ {GLOBAL | LOCAL} TEMPORARY] {[RAM] |
[SYSTEM]}
         TABLE [IF NOT EXISTS] table_name
         { table_element_list [ON COMMIT {DELETE | PRESERVE} ROWS ]
         | AS direct_select_statement_multiple_rows
         } 


So you can do 
    CREATE  [RAM TEMPORARY] TABLE  zzz
    as SELECT ... 




-- 
Best regards,

Ruslan Zasukhin
VP Engineering and New Technology
Paradigma Software, Inc

Valentina - Joining Worlds of Information
http://www.paradigmasoft.com

[I feel the need: the need for speed]




------------------------------

Message: 7
Date: Thu, 08 Mar 2012 23:13:35 +0200
From: Ruslan Zasukhin <ruslan_zasukhin at valentina-db.com>
To: "valentina at lists.macserve.net" <valentina at lists.macserve.net>
Subject: Re: select into...  And Valentina.CopyCursorToNewTable()
Message-ID: <CB7EED9F.FBBCE%ruslan_zasukhin at valentina-db.com>
Content-Type: text/plain;	charset="US-ASCII"

On 3/5/12 5:25 PM, "George Parkinson" <george at microtherapy.ca> wrote:

> hello,
> any plans to support 'SELECT INTO'?
> thanks,

Also you may find useful this feature

[NEW][API] Valentina.CopyCursorToNewTable()
   http://www.valentina-db.com/blog/?p=430


<http://www.valentina-db.com/dokuwiki/doku.php?id=valentina:products:adk:api
:valentina_class:cursormethods#valentina.copycursortonewtable>


-- 
Best regards,

Ruslan Zasukhin
VP Engineering and New Technology
Paradigma Software, Inc

Valentina - Joining Worlds of Information
http://www.paradigmasoft.com

[I feel the need: the need for speed]




------------------------------

_______________________________________________
Valentina mailing list
Valentina at lists.macserve.net
http://lists.macserve.net/mailman/listinfo/valentina


End of Valentina Digest, Vol 111, Issue 9
*****************************************



More information about the Valentina mailing list