Re: Referencing combo box column
- From: "Sylvain Lafontaine" <sylvain aei ca (fill the blanks, no spam please)>
- Date: Thu, 1 Mar 2007 02:44:30 -0500
No problem here with A2003 and SQL-Server 2000 or 2005.
Are you sure that you are not introducing some other syntaxe error when
adding your aliases? Did you make sure to close/reopen your ADP project so
to be sure that everything has been refreshed?
--
Sylvain Lafontaine, ing.
MVP - Technologies Virtual-PC
E-mail: sylvain aei ca (fill the blanks, no spam please)
<wingus@xxxxxxxxxxxxxxx> wrote in message
news:1172546200.743889.29020@xxxxxxxxxxxxxxxxxxxxxxxxxxxxxxx
Hi
Using A2003, SQL Server 2005.
I have a combo box on a form controlled by a sproc, very simple, just
two columns ordered by second column.
I have another text box with a reference to the second column of the
combo box as "=cbo_debtor.column(1)".
My issue is this: if I have aliases in my sproc, ie. SELECT
THISCOLUMN AS THISNAME etc. then the text box shows nothing. If I
take the aliases away, then it displays the correct information. I'm
just wanting to make the headers in the combo box a bit more
meaningful than the table column names.
Can anyone explain this or has anyone else experienced it?
Thanks
Winsa
.
- Prev by Date: Re: Data Provider Could Not Be Initialized
- Next by Date: Re: Indicating Stored Procedure progress on Form
- Previous by thread: Re: Data Provider Could Not Be Initialized
- Next by thread: Re: Indicating Stored Procedure progress on Form
- Index(es):
Relevant Pages
|
Loading
