[dba-issues] [Issue 104267] Default values were not s aved

2009-08-19 Thread msc
To comment on the following update, log in, then open the issue:
http://www.openoffice.org/issues/show_bug.cgi?id=104267


User msc changed the following:

What|Old value |New value

 Assigned to|dbaneedsconfirm   |oj

  Ever confirmed|  |1

  Status|UNCONFIRMED   |NEW

Keywords|needmoreinfo  |

  OS/Version|Windows Vista |All

Platform|Unknown   |All

Target milestone|---   |OOo 3.x





--- Additional comments from m...@openoffice.org Wed Aug 19 06:33:18 + 
2009 ---
I can reproduce this with the database from issue 104266.

-
Please do not reply to this automatically generated notification from
Issue Tracker. Please log onto the website and enter your comments.
http://qa.openoffice.org/issue_handling/project_issues.html#notification

-
To unsubscribe, e-mail: issues-unsubscr...@dba.openoffice.org
For additional commands, e-mail: issues-h...@dba.openoffice.org



[dba-issues] [Issue 104266] Column descriptions were not saved

2009-08-19 Thread msc
To comment on the following update, log in, then open the issue:
http://www.openoffice.org/issues/show_bug.cgi?id=104266





--- Additional comments from m...@openoffice.org Wed Aug 19 06:39:14 + 
2009 ---
*** Issue 104267 has been marked as a duplicate of this issue. ***

-
Please do not reply to this automatically generated notification from
Issue Tracker. Please log onto the website and enter your comments.
http://qa.openoffice.org/issue_handling/project_issues.html#notification

-
To unsubscribe, e-mail: issues-unsubscr...@dba.openoffice.org
For additional commands, e-mail: issues-h...@dba.openoffice.org



[dba-issues] [Issue 104267] Default values were not s aved

2009-08-19 Thread msc
To comment on the following update, log in, then open the issue:
http://www.openoffice.org/issues/show_bug.cgi?id=104267


User msc changed the following:

What|Old value |New value

  Status|NEW   |RESOLVED

  Resolution|  |DUPLICATE





--- Additional comments from m...@openoffice.org Wed Aug 19 06:39:15 + 
2009 ---
This issue has the same root cause as issue 104266. Also formats set on a field
will not save.
So I set this issue as a duplicate to issue 104266.

Bye Marc

*** This issue has been marked as a duplicate of 104266 ***

-
Please do not reply to this automatically generated notification from
Issue Tracker. Please log onto the website and enter your comments.
http://qa.openoffice.org/issue_handling/project_issues.html#notification

-
To unsubscribe, e-mail: issues-unsubscr...@dba.openoffice.org
For additional commands, e-mail: issues-h...@dba.openoffice.org



[dba-issues] [Issue 104267] Default values were not s aved

2009-08-19 Thread msc
To comment on the following update, log in, then open the issue:
http://www.openoffice.org/issues/show_bug.cgi?id=104267


User msc changed the following:

What|Old value |New value

  Status|RESOLVED  |CLOSED





--- Additional comments from m...@openoffice.org Wed Aug 19 07:04:22 + 
2009 ---
close

-
Please do not reply to this automatically generated notification from
Issue Tracker. Please log onto the website and enter your comments.
http://qa.openoffice.org/issue_handling/project_issues.html#notification

-
To unsubscribe, e-mail: issues-unsubscr...@dba.openoffice.org
For additional commands, e-mail: issues-h...@dba.openoffice.org



[dba-issues] [Issue 104329] dbaccess: better way to d etect/describe supporting primary keys

2009-08-19 Thread cmc
To comment on the following update, log in, then open the issue:
http://www.openoffice.org/issues/show_bug.cgi?id=104329
 Issue #|104329
 Summary|dbaccess: better way to detect/describe supporting pri
|mary keys
   Component|Database access
 Version|DEV300m55
Platform|All
 URL|
  OS/Version|Linux
  Status|NEW
   Status whiteboard|
Keywords|
  Resolution|
  Issue type|PATCH
Priority|P3
Subcomponent|none
 Assigned to|fs
 Reported by|cmc





--- Additional comments from c...@openoffice.org Wed Aug 19 08:16:53 + 
2009 ---
As mentioned at http://dba.openoffice.org/servlets/ReadMsg?list=devmsgNo=4010 
the postgresql jdbc driver reports false for supportsCoreSQLGrammar, e.g.

import java.sql.DriverManager;
import java.sql.Connection;
import java.sql.DatabaseMetaData;
import javax.naming.*;
import javax.sql.*;

