Issue 25621

Summary: Format lost in Sybase ODBC query
Product: Base Reporter: mmellinger66 <mmellinger66>
Component: codeAssignee: AOO issues mailing list <issues>
Status: CONFIRMED --- QA Contact:
Severity: Trivial    
Priority: P4 CC: issues
Version: OOo 1.1.1b   
Target Milestone: ---   
Hardware: PC   
OS: Windows NT   
Issue Type: DEFECT Latest Confirmation in: ---
Developer Difficulty: ---

Description mmellinger66 2004-02-17 18:38:13 UTC
I have a simple query that tries to get the current date/time from Sybase.  The
result is returned as a number.  I change the format to a date format then save
the spreadsheet.  When I open the spreadsheet again and click on my query, the
value is once again returned as a number.

select getdate(), "It doesn't get any easier than this."

I'm using my PC ODBC sources to connect to Sybase.
Comment 1 christoph.lukasiak 2004-03-08 13:30:48 UTC
Comment 2 christoph.lukasiak 2004-03-08 15:34:49 UTC
CLU->OJ: i can repro that

1. create a sybase odbc data source with a query like: select getdate()
2. open query in database beamer and change format (in f.e. date - from context)
3. open another table and than the query again
=> format lost
Comment 3 christoph.lukasiak 2004-05-17 14:45:19 UTC
CLU: as i agreed with OJ, lower prio and target, because it works fine if you
insert a table name in the sql string like: SELECT getdate( ) FROM
"testuser"."Table1" "Table1" - so it 'only' make problems in native mode, that
in this case is not supported fully