[dba-issues] =?UTF-8?B?W0lzc3VlIDQ4NTE2XSAgRmllbGQgbmFtZXMgb2YgZGF0YWJhc2Ugbg==?= =?UTF-8?B?byBvdW5kIHdoZW4gdXNpbmcgRm9ybXMgd2l6YXJkIG9yIERlc2lnbmVy?=
To comment on the following update, log in, then open the issue: http://www.openoffice.org/issues/show_bug.cgi?id=48516 --- Additional comments from [EMAIL PROTECTED] Thu Jun 9 16:25:58 -0700 2005 --- Hi Marc, The contents of my ~/.odbc.ini is: --- cat ~/.odbc.ini [MySQL-adressen] Description = MySQL database adressen Driver = MySQL Server = localhost Database= adressen Port= 3306 Socket = /opt/lampp/var/mysql/mysql.sock Option = Stmt= [MySQL-BBG] Description = MySQL database Brassband Gelderland Driver = MySQL Server = localhost Database= BBG Port= 3306 Socket = /opt/lampp/var/mysql/mysql.sock Option = Stmt= [MySQL-video] Description = MySQL database videobanden Driver = MySQL Server = localhost Database= videos Port= 3306 Socket = /opt/lampp/var/mysql/mysql.sock Option = Stmt= [MySQL-kokenfoarried] Description = MySQL database kokenfoarried Driver = MySQL Server = localhost Database= kokenfoarried Port= 3306 Socket = /opt/lampp/var/mysql/mysql.sock Option = Stmt= --- The most offending item is the first, the Adressen table. But what lib is used is not stated in ~/.odbc.ini, am I right? The output of the 'Describe table'-command in mysql: --- mysql use adressen; Database changed mysql show tables; ++ | Tables_in_adressen | ++ | naw| ++ 1 row in set (0.02 sec) mysql describe naw; +---+---+--+-+-++ | Field | Type | Null | Key | Default | Extra | +---+---+--+-+-++ | volgnr| smallint(4) | | PRI | NULL| auto_increment | | voornaam | varchar(10) | | | || | tussenvoegsel | varchar(7)| YES | | NULL|| | achternaam| varchar(15) | | | || | adresnaam | varchar(50) | | | || | straat| varchar(30) | | | || | nummer| tinyint(3)| | | 0 || | bis | char(3) | YES | | NULL|| | postcode | varchar(8)| | | || | plaats| varchar(15) | | | || | staat | varchar(15) | YES | | NULL|| | land | varchar(15) | | | || | tel priv| decimal(10,0) | | | 0 || | mobiel| decimal(10,0) | YES | | 0 || | tel werk | varchar(10) | YES | | NULL|| | e-mail| varchar(30) | YES | | NULL|| +---+---+--+-+-++ 16 rows in set (0.03 sec) - kind greetings, jehojakim - 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: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED] - To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]
[dba-issues] =?UTF-8?B?W0lzc3VlIDQ4NTE2XSAgRmllbGQgbmFtZXMgb2YgZGF0YWJhc2Ugbg==?= =?UTF-8?B?byBvdW5kIHdoZW4gdXNpbmcgRm9ybXMgd2l6YXJkIG9yIERlc2lnbmVy?=
To comment on the following update, log in, then open the issue: http://www.openoffice.org/issues/show_bug.cgi?id=48516 --- Additional comments from [EMAIL PROTECTED] Thu Jun 9 16:29:34 -0700 2005 --- I saw a special character in the fieldname 'priv', so I changed it to 'privee'. It makes no difference. kind greetings, Jehojakim - 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: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED] - To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]
[sw-issues] [Issue 43146] Users should have the option to have the cursor position remembered when opening a document.
To comment on the following update, log in, then open the issue: http://www.openoffice.org/issues/show_bug.cgi?id=43146 --- Additional comments from [EMAIL PROTECTED] Sun Jun 5 07:21:04 -0700 2005 --- To my opinion the bias towards the reader, vs. the writer, is wrong. Indeed, chances are that there are a lot more readers than wirters of a document. But, mostly, readers will read the document only once on the screen, and from my experience readers tend to print the document rather than read it on the screen at all, especially with larger documents - for which the whole issue is the most important. Writers and editors, however, handle the document many, many more times. So the disadvantage for writer/editor of the cursor not being positioned on the last position is much greater than the disadvantage for the reader to have to jump to the top of the doc. So, my votes are for the old behaviour. Cheers, jehojakim - 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: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED] - To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]
[dba-issues] [Issue 48516] Field names of database no ound when using Forms wizard or Designer
To comment on the following update, log in, then open the issue: http://www.openoffice.org/issues/show_bug.cgi?id=48516 --- Additional comments from [EMAIL PROTECTED] Tue May 24 13:32:31 -0700 2005 --- In short: yes, I installed v 3.51.11, but it didn't help. In extenso: Originally I had v. 3.51.07 of the ODBC-driver, so I replaced it by 3.51.11 So now in /usr/lib I have the new version installed: /usr/lib/libmyodbc3-3.51.11.so /usr/lib/libmyodbc3.la /usr/lib/libmyodbc3.so /usr/lib/libmyodbc3S-3.51.11.so /usr/lib/libmyodbc3S.la /usr/lib/libmyodbc3S.so /usr/lib/libmyodbc3_r-3.51.11.so /usr/lib/libmyodbc3_r.la /usr/lib/libmyodbc3_r.so /usr/lib/libodbc.so /usr/lib/libodbc.so.1 /usr/lib/libodbc.so.1.0.0 /usr/lib/libodbccr.so.1 /usr/lib/libodbccr.so.1.0.0 /usr/lib/libodbcextras.so.1 /usr/lib/libodbcextras.so.1.0.0 /usr/lib/libodbcinst.so /usr/lib/libodbcinst.so.1 /usr/lib/libodbcinst.so.1.0.0 /usr/lib/libodbcinstQ.la /usr/lib/libodbcinstQ.so /usr/lib/libodbcinstQ.so.1 /usr/lib/libodbcinstQ.so.1.0.0 and in /usr/lib/unixODBC: /usr/lib/unixODBC/libmyodbc3-3.51.07.so /usr/lib/unixODBC/libmyodbc3.la /usr/lib/unixODBC/libmyodbc3.so /usr/lib/unixODBC/libmyodbc3_r-3.51.07.so /usr/lib/unixODBC/libmyodbc3_r.la /usr/lib/unixODBC/libmyodbc3_r.so /usr/lib/unixODBC/libodbcdrvcfg1S.so.1 /usr/lib/unixODBC/libodbcdrvcfg1S.so.1.0.0 /usr/lib/unixODBC/libodbcdrvcfg2S.so.1 /usr/lib/unixODBC/libodbcdrvcfg2S.so.1.0.0 /usr/lib/unixODBC/libodbcminiS.so.1 /usr/lib/unixODBC/libodbcminiS.so.1.0.0 /usr/lib/unixODBC/libodbcmyS.so.1 /usr/lib/unixODBC/libodbcmyS.so.1.0.0 /usr/lib/unixODBC/libodbcnnS.so.1 /usr/lib/unixODBC/libodbcnnS.so.1.0.0 /usr/lib/unixODBC/libodbcpsql.so.1 /usr/lib/unixODBC/libodbcpsql.so.1.0.0 /usr/lib/unixODBC/libodbcpsql.so.2 /usr/lib/unixODBC/libodbcpsql.so.2.0.0 /usr/lib/unixODBC/libodbcpsqlS.so.1 /usr/lib/unixODBC/libodbcpsqlS.so.1.0.0 /usr/lib/unixODBC/libodbctxt.so.1 /usr/lib/unixODBC/libodbctxt.so.1.0.0 /usr/lib/unixODBC/libodbctxtS.so.1 /usr/lib/unixODBC/libodbctxtS.so.1.0.0 /usr/lib/unixODBC/liboplodbcS.so.1 /usr/lib/unixODBC/liboplodbcS.so.1.0.0 /usr/lib/unixODBC/liboraodbcS.so.1 /usr/lib/unixODBC/liboraodbcS.so.1.0.0 Trough /etc/unixODBC/odbcinst.ini I think I activated the correct version: [MySQL] Description = ODBC Driver voor MySQL Driver = /usr/lib/libmyodbc3.so Setup = /usr/lib/libodbcmy3S.so FileUsage = 1 CPTimeout = CPReuse = [MySQL ODBC 3.51 Driver] DRIVER = /usr/lib/libmyodbc3.so SETUP = /usr/lib/libmyodbc3S.so UsageCount = 1 Result of this all is the same... == Off this topic, but maybe releated: Curiously enough I discovered that the problem doesn't show up with *all* my MySql databases: several of them show the field names in the forms wizard. But then, when I try to use the form to acces the database, it shows it as read-only, while the user has all rights to the database granted, and in the forms wizard I didn't choose a read-only version. On yet another database the form is according to the title bar is also read-only, but it is in fact possible to create a new record *IN THE FORM*. But when trying to save this new record to the database, the forms complaints --- SQL Status: HYT00 Error code: 1136 Column count doesn't match value count at row 1 --- while all the columns are filled, with as the one exception an autofill field, which in the form field is recognized as such. Is the exact SQL-statement generated for a save to the database reproducable? = hope this helps a little... kind regards, jehojakim - 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: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED] - To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]
[dba-issues] [Issue 48516] Field names of database no ound when using Forms wizard or Designer
To comment on the following update, log in, then open the issue: http://www.openoffice.org/issues/show_bug.cgi?id=48516 --- Additional comments from [EMAIL PROTECTED] Mon May 2 06:15:02 -0700 2005 --- Data source is MySql, v 4.0.21 - sorry, should have mentioned that in the first place. It's a very simple one-table database. There are 16 fields in the table. Connection wih Thunderbird or a OOo 680.1.9.95 spreadsheet doesn't have the problem. kind greetings, jehojakim - 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: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED] - To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]
[dba-issues] [Issue 48516] New - Field names of database no ound when using Forms wizard or Designer
To comment on the following update, log in, then open the issue: http://www.openoffice.org/issues/show_bug.cgi?id=48516 Issue #:|48516 Summary:|Field names of database no ound when using Forms |wizard or Designer Component:|Database access Version:|680m95 Platform:|PC URL:| OS/Version:|Linux Status:|UNCONFIRMED Status whiteboard:| Keywords:| Resolution:| Issue type:|DEFECT Priority:|P3 Subcomponent:|none Assigned to:|msc Reported by:|jehojakim --- Additional comments from [EMAIL PROTECTED] Sun May 1 10:18:00 -0700 2005 --- I file this issue in 680m95, but actually I encountered it in a few versions before this. What I do is: - create a new database by choosing File-New-Database, then choose Connect to an existing database, database type ODBC, then select a database, give username and check Password required; So far so good, I can test the connection, and the test succeeds - I save it in OpenDocument Database format Still OK, I get the database window, with in the leftmost frame the 'Forms' type of tasks highlighted. The problem comes when I want to use the Forms wizard, or try to create a form in the Designer; in both cases OOo reacts with the message 'The field names of database.table could not be retrieved' Funny thing is, when I go to the 'Table' type of tasks, and doubleclick the table concerned, I get the contents of the table -including- their field names. I couldn't find the issue in the database, though I can hardly imagine no one stumbled across it... So I may have overlooked it, in which case my apologies. I run a Suse 9.2 box, on an Acer Aspire 1710 laptop kind greetings, jehojakim - 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: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED] - To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]