public class demo {
 public static void main(String[] args) {
  try {
   System.out.println(jdbc url:  + args[0]);
   Connection con = DriverManager.getConnection(args[0], args[1], args[2]);
   DatabaseMetaData md = con.getMetaData();
   System.out.println(supportsCoreSQLGrammar -  + 
md.supportsCoreSQLGrammar());
   System.out.println(supportsMinimumSQLGrammar-  +
md.supportsMinimumSQLGrammar());
   System.out.println(supportsANSI92EntryLevelSQL -  +
md.supportsANSI92EntryLevelSQL());
   System.out.println(supportsANSI92FullSQL -  + md.supportsANSI92FullSQL());
  } catch (Exception e) {
   System.err.println(e.getMessage());
  } 
 }
}

says false for supportsCoreSQLGrammar and true for everything else. Due to this
OOo treats it as not supporting primary keys, which causes some problems, e.g. 
https://bugzilla.redhat.com/show_bug.cgi?id=514683 and issue 92348. This driver
does of course support primary keys, so ideally we should have a better way to
detect or describe that a driver supports primary keys.

Attached is a quick-and-dirty hack to illustrate where supportsCoreSQLGrammar
is being used to check for primary key support at the moment

-
Please do not reply to this automatically generated notification from
Issue Tracker. Please log onto the website and enter your comments.
http://qa.openoffice.org/issue_handling/project_issues.html#notification

-
To unsubscribe, e-mail: issues-unsubscr...@dba.openoffice.org
For additional commands, e-mail: issues-h...@dba.openoffice.org



[dba-issues] [Issue 104329] dbaccess: better way to d etect/describe supporting primary keys

2009-08-19 Thread cmc
To comment on the following update, log in, then open the issue:
http://www.openoffice.org/issues/show_bug.cgi?id=104329


User cmc changed the following:

What|Old value |New value

 Attachment is patch|  |Created an attachment (id=
|  |64249)
example patch






--- Additional comments from c...@openoffice.org Wed Aug 19 08:17:12 + 
2009 ---
Created an attachment (id=64249)
example patch


-
Please do not reply to this automatically generated notification from
Issue Tracker. Please log onto the website and enter your comments.
http://qa.openoffice.org/issue_handling/project_issues.html#notification

-
To unsubscribe, e-mail: issues-unsubscr...@dba.openoffice.org
For additional commands, e-mail: issues-h...@dba.openoffice.org



[dba-issues] [Issue 104329] dbaccess: better way to d etect/describe supporting primary keys

2009-08-19 Thread cmc
To comment on the following update, log in, then open the issue:
http://www.openoffice.org/issues/show_bug.cgi?id=104329


User cmc changed the following:

What|Old value |New value

OtherIssuesDependingOnTh|  |90439
  is|  |





-
Please do not reply to this automatically generated notification from
Issue Tracker. Please log onto the website and enter your comments.
http://qa.openoffice.org/issue_handling/project_issues.html#notification

-
To unsubscribe, e-mail: issues-unsubscr...@dba.openoffice.org
For additional commands, e-mail: issues-h...@dba.openoffice.org



[dba-issues] [Issue 92348] OOo create tables on postg resql without primary key

2009-08-19 Thread cmc
To comment on the following update, log in, then open the issue:
http://www.openoffice.org/issues/show_bug.cgi?id=92348


User cmc changed the following:

What|Old value |New value

  Status|CLOSED|UNCONFIRMED

  Resolution|WORKSFORME|





--- Additional comments from c...@openoffice.org Wed Aug 19 08:22:49 + 
2009 ---
reopening this as I sort of know what's going on

-
Please do not reply to this automatically generated notification from
Issue Tracker. Please log onto the website and enter your comments.
http://qa.openoffice.org/issue_handling/project_issues.html#notification

-
To unsubscribe, e-mail: issues-unsubscr...@dba.openoffice.org
For additional commands, e-mail: issues-h...@dba.openoffice.org



[dba-issues] [Issue 104329] dbaccess: better way to d etect/describe supporting primary keys

2009-08-19 Thread cmc
To comment on the following update, log in, then open the issue:
http://www.openoffice.org/issues/show_bug.cgi?id=104329





--- Additional comments from c...@openoffice.org Wed Aug 19 08:23:19 + 
2009 ---
*** Issue 92348 has been marked as a duplicate of this issue. ***

-
Please do not reply to this automatically generated notification from
Issue Tracker. Please log onto the website and enter your comments.
http://qa.openoffice.org/issue_handling/project_issues.html#notification

-
To unsubscribe, e-mail: issues-unsubscr...@dba.openoffice.org
For additional commands, e-mail: issues-h...@dba.openoffice.org



[dba-issues] [Issue 92348] OOo create tables on postg resql without primary key

2009-08-19 Thread cmc
To comment on the following update, log in, then open the issue:
http://www.openoffice.org/issues/show_bug.cgi?id=92348


User cmc changed the following:

