Need help with CONVERT (text to VARCHAR)

[Shfog]

The code below gives me an error message:
"Implicit conversion from datatype 'text' to 'varchar' is not allowed. Use CONVERT function to run this query"
Where and how do I use the convert or cast function?
In the VB Program? In the Stored Procedure? Where?
Thanks for any help.
----------------------------------
VB: Something like this,
myParm(0) = txtName.TEXT
myParm(1) = txtAddress.TEXT
myParm(2) = txtCity.TEXT
cmdmySQL.Execute , myParm
----------------------------------
Stored Procedure
CREATE PROC new_order
DECLARE @Name VARCHAR(50)
@Address VARCHAR(50)
@City VARCHAR(30)
AS INSERT card_orders(
Name, Address, City)
VALUES(
@Name, @Address, @City)
----------------------------------

 

[TomasDill]

The error probably happens when you call the SP. When you;re not sure about field type of data you pass to the SP, use following (example):
exec new_order convert(varchar(50),left(NameValue,50)), convert(varchar(50),left(AddressValue,50)), convert(varchar(30),left(CityValue,30))
Hope this helps. Vlad Grynchyshyn, MVP
vgryn@softserve.lviv.ua

http://www.softservecom.com

The professional level of programmer could be determined by level of stupidity of his/her bugs

 

[moonshadow]

What's the datatypes of the fields in the table? As it looks like you're using ADO, do you need to explicitly declare that the parameters are varchars - is your VB code defaulting them to SQL TEXT fields ? SQL would then complain that it can't change them from text to varchar.

 

[Shfog]

It looks like blank text fields in the VB are part of the problem. If all boxes have text, I don't get an error.
Is there a way to send the empty string as NULL in VB?
Or should I adjust my stored procedure? And how?

Thanks
steve@accucopy.com