Here is my updategram:
<?xml version="1.0" ?>
<root xmlns:updg="urn:schemas-mi
<updg:sync>
<updg:before>
<msj_currency_v2 currencyID="1" currencyName="US dollar" currencySymbol="s" currencyStatus="1" />
</updg:before>
<updg:after>
<msj_currency_v2 currencyID="1" currencyName="US dollar" currencySymbol="$" currencyStatus="1" />
</updg:after>
</updg:sync>
</root>
I am posting it into the following MSSQL table:
currencyID int 4
currencyName varchar 100
currencySymbol varchar 3
currencyStatus int 4
The updategram errors when currencySymbol="$".
The error via VB updategram test app:
"disallowed implicit conversion from datatype money to datatype varchar .. use the convert function
to run this query."
How do i run the "convert function" inside an updategram???? Or is a schema required .. if so can you please provide.
The problem is posting a "$" into a varchar field via an updategram ... MSSQL tries to convert it to
datatype money and errors.
If i post "A$" or "$u" the updategram works fine.
Thanks
This Question has been solved and asker verified All Experts Exchange premium technology solutions are available to subscription members.
Experts Exchange has been collecting answers to technology questions since 1996…3 million and counting! If you have a question, chances are we already have your answer.
If you can't find the exact answer you're looking for, ask our exclusive community of 50,000 experts. You’ll get a personalized answer from a trusted professional.
Thousands of free tech tips, tricks, how-to’s and tutorials are available in our peer reviewed articles section. See for yourself how smart our experts are, no login required.
Save solutions to your questions, answers you’ve discovered through searching plus helpful articles in your personal knowledgebase for easy future access.
Access the answers to your technology questions today.
30-day free trial. Register in 60 seconds.
Members of the expert community talk about why the experience at Experts Exchange is different than what you will find anywhere else.
Try it out and discover for yourself.
30-day free trial. Register in 60 seconds.
Join the community of experts here and help other tech pros by answering question in your area of expertise. You can earn FREE access to all Experts Exchange's premium features and resources.
You could also use the more sophisticated instead of trigger here:
Create Trigger trDollarSign ON CurencyTable Instead of Insert, Update AS
Insert Into CurrencyTable
Select * from Inserted
WHERE I.CurrencySymbol <> '~$'
Insert Into CurrencyTable
(currencyID, currencyName, currencysymbol, currencyStatus)
Select currencyID, currencyName, Char(36), currencyStatus
from Inserted
WHERE I.I.CurrencySymbol = '~$'
go
Sorry once again that won't work. Try this one:
Create Trigger trDollarSign ON CurencyTable Instead of Insert, Update AS
Insert Into CurrencyTable
Select * from Inserted I
WHERE CurrencySymbol <> '~$'
Insert Into CurrencyTable
(currencyID, currencyName, currencysymbol, currencyStatus)
Select currencyID, currencyName, Char(36), currencyStatus
from Inserted
WHERE CurrencySymbol = '~$'
go
greenrc:
This old question needs to be finalized -- accept an answer, split points, or get a refund. For information on your options, please click here-> http:/help/closing.jsp#1
EXPERTS:
Post your closing recommendations! No comment means you don't care.
Business Accounts
Answer for Membership
by: spcmnspffPosted on 2002-05-21 at 12:09:06ID: 7025116
The best way I see to handle this is with a trigger.
Inside your updategram insert this for the '~$' dollar sign. (This may take a vb line or two to concatenate the tilda if the symble = "$".) Now create a trigger on your table like this:
Create Trigger trDollarSign ON CurencyTable Insert, Update AS
Update CT
Set CurrencySymbol = Char(36)
From CurrencyTable CT, Inserted I
WHERE CT.CurrencyID = I.CurrencyID
AND I.CurrencySymbol = '~$'
go