What|Old value |New value

  Status|UNCONFIRMED   |RESOLVED

  Resolution|  |DUPLICATE





--- Additional comments from c...@openoffice.org Wed Aug 19 08:23:20 + 
2009 ---
Pretty sure its the issue I've some more detail about at 104329

*** This issue has been marked as a duplicate of 104329 ***

-
Please do not reply to this automatically generated notification from
Issue Tracker. Please log onto the website and enter your comments.
http://qa.openoffice.org/issue_handling/project_issues.html#notification

-
To unsubscribe, e-mail: issues-unsubscr...@dba.openoffice.org
For additional commands, e-mail: issues-h...@dba.openoffice.org



[dba-issues] [Issue 92348] OOo create tables on postg resql without primary key

2009-08-19 Thread cmc
To comment on the following update, log in, then open the issue:
http://www.openoffice.org/issues/show_bug.cgi?id=92348


User cmc changed the following:

What|Old value |New value

  Status|RESOLVED  |CLOSED





--- Additional comments from c...@openoffice.org Wed Aug 19 08:23:46 + 
2009 ---
closing as dup of issue with some detail

-
Please do not reply to this automatically generated notification from
Issue Tracker. Please log onto the website and enter your comments.
http://qa.openoffice.org/issue_handling/project_issues.html#notification

-
To unsubscribe, e-mail: issues-unsubscr...@dba.openoffice.org
For additional commands, e-mail: issues-h...@dba.openoffice.org



[dba-issues] [Issue 103371] The event when you close a form doesn't launch an assigned macro

2009-08-19 Thread fs
To comment on the following update, log in, then open the issue:
http://www.openoffice.org/issues/show_bug.cgi?id=103371


User fs changed the following:

What|Old value |New value

Target milestone|OOo 3.x   |OOo 3.2





--- Additional comments from f...@openoffice.org Wed Aug 19 09:44:52 + 
2009 ---
targeting to 3.2, since the fix is part of a CWS aiming for this release

-
Please do not reply to this automatically generated notification from
Issue Tracker. Please log onto the website and enter your comments.
http://qa.openoffice.org/issue_handling/project_issues.html#notification

-
To unsubscribe, e-mail: issues-unsubscr...@dba.openoffice.org
For additional commands, e-mail: issues-h...@dba.openoffice.org



[dba-issues] [Issue 103763] seamonkey and gtk2/mac to olkit

2009-08-19 Thread fs
To comment on the following update, log in, then open the issue:
http://www.openoffice.org/issues/show_bug.cgi?id=103763


User fs changed the following:

What|Old value |New value

Target milestone|OOo 3.x   |OOo 3.2





--- Additional comments from f...@openoffice.org Wed Aug 19 09:44:34 + 
2009 ---
targeting to 3.2, since the fix is part of a CWS aiming for this release

-
Please do not reply to this automatically generated notification from
Issue Tracker. Please log onto the website and enter your comments.
http://qa.openoffice.org/issue_handling/project_issues.html#notification

-
To unsubscribe, e-mail: issues-unsubscr...@dba.openoffice.org
For additional commands, e-mail: issues-h...@dba.openoffice.org



[dba-issues] [Issue 43530] Setting default values in field definitions for mysql table doesn't work correct

2009-08-19 Thread oj
To comment on the following update, log in, then open the issue:
http://www.openoffice.org/issues/show_bug.cgi?id=43530


User oj changed the following:

What|Old value |New value

  Status|NEW   |RESOLVED

  Resolution|  |WORKSFORME





--- Additional comments from o...@openoffice.org Wed Aug 19 11:39:33 + 
2009 ---
The default value will only be used when inserting new rows. It is not part of
the database.

I'm closing this, because it works like expected.

-
Please do not reply to this automatically generated notification from
Issue Tracker. Please log onto the website and enter your comments.
http://qa.openoffice.org/issue_handling/project_issues.html#notification

-
To unsubscribe, e-mail: issues-unsubscr...@dba.openoffice.org
For additional commands, e-mail: issues-h...@dba.openoffice.org



[dba-issues] [Issue 43530] Setting default values in field definitions for mysql table doesn't work correct

2009-08-19 Thread oj
To comment on the following update, log in, then open the issue:
http://www.openoffice.org/issues/show_bug.cgi?id=43530


User oj changed the following:

What|Old value |New value

  Status|RESOLVED  |CLOSED





--- Additional comments from o...@openoffice.org Wed Aug 19 11:39:57 + 
2009 ---
Closing this one.

-
Please do not reply to this automatically generated notification from
Issue Tracker. Please log onto the website and enter your comments.
http://qa.openoffice.org/issue_handling/project_issues.html#notification

-
To unsubscribe, e-mail: issues-unsubscr...@dba.openoffice.org
For additional commands, e-mail: issues-h...@dba.openoffice.org



