Re: Simple decimal

If you have IDS 9.xx you can use a type cast. Otherwise and anyway the engine will automatically convert to whatever host type you declare the bound variable as. So just define that ADO recordset field corresponding to the constant as a DECIMAL and it will be a decimal. That works in ESQL/C, CLI, 4GL, DBD/DBI Perl, etc should work in ADO also. Art S. Kagel Eric Dupuis wrote: > > Is there a way to return a column of decimal datatype from a select > statement that creates the columns from scratch? I am trying to build an > ADO recordset that will allow to enter decimal values into a recordset > column without having a matching base column. > > for example: > SELECT m.long_prod_desc AS Description, 0.00 as Received FROM my_table m> > -----= Posted via Newsfeeds.Com, Uncensored Usenet News =----- > http://www.newsfeeds.com - The #1 Newsgroup Service in the World! > -----== Over 80,000 Newsgroups - 16 Different Servers! =-----