Contactanation error

shoakat · October 19th, 2004, 04:12 PM

i am trying to concanate this code. Can you help me in this?
strUpdate = "update tblCustRate set dtRateFrom =" &ndateFrom&
"dtRateTo = " &ndateUntil&
"decHourlyRate=" &nHourlyRate
this code gives me an error. Thanks

happygv · October 19th, 2004, 05:06 PM

Is this the same as that of your other post?

Can you post here the error that you see? Also the datatypes of the columns in your database

_________________________
- Vijay G
Strive for Perfection

shoakat · October 19th, 2004, 08:09 PM

The error it shows are syntax error. The data types
are 50 and 19/18/2004

sureshbabu · October 20th, 2004, 03:01 AM

Hi,
    Following code will help u.

strUpdate = "update tblCustRate set dtRateFrom ='" &ndateFrom &
              "' and dtRateTo = '" &ndateUntil & "' and "
                decHourlyRate='" & nHourlyRate & "'"

Thanks
Suresh

happygv · October 20th, 2004, 09:05 AM

Hi Shoakat,

Quote:

quote:The data types are 50 and 19/18/2004

I don't see any datatype from your post or no mention about which varibale contains what...

Assuming things on my own, this might help you.

Code:

strUpdate = "update tblCustRate set dtRateFrom ='" & ndateFrom & "', dtRateTo = '"  & _ 
    ndateUntil & "', decHourlyRate=" & nHourlyRate

Suresh,
AND shouldn't be used with the SET clause, instead COMMAs are used as delimiter between different COLUMNs and its values. AND is used only with WHERE CLAUSE for specifying Multiple expressions.

_________________________
- Vijay G
Strive for Perfection