[dba-issues] [Issue 59943] libkab1 depends on the dbt ools, svtools

2009-08-19 Thread oj
To comment on the following update, log in, then open the issue:
http://www.openoffice.org/issues/show_bug.cgi?id=59943


User oj changed the following:

What|Old value |New value

  Status|NEW   |RESOLVED

  Resolution|  |WONTFIX





--- Additional comments from o...@openoffice.org Wed Aug 19 12:21:31 + 
2009 ---
$(UPD) is no longer used. Closing this issue.

-
Please do not reply to this automatically generated notification from
Issue Tracker. Please log onto the website and enter your comments.
http://qa.openoffice.org/issue_handling/project_issues.html#notification

-
To unsubscribe, e-mail: issues-unsubscr...@dba.openoffice.org
For additional commands, e-mail: issues-h...@dba.openoffice.org



[dba-issues] [Issue 59943] libkab1 depends on the dbt ools, svtools

2009-08-19 Thread oj
To comment on the following update, log in, then open the issue:
http://www.openoffice.org/issues/show_bug.cgi?id=59943


User oj changed the following:

What|Old value |New value

  Status|RESOLVED  |CLOSED





--- Additional comments from o...@openoffice.org Wed Aug 19 12:22:32 + 
2009 ---
Closing.

-
Please do not reply to this automatically generated notification from
Issue Tracker. Please log onto the website and enter your comments.
http://qa.openoffice.org/issue_handling/project_issues.html#notification

-
To unsubscribe, e-mail: issues-unsubscr...@dba.openoffice.org
For additional commands, e-mail: issues-h...@dba.openoffice.org



[dba-issues] [Issue 55180] [meta] tracking report wiz ard issues

2009-08-19 Thread oj
To comment on the following update, log in, then open the issue:
http://www.openoffice.org/issues/show_bug.cgi?id=55180


User oj changed the following:

What|Old value |New value

  Status|RESOLVED  |CLOSED





--- Additional comments from o...@openoffice.org Wed Aug 19 12:34:04 + 
2009 ---
Closing

-
Please do not reply to this automatically generated notification from
Issue Tracker. Please log onto the website and enter your comments.
http://qa.openoffice.org/issue_handling/project_issues.html#notification

-
To unsubscribe, e-mail: issues-unsubscr...@dba.openoffice.org
For additional commands, e-mail: issues-h...@dba.openoffice.org



[dba-issues] [Issue 36219] The property browser for c ontrols (dialog controls as well as form contr ols) switches slowly

2009-08-19 Thread oj
To comment on the following update, log in, then open the issue:
http://www.openoffice.org/issues/show_bug.cgi?id=36219


User oj changed the following:

What|Old value |New value

 Assigned to|fs|msc





--- Additional comments from o...@openoffice.org Wed Aug 19 12:36:19 + 
2009 ---
@msc: Could please take a look at this if it still occurs. I tested a non pro
and even that version of DEV300_m55 was fast.

-
Please do not reply to this automatically generated notification from
Issue Tracker. Please log onto the website and enter your comments.
http://qa.openoffice.org/issue_handling/project_issues.html#notification

-
To unsubscribe, e-mail: issues-unsubscr...@dba.openoffice.org
For additional commands, e-mail: issues-h...@dba.openoffice.org



[dba-issues] [Issue 54326] Tools/relationships slow ( Oracle)

2009-08-19 Thread oj
To comment on the following update, log in, then open the issue:
http://www.openoffice.org/issues/show_bug.cgi?id=54326


User oj changed the following:

What|Old value |New value

  Status|NEW   |RESOLVED

  Resolution|  |FIXED

Target milestone|OOo Later |OOo 3.2





--- Additional comments from o...@openoffice.org Wed Aug 19 12:44:51 + 
2009 ---
Fixed in cws dbaperf3. Avoid calling Oracle to often.

-
Please do not reply to this automatically generated notification from
Issue Tracker. Please log onto the website and enter your comments.
http://qa.openoffice.org/issue_handling/project_issues.html#notification

-
To unsubscribe, e-mail: issues-unsubscr...@dba.openoffice.org
For additional commands, e-mail: issues-h...@dba.openoffice.org



[dba-issues] [Issue 54326] Tools/relationships slow ( Oracle)

2009-08-19 Thread oj
To comment on the following update, log in, then open the issue:
http://www.openoffice.org/issues/show_bug.cgi?id=54326


User oj changed the following:

What|Old value |New value

 Assigned to|fs|oj





--- Additional comments from o...@openoffice.org Wed Aug 19 12:46:29 + 
2009 ---
Grabbing

-
Please do not reply to this automatically generated notification from
Issue Tracker. Please log onto the website and enter your comments.
http://qa.openoffice.org/issue_handling/project_issues.html#notification

