Type incompatible error

[ns-moez]

Hi everyone,
i'm new on V.B. I have a little issue

V_Rate = SystemScript.GetDatabaseValue(V_SQL & "", "NVL(COLUMN A,0)", "TABLE C")
V_LoadingAmount = SystemScript.GetDatabaseValue(V_SQL & "", "NVL(COLUMN B,0)", "TABLE C")

COLUMN A and COLUMN B type's are number on table C

where i try this formula

V_Premium = (V_Valeur_Venale * V_Rate / 1000) + V_LoadingAmount

an error message is displayed Type incompatible: 'V_RATE'

can somebody advise?

[jdc2000]

What Type of variable did you define V_Rate as in your program?

[SamOscarBrown]

Are you using Excel?

Appears this belongs in the Office Forum (for things like Word/Excel/VBA (Visual Basic for Applications)).

[ns-moez]

jdc i have declared v_rate without type

[ns-moez]

no its not excel.lt s a develpment module for an application that uses vb

[DataMiser]

no its not excel.lt s a develpment module for an application that uses vb

What do you mean by application that uses VB
Either it is written in VB or is is VBA or VBScript. This section is for VB.
The message you mention does not seem like a VB message at all so am thinking you are using VBA or some flavor of it within some other application.

The Classic VB message would be Type Mismatch if the wrong type is used and Overflow if the resulting number is to large.


so V_Rate is a Variant then?
what about loading amount?

You really should determine what type you need and specify it with dimming your vars

[ns-moez]

DATAMISER
Type incompatible is the french translation of typemismatch, sorry i had to mention that. i m beginner on vb,tomorrow i will determine the type of my vars and i will check. thanks for the advice

[DEXWERX]

It's .NET