facing errors

Question

0.00/5 (No votes)

See more:

Hi,

I'm storing the control location value in my database.
I am using object variable to store location of the controls but I'm facing some errors.

Operator '&' is not defined for string "IUD_dramdtls 0,'ad','2010/11/03'" and type 'Point'.

My coding is

VB

Query = "IUD_dramdtls " & clvdramakey & ",'" & clvdramname & "','" & clvdatefrom & "','" & clvdrdateto & "'," & clvdescprtn & ",'" & clvoprstamp & _
                         "'," & clvlogusrid & ",'" & IUTYPE & "'"

here ,'" & clvdescprtn & "', is my object variable through that variable I am passing contol location value.

Please solve this issue.

Posted 2-Nov-10 22:09pm

sameertm

Updated 2-Nov-10 22:44pm

Dalek Dave

v2

Add a Solution

Comments

Sunasara Imdadhusen 3-Nov-10 4:35am

Not clear!

Dalek Dave 3-Nov-10 4:44am

Edited for Grammar and Syntax.

1 solution

Add a Solution

Add your solution here

Treat my content as plain text, not as HTML

Preview 0

…

Existing Members

Sign in to your account

...or Join us

Download, Vote, Comment, Publish.

Your Email
Password
Forgot your password?

Your Email
This email is in use. Do you need your password?
Optional Password

I have read and agree to the Terms of Service and Privacy Policy
Please subscribe me to the CodeProject newsletters

When answering a question please:

Read the question carefully.
Understand that English isn't everyone's first language so be lenient of bad spelling and grammar.
If a question is poorly phrased then either ask for clarification, ignore it, or edit the question and fix the problem. Insults are not welcome.
Don't tell someone to read the manual. Chances are they have and don't get it. Provide an answer or move on to the next question.

Let's work to help developers, not make them feel stupid.

This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)

Arindam Tewary · Answer 1 · 2010-11-02T23:08:00

Solution 1

Hi,

Going by the error message, I guess you are concatenating (adding) string variables and at least one "Point" type variable.

Just check type of each variable type that you are trying to concatenate(add)in your code.

Hope it helps,

Thanks
Arindam D Tewary,

Posted 2-Nov-10 23:08pm

Arindam Tewary

Comments

sameertm 3-Nov-10 5:29am

iam not concatenating any variable jus iam passing values to sql,, but its showing error,commonly how object value will pass to sql from vb.net.

Arindam Tewary 3-Nov-10 5:38am

The line you have showed here is actually adding(concetanting) couple of String variables and you are and assigning to "Query". I suspect the variable "clvdrdateto". Please check the type of variable "clvdrdateto".
Going by your post I see that starting "IUD_dramdtls", upto 3 variable were added correctly but the 4th variale was not added properly. Now this 4 th variable is "clvdrdateto". Please check.