Printable View
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?
What Type of variable did you define V_Rate as in your program?
Are you using Excel?
Appears this belongs in the Office Forum (for things like Word/Excel/VBA (Visual Basic for Applications)).
jdc i have declared v_rate without type
no its not excel.lt s a develpment module for an application that uses vb
What do you mean by application that uses VBQuote:
Originally Posted by ns-moez
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
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
It's .NET