| Re: Finding a structure in a structure [message #28767 is a reply to message #28674] |
Tue, 08 January 2002 06:24   |
timothy.williams
Messages: 20
Registered: October 2001
|
Junior Member |
|
|
By rectifying this directly in Access, do you mean converting the
format of the
field from Date/Time to Text? I tried that, but Access reformatted the
data from the Medium Date format, which is what I had in the original
table, to the General Date. I don't want to change the format of the
data, so I guess I have to do I myself. The Access people over here
say I can't change the way Access converts Dates to Text. (I suppose
this is another example of Bill making your decisions for you.)
The size() function completely slipped my mind. Thanks!
I don't really know as much as I should about Access, (or Oracle
either for that mattter), but I'll have databases on both, so I don't
want to depend on either. It just depends on which database the user
connects to as to which tables will be available.
Pavel A. Romashkin" <pavel_romashkin@hotmail.com> wrote in message news:<3C3A155A.FBD5339F@hotmail.com>...
> I see two ways of handling this.
> First, you can rectify this directly in Access when you are working with
> the recordset (of which, rightfully, you said nothing in your post, as
> it is not dealing with IDL).
> In IDL - since you already havi the Recordset structure in it - I would
> try the following:
>
> for i = 0, n_tags(recordset)-1 do begin
> ; Convert date to Access format, to string, if field is a Structure
> if size(recordset.(i), /type) eq 8 then $
> Convert, recordset.(i) ; This is *your* conversion routine
> ; Ignore this field of Recordset if not a Structure
> else ....
> endfor
>
> Personally, I can't imagine trying to mix IDL widgets with VBA and
> Access' forms. The latter offer tremendously more flexibility with
> regard to database analyses.
> hope this helps,
> Pavel
>
> Tim Williams wrote:
>>
>> I have an application that is using Dataminer to access a database,
>> one of the functions being to display the tables in the database. So
>> far, my database has been Oracle on a Sun, where my IDL on a PC. I'm
>> now migrating over some of the tables to Access on the PC. I now have
>> a problem because one of my fields has a date in it which was a STRING
>> before, but in the Access database is the structure
>> ODBC_SQL_TIMESTAMP. I'm getting an error that structures can't contain
>> other structures.
>>
>> My plan now is to write code to convert this structure to a string so
>> I can put the date in the table widget structure.
>>
>> How? I can do a tag_names(recordset, /structure_name) and test for
>> 'ODBC_SQL_TIMESTAMP', but I'm not sure how to search through each
>> member in the database recordset structure. I don't know how to handle
>> the errors I will have when I call tag_names() with the members that
>> aren't structures.
>>
>> Thanks for any help.
|
|
|
|
comp.lang.idl-pvwave archive
Members
Search
Help
Login
Home
