Valentina Office Server - Create Table

[Ruslan Zasukhin]

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]