V4RB Unexpected Quit

[alvin]

Hi Ruslan,

I've finally managed to get on to an OS X Server machine and check where the
program was going wrong. I've narrowed it down to:

vFld = 
mDatabase.BaseObject("Students").CreateField("Zoning",kV_TypeString,2,-1,"If
(TO_DAYS(Start_Date)<TO_DAYS('01/01/2002'),'NA',In_Zone)")

The above line works fine on OS 9. The field is created with no problems. On
OS X the program quits as soon as it sees this line. A similar line but
using KV_TypeShort instead of KV_TypeString works fine:

vFld = 
mDatabase.BaseObject("Students").CreateField("MType",kV_TypeShort,0,-1,"If(S
tudent_Type=7 AND bAttendance=1,1,If(Student_Type=3 AND
bAttendance=1,1,If(Student_Type=7 AND bAttendance=0,2,If(Student_Type=3 AND
bAttendance=0,2,If(Student_Type=5 AND bAttendance=1,3,If(Student_Type=6 AND
bAttendance=1,3,If(Student_Type=5 AND bAttendance=0,4,If(Student_Type=6 AND
bAttendance=0,4,If(Student_Type=4,6,If(Student_Type=2,7,If(Student_Type=1,8,
0)))))))))))")

It appears that all my createfield lines where I am creating string fields
do not work, yet the others work fine. This would seem to me to be a
Valentina bug. I was using OS X.2.3 and the latest Valentina final.

All the best.

Cindy

> From: Ruslan Zasukhin <sunshine at public.kherson.ua>
> Reply-To: Valentina Developers <valentina at lists.macserve.net>
> Date: Mon, 17 Feb 2003 13:46:30 +0200
> To: <valentina at lists.macserve.net>
> Subject: Re: V4RB Unexpected Quit
> 
> on 2/17/03 12:28 PM, alvin at alvin at ins.co.nz wrote:
> 
> Hi Alvin,
> 
>> I checked it out and removed a character from the original database. Then
>> did another XML dump and found another one. The offending line says:
>> 
>> <f n="cdocid">rvtwgq~ü8!</f>
>> 
>> There is actually nothing wrong with this but it appears the rectangel
>> between the w and the g is what is causing the error. I could be wrong, but
>> I would have thought that shouldn't cause problems.
>> 
>> In any case, there doesn't seem to be anything wrong with the record itself
>> as it is not that record that is causing the server program to quit. Is
>> there anything that can cause Realbasic to quit without even touching an
>> exception error when updating a record?
> 
> No ideas. 
> 
> Try to set debug level and what what was last Valentina call.
> May be you will see some errors.
> 
>> I've exported the whole database
>> where the offending records are and reimported it with no problems so it
>> doesn't look like there is any problem with the data itself. All the program
>> does is read the data, load the appropriate database record, set the fields
>> with the new data and then update the record. It is when it is updating the
>> record that the server program quits and I cannot catch any errors to see
>> why.
>> 
>> Any suggestions would be really appreciated.
> 
> -- 
> Best regards,
> Ruslan Zasukhin      [ I feel the need...the need for speed ]
> -------------------------------------------------------------
> e-mail: ruslan at paradigmasoft.com
> web: http://www.paradigmasoft.com
> 
> To subscribe to the Valentina mail list go to:
> http://listserv.macserve.net/mailman/listinfo/valentina
> -------------------------------------------------------------
> 
> _______________________________________________
> Valentina mailing list
> Valentina at lists.macserve.net
> http://lists.macserve.net/mailman/listinfo/valentina
>