Subject Re: [firebird-support] problem while executing query
Author Helen Borrie
At 10:53 AM 15/09/2004 +0000, you wrote:
>I am working on a project in dotnet. and I am using firebird
>database and fbdotnetprovider1.6. I am facing a problem when
>inserting or updating the email value. What happens is the '@'
>symbol with the domain name is getting replaced with a ? mark. i.e
>the id prasanna@... is replaced with prasanna?.com. Don't know
>where the problem is. Moreover this problem is occuring when I
>execute a procedure with the input parameters as a concatenated
>string and while not passing the parameter values individually.
>eg: Execute procedure
>Procedure_name 'prasanna','kumar','prasanna@...'... if i am
>executing like this then the email value is getting replaced.
>if i am using the parameter collection object then this problem is
>not occuring .
>Can anyone tell me why this problem is occuring and where the
>problem is ?

Ask on the firebird-net-provider list (<mailto:firebird-net-provider-request@...?subject=subscribe>

The '@' symbol is not a special or reserved symbol in SQL...