Valentina Office Server - Create Table

[Damon Pillinger]

Morning Gentlemen,

Sorry Ruslan, I usually put the version.

I am using RB2005r4 (and have tested on RB5.5.5)

Valentina for RB 2.0.5 (result from valentina.version) but I am sure it
is at least 2.2

VOS 2.1

I will try VOS 2.2 now.

Best regards

Damon L. Pillinger
Director Daisychain EDi
Suite 3
4 Winston Court
Moorabbin 3189
Phone : +61 3 9532 1220
Fax : +61 3 9532 1280


-----Original Message-----
From: valentina-bounces at lists.macserve.net
[mailto:valentina-bounces at lists.macserve.net] On Behalf Of Ruslan
Zasukhin
Sent: Thursday, 9 February 2006 7:39 PM
To: valentina at lists.macserve.net; Ivan Smahin
Subject: Re: Valentina Office Server - Create Table

On 2/9/06 7:34 AM, "Damon Pillinger" <daisychain at iinet.net.au> wrote:

> Hi Guys,

Damon, please specify always platforms and versions.
 
I know that this is windows.
Is it 2.1 or 2.2 betas?

> This works
>   f=GetFolderItem("damontest17.vdb")
>   da =new VDatabase( "192.168.0.1", "sa", "sa"  )
>   da.Create(f)
>   
>   call da.SqlExecute ("Create table Client (  cCustomer Varchar(6) ,
> cDate Varchar(30) ,  cDion Varchar(4) ,  cCed Varchar(11)   ) " )
>     
>   tblPerson  = da.SqlSelect( "SELECT * FROM Client WHERE FALSE ",
> EVCursorLocation.kServerSide, EVLockType.kNoLocks,
> EVCursorDirection.kRandom )



> This crashes RB5.5.5 ..
> 
>   f=GetFolderItem("damontest18.vdb")
>   da =new VDatabase( "192.168.0.1", "sa", "sa"  )
>   da.Create(f)
> 
>   call da.SqlExecute ("Create table Client (  cCustomer Varchar(6) ,
> cDate Varchar(30) ,  cDion Integer ,  cCed Varchar(11)   ) " )
>   
>   tblPerson  = da.SqlSelect( "SELECT * FROM Client WHERE FALSE ",
> EVCursorLocation.kServerSide, EVLockType.kNoLocks,
> EVCursorDirection.kRandom
> 
> ..when it gets to the select statement.
 
> The only thing that changes is the cDuration changes from Varchar to
> Integer. Can we not mix type in VOS?

You can mix types of course.

Something wrong...

can you send us your test project?
CC please to Ivan it. See above address.

Ivan, meanwhile try this code self using new project with one button.


Btw, Damon, for final do not forget to change "sa","sa" passwords.


-- 
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