Issue 25621 - Format lost in Sybase ODBC query
Summary: Format lost in Sybase ODBC query
Status: CONFIRMED
Alias: None
Product: Base
Classification: Application
Component: code (show other issues)
Version: OOo 1.1.1b
Hardware: PC Windows NT
: P4 Trivial (vote)
Target Milestone: ---
Assignee: AOO issues mailing list
QA Contact:
URL:
Keywords:
Depends on:
Blocks:
 
Reported: 2004-02-17 18:38 UTC by mmellinger66
Modified: 2013-08-07 15:45 UTC (History)
1 user (show)

See Also:
Issue Type: DEFECT
Latest Confirmation in: ---
Developer Difficulty: ---

Attachments
Add an attachment (proposed patch, testcase, etc.)

Note You need to log in before you can comment on or make changes to this issue.
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 
mine
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