-
To unsubscribe, e-mail: issues-unsubscr...@dba.openoffice.org
For additional commands, e-mail: issues-h...@dba.openoffice.org



[dba-issues] [Issue 65597] Recovery of Forms doesn't works as Expected

2009-08-19 Thread fs
To comment on the following update, log in, then open the issue:
http://www.openoffice.org/issues/show_bug.cgi?id=65597


User fs changed the following:

What|Old value |New value

Target milestone|OOo 3.2   |OOo 3.x





--- Additional comments from f...@openoffice.org Wed Aug 19 13:04:49 + 
2009 ---
putting a more reasonable target onto it

-
Please do not reply to this automatically generated notification from
Issue Tracker. Please log onto the website and enter your comments.
http://qa.openoffice.org/issue_handling/project_issues.html#notification

-
To unsubscribe, e-mail: issues-unsubscr...@dba.openoffice.org
For additional commands, e-mail: issues-h...@dba.openoffice.org



[dba-issues] [Issue 90774] accessing a Thunderbird ad dress book not possible

2009-08-19 Thread fs
To comment on the following update, log in, then open the issue:
http://www.openoffice.org/issues/show_bug.cgi?id=90774


User fs changed the following:

What|Old value |New value

Keywords|aqua, crash, oooqa|aqua, oooqa

 Summary|accessing a Thunderbird ad|accessing a Thunderbird ad
|dress book crashes|dress book not possible

Target milestone|OOo 3.2   |OOo 3.x





--- Additional comments from f...@openoffice.org Wed Aug 19 13:05:56 + 
2009 ---
adjusting summary/keywords to say that this is not about a crash anymore

-
Please do not reply to this automatically generated notification from
Issue Tracker. Please log onto the website and enter your comments.
http://qa.openoffice.org/issue_handling/project_issues.html#notification

-
To unsubscribe, e-mail: issues-unsubscr...@dba.openoffice.org
For additional commands, e-mail: issues-h...@dba.openoffice.org



[dba-issues] [Issue 50175] Error in Query Design with Aliases and Sorting

2009-08-19 Thread oj
To comment on the following update, log in, then open the issue:
http://www.openoffice.org/issues/show_bug.cgi?id=50175


User oj changed the following:

What|Old value |New value

 Assigned to|fs|oj





--- Additional comments from o...@openoffice.org Wed Aug 19 13:19:03 + 
2009 ---
Grabing

-
Please do not reply to this automatically generated notification from
Issue Tracker. Please log onto the website and enter your comments.
http://qa.openoffice.org/issue_handling/project_issues.html#notification

-
To unsubscribe, e-mail: issues-unsubscr...@dba.openoffice.org
For additional commands, e-mail: issues-h...@dba.openoffice.org



[dba-issues] [Issue 50175] Error in Query Design with Aliases and Sorting

2009-08-19 Thread oj
To comment on the following update, log in, then open the issue:
http://www.openoffice.org/issues/show_bug.cgi?id=50175


User oj changed the following:

What|Old value |New value

  Status|NEW   |RESOLVED

  Resolution|  |WORKSFORME





--- Additional comments from o...@openoffice.org Wed Aug 19 13:19:44 + 
2009 ---
I tried it in DEV300_m55 and it works.


-
Please do not reply to this automatically generated notification from
Issue Tracker. Please log onto the website and enter your comments.
http://qa.openoffice.org/issue_handling/project_issues.html#notification

-
To unsubscribe, e-mail: issues-unsubscr...@dba.openoffice.org
For additional commands, e-mail: issues-h...@dba.openoffice.org



[dba-issues] [Issue 50175] Error in Query Design with Aliases and Sorting

2009-08-19 Thread oj
To comment on the following update, log in, then open the issue:
http://www.openoffice.org/issues/show_bug.cgi?id=50175


User oj changed the following:

What|Old value |New value

  Status|RESOLVED  |CLOSED





--- Additional comments from o...@openoffice.org Wed Aug 19 13:20:05 + 
2009 ---
Closing it.

-
Please do not reply to this automatically generated notification from
Issue Tracker. Please log onto the website and enter your comments.
http://qa.openoffice.org/issue_handling/project_issues.html#notification

-
To unsubscribe, e-mail: issues-unsubscr...@dba.openoffice.org
For additional commands, e-mail: issues-h...@dba.openoffice.org



[dba-issues] [Issue 36231] forms: option explicit co mmit is missing

2009-08-19 Thread mhatheoo
To comment on the following update, log in, then open the issue:
http://www.openoffice.org/issues/show_bug.cgi?id=36231





--- Additional comments from mhath...@openoffice.org Wed Aug 19 13:53:16 
+ 2009 ---
fs

