|
Home > Archive > SQL Anywhere database > December 2005 > adoquery progrom!
You are viewing an archived Text-only version of the thread.
To view this thread in it's original format and/or if you want to reply to
this thread please [click here]
|
|
| lsllsf 2005-12-31, 3:23 am |
| i use delphi + ado
mysql:='insert into mailstate (stateid,statecode,s
tatename) values
(:stateid,:statecode
,:statename)';
myquery.Parameters. ParamByName('stateid
').Value :=6;
myquery.Parameters. ParamByName('stateco
de').Value :=Amessage.From.Text;
myquery.Parameters. ParamByName('statena
me').Value :='aaaa';
statecode and statename is varchar type
but i run progrom ,statecode is 'l' is not 'lsllsf@tom.com' statename value
is 'a' is not 'aaaa' why? thanks
| |
| Greg Fenton 2005-12-31, 11:23 am |
| lsllsf wrote:
> i use delphi + ado
>
> mysql:='insert into mailstate (stateid,statecode,s
tatename) values
> (:stateid,:statecode
,:statename)';
> myquery.Parameters. ParamByName('stateid
').Value :=6;
> myquery.Parameters. ParamByName('stateco
de').Value :=Amessage.From.Text;
> myquery.Parameters. ParamByName('statena
me').Value :='aaaa';
>
Please always post the version and build number of SQLAnywhere that you
are using (e.g. use the command "dbeng9 -v" for SQLAnywhere 9.x)
I don't know Delphi at all, but why do you use "mysql" in the first
line, but "myquery" in the other three?
greg.fenton
--
Greg Fenton
Consultant, Solution Services, iAnywhere Solutions
--------
Visit the iAnywhere Solutions Developer Community
Whitepapers, TechDocs, Downloads
http://www.ianywhere.com/developer/
|
|
|
|
|