[FAQ] A couple of questions

[Ruslan Zasukhin]

On 4/19/06 5:06 AM, "Anna Kritselis" <akritselis at earthlink.net> wrote:

Hi Anna,

> Hi Ruslan,
> 
> I have a couple of questions for you - (WIN XP, RB2006r1, V4RB 2.3)

1)
 
> Is it possible to set a field equal to the value of another field in the same
> record?
> Update tblEvalGrad set tblEvalGrad.GradeTerm2 = tblEvalGrad.GradeTerm1

In SQL? 

Yes. You can use even expressions:

Update tblEvalGrad SET tblEvalGrad.GradeTerm2 = tblEvalGrad.GradeTerm1 + 25


-----
2)
 
> Also, do you use both the Vexception(Valentina) and Exception(RealBasic)
> blocks?  

Yes, VException class is subclass of RuntimeException.

> Should one come before the other?

> Exception err as VException
>   MsgBox Str(err.ErrorNumber) + ":" + err.Message
> 
> Exception err
>    MsgBox "Error!"

YES!

This is correct code even we'd not subclass RuntimeException.
The fact that we do subclass means that you can write just

 Exception err
    MsgBox "Error!"

And still catch Valentina exceptions. But if you want DIFFER in code
Valentina exceptions from OTHER exceptions then you can write 2 catches as
you do above.


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