|
[FONT='Times New Roman','serif']Hello.[/FONT]
[FONT='Times New Roman','serif']I have problem with ADODB.Recordset.[/FONT]
[FONT='Times New Roman','serif']I have query : [/FONT][FONT='Times New Roman','serif']DRILLTHROUGH SELECT FROM ["[/FONT][FONT='Times New Roman','serif'] + _strCube + "] WHERE (" + strWhereMDX + ")".[/FONT]
[FONT='Times New Roman','serif']Query return a Field.[/FONT]
[FONT='Times New Roman','serif']The field have Type = AdVariant and Value 21.0.[/FONT]
[FONT='Times New Roman','serif']When Add RecordSet to[/FONT][FONT='Times New Roman','serif'] AxOWC10.[/FONT][FONT='Times New Roman','serif']AxPivotTable is OK.[/FONT]
[FONT='Times New Roman','serif']When i Export Data from OWC to Excel i Excel i have a number value in string.[/FONT]
[FONT='Times New Roman','serif']I nead a type in recordset double no adVarint.[/FONT]
[FONT='Times New Roman','serif']How can i change type in recordset to double from adVarian.[/FONT]
[FONT='Times New Roman','serif']Any help please ..[/FONT]
[FONT='Times New Roman','serif']Thank [/FONT]
[FONT='Times New Roman','serif']Michal[/FONT]
|