well, I see that the changes to HSQL 1.9  will cause some problems, although as
I understood these changes seems to be more under the hood and not that much
relevant to applications calling HSQL-functions by skripts. However, I am not
that much a developer to judge about that.

But nevertheless I can not really accept your responds. I have in mind, that an
OO-form should not be leavable by using any auto-commit-function, but only by
using an explicit function. Of course this needs to think about locking etc, but
this is related to OO.o only, as it is part of the form-properties, not related
to HSQL.

Example: Supposed you will have a record-copy-function sometimes (choose a
record - dublicate it to temp - edit it - and start the base-table-updated when
all is done from user-side) you will face the same problems. So you have the
following options: Give up and wait until this feature is implemented in HSQL
(which may not come!), implement it as an OO-base feature, or trust, that users
will find a makro-solution.

You understand, that it is not about your ambitions to solve this matter, it is
about the competence within the community aswell as the willing of your employee
to spend something on that. Thats all.

Martin
 

-
Please do not reply to this automatically generated notification from
Issue Tracker. Please log onto the website and enter your comments.
http://qa.openoffice.org/issue_handling/project_issues.html#notification

-
To unsubscribe, e-mail: issues-unsubscr...@dba.openoffice.org
For additional commands, e-mail: issues-h...@dba.openoffice.org



[dba-issues] [Issue 104342] needs to filter hsql con structions in postgesql-sdbc

2009-08-19 Thread denis0
To comment on the following update, log in, then open the issue:
http://www.openoffice.org/issues/show_bug.cgi?id=104342
 Issue #|104342
 Summary|needs  to filter hsql constructions in postgesql-sdbc 
   Component|Database access
 Version|1.0.0
Platform|All
 URL|
  OS/Version|All
  Status|UNCONFIRMED
   Status whiteboard|
Keywords|
  Resolution|
  Issue type|DEFECT
Priority|P3
Subcomponent|none
 Assigned to|jbu
 Reported by|denis0





--- Additional comments from den...@openoffice.org Wed Aug 19 17:49:21 
+ 2009 ---
If i try to filter postgresql table by field of date type, OOo change trivial
sql like:

SELECT * FROM tablename WHERE date_type_col = '2009-01-01'
by
SELECT * FROM tablename WHERE date_type_col = {D '2009-01-01'}



