Valentina Office Server - Create Table

[Damon Pillinger]

Hi Guys,

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?

Thanks

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 Damon
Pillinger
Sent: Thursday, 9 February 2006 2:07 PM
To: 'Valentina Developers'
Subject: PHP configuration MORE++

Hooray.  Valentina only works with PHP4 not PHP5

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 Damon
Pillinger
Sent: Thursday, 9 February 2006 1:53 PM
To: 'Valentina Developers'
Subject: PHP configuration MORE+

More info

Is it possible that php_valentina.dll calls php4ts.dll?
If it is since I downloaded PHP5 maybe the dll had been renamed?


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 Damon
Pillinger
Sent: Thursday, 9 February 2006 1:50 PM
To: 'Valentina Developers'
Subject: PHP configuration MORE

Made some progress

PHP Warning: PHP Startup: Unable to load dynamic library
'C:\PHP\extensions\php_valentina.dll' - The specified module could not
be found. in Unknown on line 0

Found where to set the default directory in PHP.ini and the dll is
defiantly there but still does not work. Do I need something else other
than Valentina office server and Valentina PHP

It error on a pop up on the server as "php4ts.dll" not being found.

Thanks

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+daisychain=iinet.net.au at lists.macserve.net
[mailto:valentina-bounces+daisychain=iinet.net.au at lists.macserve.net] On
Behalf Of Damon Pillinger
Sent: Thursday, 9 February 2006 1:29 PM
To: 'Valentina Developers'
Subject: PHP configuration

Hi Guys,

OK I have set up PHP with Lite serve and the PHP works fine and I
believe it is what I want.

I have downloaded the Val PHP and following the configuration as per the
instructions but keep getting this error


VPHP Example - Connect/Disconnect

------------------------------------------------------------------------
host = 192.168.0.1:15432
username = sa
password = sa

$conn = valentina_connect( host, username, password ); => 
Fatal error: Call to undefined function valentina_connect() in
E:\Documents and Settings\damon pillinger\My Documents\My Web
Sites\DanesEdi Published\connect.php on line 28
PHP Warning: PHP Startup: Unable to load dynamic library
'./php_valentina.dll' - The specified module could not be found. in
Unknown on line 0


Obviously the dll has to be put in a folder other than C:\PHP any idea
where it is to go? I cannot see any other dll's for PHP in the C:\PHP
folder.

Using PHP version 5.1.2

thanks

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

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