| problem with idl database [message #53787] |
Fri, 27 April 2007 19:55  |
stin.wang
Messages: 15
Registered: April 2006
|
Junior Member |
|
|
hi everyone, i have some problem with idl dababase
i am working on some meteorological data which store in a mssql
server.
so i use idldabase connect the database, then use idldbrecordset to
get desired table.
but something happen. because in my original table ,some record name
is in chinese. when i process this data , it say something like that
"
OBJ_NEW: Illegal tag name: 区站号.
Execution halted at: DRAW_DENGWEN 19 F:\源码\IDL\draw_dengwen.pro
$MAIN$
"
it seem like that the record name must be english. can anyone help my
exlain this? or find a way to solve this problem?
|
|
|
|
| Re: problem with idl database [message #53959 is a reply to message #53787] |
Thu, 10 May 2007 15:49  |
Rick Towler
Messages: 821
Registered: August 1998
|
Senior Member |
|
|
> Can you tell me more detail about View?? I never use it before. i
> fill happy if you can give me some examples.
No, but a lot of other people can. Try this for starters:
http://odetocode.com/Articles/299.aspx
You'll need to use the "AS" clause in your SELECT to rename your
columns. Something like:
CREATE OR REPLACE VIEW myIDLDataminerTable AS
SELECT
columnOne AS colOne,
funkyName AS notFunkyName,
columnThree AS colThree
FROM myFunkyTable;
You will need privileges on the database to create a view so you may
have to ask your DBA to do this. Once created, anyone with select
privileges will be able to query it.
-Rick
|
|
|
|
| Re: problem with idl database [message #53967 is a reply to message #53787] |
Thu, 10 May 2007 02:48 |
stin.wang
Messages: 15
Registered: April 2006
|
Junior Member |
|
|
On May 10, 8:14 am, Rick Towler <rick.tow...@nomail.noaa.gov> wrote:
> stin.w...@gmail.com wrote:
>
> > Because the table is so big,(about ten millions datas),i think copy
> > all table is not my option. But thank all of your advice.so i use
> > vb.net to read database, and idl to draw picture.
>
> Well, you still can create a view. It will *not* be a copy of the data.
> Views are usually created to take existing data and present it in a
> different format. Exactly what you need to do. The view itself is just
> some sql code and the output from a query against a view is generated on
> the fly.
>
> If you want to do everything in IDL, this would be the easiest approach.
> Creating a view would just take a few minutes.
>
> -Rick
>
>
>
>> On May 2, 1:29 am, Rick Towler <rick.tow...@nomail.noaa.gov> wrote:
>>> As CP said, Dataminer (and IDL) don't handle unicode characters very well.
>
>>> One potential workaround, if you are on windows, is to use ADO+COM. But
>>> due to (what I think are) limitations in IDL's IDLcomIDispatch object
>>> you will only be able to return a single data type at a time. So if
>>> your queries return columns of type char, date, and number then it will
>>> not work efficiently. But if your queries return columns of all number
>>> or date or char types then it is an option.
>
>>> Or, probably better yet, just create a view that replicates your table
>>> and whose column titles are in roman characters.
>
>>> -Rick
>
>>> stin.w...@gmail.com wrote:
>>>> hi everyone, i have some problem with idl dababase
>>>> i am working on some meteorological data which store in a mssql
>>>> server.
>>>> so i use idldabase connect the database, then use idldbrecordset to
>>>> get desired table.
>>>> but something happen. because in my original table ,some record name
>>>> is in chinese. when i process this data , it say something like that
>>>> "
>>>> OBJ_NEW: Illegal tag name: 区站号.
>>>> Execution halted at: DRAW_DENGWEN 19 F:\源码\IDL\draw_dengwen.pro
>>>> $MAIN$
>>>> "
>>>> it seem like that the record name must be english. can anyone help my
>>>> exlain this? or find a way to solve this problem?- Hide quoted text -- Hide quoted text -
>
> - Show quoted text -
Can you tell me more detail about View?? I never use it before. i
fill happy if you can give me some examples.
|
|
|
|
comp.lang.idl-pvwave archive
Members
Search
Help
Login
Home
