| Re: problem with idl database [message #53972 is a reply to message #53935] |
Wed, 09 May 2007 17:14  |
Rick Towler
Messages: 821
Registered: August 1998
|
Senior Member |
|
|
stin.wang@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 -
|
|
|
|
comp.lang.idl-pvwave archive
Members
Search
Help
Login
Home