Postgresql doesn`t like that syntax.

If i`ll try to use native SQL, filters are off... :(

Can you filter that syntax in postgresql-sdbc driver?

-
Please do not reply to this automatically generated notification from
Issue Tracker. Please log onto the website and enter your comments.
http://qa.openoffice.org/issue_handling/project_issues.html#notification

-
To unsubscribe, e-mail: issues-unsubscr...@dba.openoffice.org
For additional commands, e-mail: issues-h...@dba.openoffice.org



[dba-issues] [Issue 104342] needs to filter hsql con structions in postgesql-sdbc

2009-08-19 Thread denis0
To comment on the following update, log in, then open the issue:
http://www.openoffice.org/issues/show_bug.cgi?id=104342


User denis0 changed the following:

What|Old value |New value

 Summary|needs  to filter hsql cons|needs  to filter hsql cons
|tructions in postgesql-sdb|tructions in postgesql-sdb
|c |c





--- Additional comments from den...@openoffice.org Wed Aug 19 18:07:40 
+ 2009 ---
Sorry, found a duplicate...

-
Please do not reply to this automatically generated notification from
Issue Tracker. Please log onto the website and enter your comments.
http://qa.openoffice.org/issue_handling/project_issues.html#notification

-
To unsubscribe, e-mail: issues-unsubscr...@dba.openoffice.org
For additional commands, e-mail: issues-h...@dba.openoffice.org



[dba-issues] [Issue 104342] needs to filter hsql con structions in postgesql-sdbc

2009-08-19 Thread fs
To comment on the following update, log in, then open the issue:
http://www.openoffice.org/issues/show_bug.cgi?id=104342





--- Additional comments from f...@openoffice.org Wed Aug 19 19:10:08 + 
2009 ---
You don't mention the OOo version you use, and didn't fill in the Version
field correctly ...

In current developer builds, reflecting development towards OOo 3.2, there's an
option Use ODBC conformant date/time literals in Edit / Database / Advanced
Settings / Special Settings, which you need to set *off* for PostgreSQL.

-
Please do not reply to this automatically generated notification from
Issue Tracker. Please log onto the website and enter your comments.
http://qa.openoffice.org/issue_handling/project_issues.html#notification

-
To unsubscribe, e-mail: issues-unsubscr...@dba.openoffice.org
For additional commands, e-mail: issues-h...@dba.openoffice.org



[dba-issues] [Issue 104342] needs to filter hsql con structions in postgesql-sdbc

2009-08-19 Thread denis0
To comment on the following update, log in, then open the issue:
http://www.openoffice.org/issues/show_bug.cgi?id=104342


User denis0 changed the following:

What|Old value |New value

 Version|1.0.0 |OOo 3.1





--- Additional comments from den...@openoffice.org Wed Aug 19 19:37:20 
+ 2009 ---
Thank you!

One more question: can i set this option off by default in OOo 3.1 anyway? May
be in some config file?

-
Please do not reply to this automatically generated notification from
Issue Tracker. Please log onto the website and enter your comments.
http://qa.openoffice.org/issue_handling/project_issues.html#notification

-
To unsubscribe, e-mail: issues-unsubscr...@dba.openoffice.org
For additional commands, e-mail: issues-h...@dba.openoffice.org



[dba-issues] [Issue 104342] needs to filter hsql con structions in postgesql-sdbc

2009-08-19 Thread fs
To comment on the following update, log in, then open the issue:
http://www.openoffice.org/issues/show_bug.cgi?id=104342





--- Additional comments from f...@openoffice.org Wed Aug 19 21:38:57 + 
2009 ---
out of my head, didn't try it ...

  ThisDatabaseDocument.DataSource.Settings.EscapeDateTime = False

, executed as macro embedded in the database document, will set this, for the
given document.

-
Please do not reply to this automatically generated notification from
Issue Tracker. Please log onto the website and enter your comments.
http://qa.openoffice.org/issue_handling/project_issues.html#notification

-
To unsubscribe, e-mail: issues-unsubscr...@dba.openoffice.org
For additional commands, e-mail: issues-h...@dba.openoffice.org



[dba-issues] [Issue 104345] Base: ESC-key should func tion to break entry in field

2009-08-19 Thread mhatheoo
To comment on the following update, log in, then open the issue:
http://www.openoffice.org/issues/show_bug.cgi?id=104345
 Issue #|104345
 Summary|Base: ESC-key should function to break entry in field
   Component|Database access
 Version|OOo 3.1
Platform|Unknown
 URL|
  OS/Version|All
  Status|UNCONFIRMED
   Status whiteboard|
Keywords|
  Resolution|
  Issue type|ENHANCEMENT
Priority|P3
Subcomponent|none
 Assigned to|dbaneedsconfirm
 Reported by|mhatheoo





--- Additional comments from mhath...@openoffice.org Wed Aug 19 23:17:59 
+ 2009 ---
the summary says it:
to have the ESC-key available to take back wrong entries in a field would be
useful (this related to the very field only, not the whole record)

Martin

-
Please do not reply to this automatically generated notification from
Issue Tracker. Please log onto the website and enter your comments.
http://qa.openoffice.org/issue_handling/project_issues.html#notification

-
To unsubscribe, e-mail: issues-unsubscr...@dba.openoffice.org
For additional commands, e-mail: issues-h...@dba.openoffice.org



[dba-issues] [Issue 104346] Base: MASK in forms fills up with blanks

2009-08-19 Thread mhatheoo
To comment on the following update, log in, then open the issue:
http://www.openoffice.org/issues/show_bug.cgi?id=104346
 Issue #|104346
 Summary|Base: MASK in forms fills up with blanks
   Component|Database access
 Version|OOo 3.1
Platform|Unknown
 URL|
  OS/Version|All
  Status|UNCONFIRMED
   Status whiteboard|
Keywords|
  Resolution|
  Issue type|DEFECT
Priority|P3
Subcomponent|none
 Assigned to|dbaneedsconfirm
 Reported by|mhatheoo





--- Additional comments from mhath...@openoffice.org Wed Aug 19 23:28:48 
+ 2009 ---
the summary says it:

It is annoying that one needs to define the mask for the character-entry for the
whole expected length, but places that need no entry on actual data-entry will
be filled up with blanks.
(Like: MASK CC - entry ABC123 - should not ad four blanks/spaces)
Just leave it as entered - with 6 characters as in the example

Martin

-
Please do not reply to this automatically generated notification from
Issue Tracker. Please log onto the website and enter your comments.
http://qa.openoffice.org/issue_handling/project_issues.html#notification

-
To unsubscribe, e-mail: issues-unsubscr...@dba.openoffice.org
For additional commands, e-mail: issues-h...@dba.openoffice.org



[dba-issues] [Issue 104347] Base: Content in Memo-fie lds is in stated selected by default

2009-08-19 Thread mhatheoo
To comment on the following update, log in, then open the issue:
http://www.openoffice.org/issues/show_bug.cgi?id=104347
 Issue #|104347
 Summary|Base: Content in Memo-fields is in stated selected by 
|default
   Component|Database access
 Version|OOo 3.1
Platform|Unknown
 URL|
  OS/Version|All
  Status|UNCONFIRMED
   Status whiteboard|
Keywords|
  Resolution|
  Issue type|DEFECT
Priority|P3
Subcomponent|none
 Assigned to|dbaneedsconfirm
 Reported by|mhatheoo





--- Additional comments from mhath...@openoffice.org Wed Aug 19 23:34:36 
+ 2009 ---
the summary says it:

Going to a memo-field in a form, the state of the content is selected by
default, this is dangerous to content and unwanted behaviour. 
(esp. as long as the default procedure to store data is auto-commit!)

By default, the content needs to be unselected and the position of the cursor
needs to be at the end of content.

Martin

-
Please do not reply to this automatically generated notification from
Issue Tracker. Please log onto the website and enter your comments.
http://qa.openoffice.org/issue_handling/project_issues.html#notification

-
To unsubscribe, e-mail: issues-unsubscr...@dba.openoffice.org
For additional commands, e-mail: issues-h...@dba.openoffice.org



[dba-issues] [Issue 104342] needs to filter hsql con structions in postgesql-sdbc

2009-08-19 Thread denis0
To comment on the following update, log in, then open the issue:
http://www.openoffice.org/issues/show_bug.cgi?id=104342





--- Additional comments from den...@openoffice.org Thu Aug 20 05:05:29 
+ 2009 ---
It works fine! Thank you again!!!

-
Please do not reply to this automatically generated notification from
Issue Tracker. Please log onto the website and enter your comments.
http://qa.openoffice.org/issue_handling/project_issues.html#notification

-
To unsubscribe, e-mail: issues-unsubscr...@dba.openoffice.org
For additional commands, e-mail: issues-h...@dba.openoffice.org



[dba-issues] [Issue 103528] SQL BITXOR behaves as BIT OR

2009-08-19 Thread oj
To comment on the following update, log in, then open the issue:
http://www.openoffice.org/issues/show_bug.cgi?id=103528


User oj changed the following:

What|Old value |New value

 Assigned to|oj|msc





--- Additional comments from o...@openoffice.org Thu Aug 20 05:39:59 + 
2009 ---
Please verify. Thanks.

Before the patch the result for bitor and bitxor was the same.

-
Please do not reply to this automatically generated notification from
Issue Tracker. Please log onto the website and enter your comments.
http://qa.openoffice.org/issue_handling/project_issues.html#notification

-
To unsubscribe, e-mail: issues-unsubscr...@dba.openoffice.org
For additional commands, e-mail: issues-h...@dba.openoffice.org



[dba-issues] [Issue 103882] Clipboard import of float ing point numbers fails due to formatting

2009-08-19 Thread oj
To comment on the following update, log in, then open the issue:
http://www.openoffice.org/issues/show_bug.cgi?id=103882


User oj changed the following:

What|Old value |New value

 Assigned to|oj|msc





--- Additional comments from o...@openoffice.org Thu Aug 20 05:42:42 + 
2009 ---
Please verify. Thanks.

-
Please do not reply to this automatically generated notification from
Issue Tracker. Please log onto the website and enter your comments.
http://qa.openoffice.org/issue_handling/project_issues.html#notification

-
To unsubscribe, e-mail: issues-unsubscr...@dba.openoffice.org
For additional commands, e-mail: issues-h...@dba.openoffice.org



[dba-issues] [Issue 104187] SRB: copy and paste of ch arts failed

2009-08-19 Thread oj
To comment on the following update, log in, then open the issue:
http://www.openoffice.org/issues/show_bug.cgi?id=104187


User oj changed the following:

What|Old value |New value

 Assigned to|oj|msc





--- Additional comments from o...@openoffice.org Thu Aug 20 05:43:20 + 
2009 ---
Please verify. Thanks.

-
Please do not reply to this automatically generated notification from
Issue Tracker. Please log onto the website and enter your comments.
http://qa.openoffice.org/issue_handling/project_issues.html#notification

-
To unsubscribe, e-mail: issues-unsubscr...@dba.openoffice.org
For additional commands, e-mail: issues-h...@dba.openoffice.org



[dba-issues] [Issue 99058] RPT: missing vertical just ification for textfields

2009-08-19 Thread oj
To comment on the following update, log in, then open the issue:
http://www.openoffice.org/issues/show_bug.cgi?id=99058


User oj changed the following:

What|Old value |New value

 Assigned to|oj|msc





--- Additional comments from o...@openoffice.org Thu Aug 20 05:47:34 + 
2009 ---
Please verify. Thanks.

-
Please do not reply to this automatically generated notification from
Issue Tracker. Please log onto the website and enter your comments.
http://qa.openoffice.org/issue_handling/project_issues.html#notification

-
To unsubscribe, e-mail: issues-unsubscr...@dba.openoffice.org
For additional commands, e-mail: issues-h...@dba.openoffice.org