| Problem importing relational data in Express Administrator [message #92940] |
Mon, 06 May 2002 12:24  |
Enrique Vera
Messages: 2
Registered: May 2002
|
Junior Member |
|
|
|
Hello , please this is urgent, I have problems importing relational data in an express database, i have all the fields, dimensions and values in an Oracle table called SALES_MV, I configure the dimensions as text values and variables as integers, well at the moment of importing data, the loader program just gets the last values of the fields, please if anybody can help, please contact me at my email address: chuleto@hotmail.com. THANKS A LOT
|
|
|
|
| Re: Problem importing relational data in Express Administrator [message #92942 is a reply to message #92940] |
Tue, 07 May 2002 21:29  |
M Srinivasa Prasad.
Messages: 2
Registered: November 2001
|
Junior Member |
|
|
Hi,
check whether your "sql fetch" statement has a "loop into" clause. you can use "while" also with SQL fetch.
you have to loop values into variables, otherwise you will get only last values.
example: This works
sql fetch cur1 loop into -
:D1, :D2, :D3, -
:V.V1, :V.V10, :V.V2, :V.V4, :V.V5
Thanks
M Srinivasa Prasad.
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
