microsoft.public.axapta.programming

José M. Guisado

11/2/2005 11:19:00 AM

I do not know if this can be made directly from X++. If not, try to
establish an ODBC connection and create a direct SQL query instead. Take a
look at class ODBCConnection.

Hope this helps,

Regards,

Jose

"anonymous" <anonymous@discussions.microsoft.com> escribi&#243; en el mensaje
news:3012BE8F-70AB-44CB-A175-F12979F56731@microsoft.com...
> Can someone please supply code example illerstration how one can access
> oracle''s user_tab_columns table from X++
>
> Example;
> str[100] table_names = (select column_name form
> user_tab_columns).column_name;
>
> The following works for Axapta tables;
> int numOfRecs = (select count(RecId) from SalesTable).RecId;
>