Has anyone ever had an issue with using dates stored as I-Descriptors in UniOLEDB? I am updating a script using UniOLEDB and having trouble.
Dates stored as D are fine and dates stored as I-descriptors are fine until I use them in a query's WHERE clause. For example, I have an ID field that is concatenated and the I-Descriptor SHIP_DATE is simply FIELD(@ID,'~',3). I can SELECT SHIP_DATE fine but if I do WHERE SHIP_DATE = '1/21/2010' I get zero records even though SELECT SHIP_DATE shows 6 records that have and return 1/21/2010 as the SHIP_DATE. The data is stored as 15362 in the concatenated @ID field and returns 1/21/2010 in selecting the SHIP_DATE I-Descriptor which has a conversion D4/ on it. Am I missing something to use this in UniOLEDB? Thanks, Andrew ............................................... Andrew E. Tegenkamp Director, Systems Integration G3 Systems, Inc. P:540.951.4300 F:540.951.4311 http://www.g3.com _______________________________________________ U2-Users mailing list [email protected] http://listserver.u2ug.org/mailman/listinfo/u2-users
