Win rb2005r4 Val 2.2 API set/read a VField I found a bug

[Damon Pillinger]

Further to previous email

db=new VDatabase("192.168.0.1","sa","sa")

returns fields of any length



vs=new VServer("192.168.0.1","sa","sa")
vs.OpenSession
dbs=new VDatabase(vs)

only returns the first character of fields.

:(

This is the only difference in the two codes I used to check.


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: Damon Pillinger [mailto:daisychain at iinet.net.au] 
Sent: Friday, 24 February 2006 9:03 AM
To: 'Valentina Developers'
Subject: Win rb2005r4 Val 2.2 API set/read a VField

Hi Guys

Anyone awake?

Am using this to populate a VField (yes doing it the API way) of type
String(40)  call vt.CreateStringField("age",40,EVFlag.fNullable)

	vt.Field("age").Value="32"      
      call vt.AddRecord()

but when I recall it I only get "3"

  s="Select * from Person"
  vr=db.SqlSelect(s)
  
    for i= 1 to vr.RecordCount
      vr.Position=i
      s=vr.Field("age").GetString
      ListBox4.AddRow s
    next
  

Am I setting the value incorrectly or reading it incorrectly?

Also this is the fastest way (the API way) for Valentina isn't it?

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