[script-issues] [Issue 74375] read file with fixed recor d len, missing bytes, 2 bytes offset
To comment on the following update, log in, then open the issue: http://www.openoffice.org/issues/show_bug.cgi?id=74375 --- Additional comments from szod...@openoffice.org Wed Dec 23 16:56:52 + 2009 --- szodrow-ab: Can be closed - 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...@script.openoffice.org For additional commands, e-mail: issues-h...@script.openoffice.org - To unsubscribe, e-mail: allbugs-unsubscr...@openoffice.org For additional commands, e-mail: allbugs-h...@openoffice.org
[script-issues] [Issue 76810] Bug in put command (for bi nary access)
To comment on the following update, log in, then open the issue: http://www.openoffice.org/issues/show_bug.cgi?id=76810 --- Additional comments from szod...@openoffice.org Wed Dec 23 16:59:26 + 2009 --- szodrow-ab: Can be closed - 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...@script.openoffice.org For additional commands, e-mail: issues-h...@script.openoffice.org - To unsubscribe, e-mail: allbugs-unsubscr...@openoffice.org For additional commands, e-mail: allbugs-h...@openoffice.org
[script-issues] [Issue 74375] read file with fixed recor d len, missing bytes, 2 bytes offset
To comment on the following update, log in, then open the issue: http://www.openoffice.org/issues/show_bug.cgi?id=74375 User szodrow changed the following: What|Old value |New value Status|STARTED |NEW --- Additional comments from szod...@openoffice.org Fri Dec 11 17:20:42 + 2009 --- After some more testing, I found the cause for this problem now: I had created a buffer of data type string. String is in Unicode in OpenOffice Basic. When writing non ASCII characters to disk those characters were physically expanded. When looking to those files in a hex editor, you could see this and suspecting an error. I replaced the string buffer with an Byte Array and the problem is solved. I think it was good to place a comment somewhere in the OpenOffice Documentation how to handle binary files correctly (Help or Wiki). Can you tell me a place where I can place an example? :-) - 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...@script.openoffice.org For additional commands, e-mail: issues-h...@script.openoffice.org - To unsubscribe, e-mail: allbugs-unsubscr...@openoffice.org For additional commands, e-mail: allbugs-h...@openoffice.org
[dba-issues] [Issue 74374] Basic Runtime error: metho d getDate is missing
To comment on the following update, log in, then open the issue: http://www.openoffice.org/issues/show_bug.cgi?id=74374 User szodrow changed the following: What|Old value |New value Status|RESOLVED |CLOSED --- Additional comments from [EMAIL PROTECTED] Mon Apr 30 14:18:03 + 2007 --- Found a Function UNODateToDate(ByVal x) As Date from Andrew Pitonyak which works fine. Nevertheless this wrapper should be part of the OO Basic engine. :-) - 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]
[framework-issues] [Issue 76810] Bug in put command (for bi nary access)
To comment on the following update, log in, then open the issue: http://www.openoffice.org/issues/show_bug.cgi?id=76810 Issue #|76810 Summary|Bug in put command (for binary access) Component|framework Version|OOo 2.2 Platform|All URL| OS/Version|All Status|UNCONFIRMED Status whiteboard| Keywords| Resolution| Issue type|DEFECT Priority|P3 Subcomponent|scripting Assigned to|npower Reported by|szodrow --- Additional comments from [EMAIL PROTECTED] Mon Apr 30 14:33:42 + 2007 --- I want to write a csv file. The write command encloses everything with double quotes, so I use binary mode and apply newline characters by hand. I use the following put syntax: put iFileNo, , sString This works fine for about 1000 characters. Then everything is missing except the last record. I can use a workaround with the following syntax: put iFileNo, posCounterOnMyOwn, sString and track the write position on my own. This is not nice and should be fixed together with (my) Issue 74375 read file with fix... :-) - 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]
[framework-issues] [Issue 76810] Bug in put command (for bi nary access)
To comment on the following update, log in, then open the issue: http://www.openoffice.org/issues/show_bug.cgi?id=76810 User szodrow changed the following: What|Old value |New value Attachment data| |Created an attachment (id= | |44778) Calc file with macr | |o that shows the problem --- Additional comments from [EMAIL PROTECTED] Mon Apr 30 14:36:10 + 2007 --- Created an attachment (id=44778) Calc file with macro that shows the problem - 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]
[framework-issues] [Issue 74375] read file with fixed recor d len, missing bytes, 2 bytes offset
To comment on the following update, log in, then open the issue: http://www.openoffice.org/issues/show_bug.cgi?id=74375 --- Additional comments from [EMAIL PROTECTED] Tue Mar 13 12:39:17 + 2007 --- What does STARTED, not yet reproduced mean? Did the problem not occur? Is there something missing to reproduce it? Is it still unclear what the problem 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: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED] - To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]
[framework-issues] [Issue 74375] read file with fixed recor d len, missing bytes, 2 bytes offset
To comment on the following update, log in, then open the issue: http://www.openoffice.org/issues/show_bug.cgi?id=74375 User szodrow changed the following: What|Old value |New value Attachment data| |Created an attachment (id= | |42979) Worksheet with Macr | |os and instructions --- Additional comments from [EMAIL PROTECTED] Tue Feb 13 15:39:13 + 2007 --- Created an attachment (id=42979) Worksheet with Macros and instructions - 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]
[framework-issues] [Issue 74375] read file with fixed recor d len, missing bytes, 2 bytes offset
To comment on the following update, log in, then open the issue: http://www.openoffice.org/issues/show_bug.cgi?id=74375 --- Additional comments from [EMAIL PROTECTED] Tue Feb 13 15:44:52 + 2007 --- Hello, in the worksheet FileReadProblem.ods you find macros and instructions that show my problem(s). You have to modiy the directory and file name in the macro and you have to create a new test file or use e. g. the test file datev2blocks. :-) - 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 74374] Basic Runtime error: metho d getDate is missing
To comment on the following update, log in, then open the issue: http://www.openoffice.org/issues/show_bug.cgi?id=74374 User szodrow changed the following: What|Old value |New value Status|UNCONFIRMED |RESOLVED Resolution| |WORKSFORME --- Additional comments from [EMAIL PROTECTED] Mon Feb 12 11:14:49 + 2007 --- I will try with a data type com.sun.star.util.Date. Is it possible to have a sort wrapper for the date data type of the basic language? - 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 74374] Basic Runtime error: metho d getDate is missing
To comment on the following update, log in, then open the issue: http://www.openoffice.org/issues/show_bug.cgi?id=74374 Issue #|74374 Summary|Basic Runtime error: method getDate is missing Component|Database access Version|OOo 2.1 Platform|All URL| OS/Version|Windows XP Status|UNCONFIRMED Status whiteboard| Keywords| Resolution| Issue type|DEFECT Priority|P3 Subcomponent|none Assigned to|dbaneedsconfirm Reported by|szodrow --- Additional comments from [EMAIL PROTECTED] Fri Feb 9 11:07:41 + 2007 --- I have a MySQL DB connected via ODBC. In a Basic macro I loop throught the result set. I want to read the a date column with Resultset.getDate but I get a runtime error: Basic Laufzeitfehler Eigenschaften oder Methode nicht gefunden In the following some more information and the code. I also have a problem with binding dates to the SQL statement, but there I could live with the workaround below. :-) Problem with dates, especially getDate in SQL Query The runtime error: Basic Laufzeitfehler Eigenschaften oder Methode nicht gefunden Sql Query (MySQL DB via ODBC 3.51.11 or 5.51.12): select /* EK Pos */ round(jp.GPREIS * if(jp.brutto_flag = 'Y', 1, (100 + r.val_double) /100), 2) PosPreis, j.orgnum as LiefRechNr, j.rdatum RechDatum, jp.gegenkto AufwKto, substr(jp.bezeichnung, 1, 30) as rText, j.gegenkonto Kreditor, j.vrenum as BelegNrCAO from JOURNAL j join JOURNALPOS jp on jp.vrenum = j.vrenum join REGISTRY r on r.mainkey = 'MAIN\\MWST' and r.name = jp.steuer_code where (j.quelle = 5 and j.quelle_sub 2) and j.bsumme 0 and jp.gpreis 0 -- and j.rdatum = ? -- binding the date variable without formatting in SQL Statement makes problem. Is sent in german format, MySQL will not recognize as date and j.rdatum = str_to_date(?, '%d.%m.%Y') -- binding the date variable without formatting makes problem and j.rdatum = str_to_date(?, '%d.%m.%Y') order by BelegNrCAO access the Basic programm with the error Sub LiesEKPos (pDatumVon as date, pDatumBis as date) DatabaseContext = createUnoService(com.sun.star.sdb.DatabaseContext) DataSource = DatabaseContext.getByName(Adressen) 'DBNameOO If Not DataSource.IsPasswordRequired Then Connection = DataSource.GetConnection(,) Else InteractionHandler = createUnoService(com.sun.star.sdb.InteractionHandler) Connection = DataSource.ConnectWithCompletion(InteractionHandler) End If ' worksheet stuff Dim Doc As Object Dim Sheet As Object Dim Cell As Object 'MsgBox Doc = StarDesktop.CurrentComponent 'Doc = StarDesktop.CurrentComponent Doc = ThisComponent Sheet = Doc.Sheets.getByName(EkPos) ' Database stuff Dim ResultSet As Object Dim SQLText As String Dim resultCount as Integer Dim ColOffset as Integer Dim RowOffset as Integer Dim ErgebnisMonat as Integer ' EK Umsaetze SQLText = getNamedCellString (SQLEKPos) Statement = Connection.PrepareStatement(SQLText) Statement.SetString(1, pDatumVon ) ' does not work with plain ? in SQLText, see workaround above Statement.SetString(2, pDatumBis ) ResultSet = Statement.executeQuery() ColOffset = -1 ErgebnisMonat = 0 RowOffset = 1 '+ pRow resultCount = 0 If Not IsNull(ResultSet) Then While ResultSet.next 'select /* EK Pos */ round(jp.GPREIS * if(jp.brutto_flag = 'Y', 1, (100 + r.val_double) /100), 2) PosPreis, 'j.orgnum as LiefRechNr, 'j.rdatum RechDatum, 'jp.gegenkto AufwKto, 'substr(jp.bezeichnung, 1, 30) as rText, 'j.gegenkonto Kreditor, 'j.vrenum as BelegNrCAO from JOURNAL j join JOURNALPOS jp on jp.vrenum = j.vrenum join REGISTRY r on r.mainkey = 'MAIN\\MWST' and r.name = jp.steuer_code where (j.quelle = 5 and j.quelle_sub 2) and j.bsumme 0 and jp.gpreis 0 and j.rdatum = ? and j.rdatum = ? order by BelegNrCAO Cell = Sheet.getCellByPosition(ColOffset + 1, resultCount + RowOffset) Cell.Value = ResultSet.getString(1) Cell = Sheet.getCellByPosition(ColOffset + 2, resultCount + RowOffset) Cell.String = ResultSet.getString(2) Cell = Sheet.getCellByPosition(ColOffset + 3, resultCount + RowOffset) MsgBox ResultSet.DBG_methods '- has a method getDate Cell.String = ResultSet.getDate(3) ' - runtime error Cell = Sheet.getCellByPosition(ColOffset + 4, resultCount + RowOffset) Cell.Value = ResultSet.getString(4) Cell = Sheet.getCellByPosition(ColOffset + 5, resultCount + RowOffset) Cell.String = ResultSet.getString(5) Cell = Sheet.getCellByPosition(ColOffset + 6, resultCount + RowOffset
[dba-issues] [Issue 74374] Basic Runtime error: metho d getDate is missing
To comment on the following update, log in, then open the issue: http://www.openoffice.org/issues/show_bug.cgi?id=74374 User szodrow changed the following: What|Old value |New value Attachment data| |Created an attachment (id= | |42877) SQL Statement and B | |asic Code --- Additional comments from [EMAIL PROTECTED] Fri Feb 9 11:10:19 + 2007 --- Created an attachment (id=42877) SQL Statement and Basic Code - 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]
[framework-issues] [Issue 74375] read file with fixed recor d len, missing bytes, 2 bytes offset
To comment on the following update, log in, then open the issue: http://www.openoffice.org/issues/show_bug.cgi?id=74375 Issue #|74375 Summary|read file with fixed record len, missing bytes, 2 byte |s offset Component|framework Version|OOo 2.1 Platform|All URL| OS/Version|Windows XP Status|UNCONFIRMED Status whiteboard| Keywords| Resolution| Issue type|DEFECT Priority|P3 Subcomponent|scripting Assigned to|npower Reported by|szodrow --- Additional comments from [EMAIL PROTECTED] Fri Feb 9 12:45:28 + 2007 --- I have a DATEV file with fixed len records (256 Bytes) and want to read record by record (in OO Basic). I open it in Random mode with block len 256. The problem is that the first two bytes are skipped and all subsequent records have 2 bytes offset. I expected bytes rec 1: 1 - 256, rec 2: 257 - 512, etc, but I get rec 1: 3 - 258, rec 2: 259 - 514 Something similar happens when writing this files in Random mode: the first two bytes are away (I don't remember anymore, because writing the file in binary mode solves the problem) When reading the file in binary mode, the same applies. The first 2 bytes are missing. When I do a subsequent get with a Byte Position (e. g. 2560), again the first two bytes are missing (starts from 2562). Since I don't need the first two bytes, I can program a workaround (in attached file), but that is enerving. I tried, if this is a platform depending problem and did this also on Linux (OO 2.0, SuSE 9.3), but there the get command doesn't work at all (runtime error?!) - 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]
[framework-issues] [Issue 74375] read file with fixed recor d len, missing bytes, 2 bytes offset
To comment on the following update, log in, then open the issue: http://www.openoffice.org/issues/show_bug.cgi?id=74375 User szodrow changed the following: What|Old value |New value Attachment data| |Created an attachment (id= | |42878) Program file to Tes | |t the problem --- Additional comments from [EMAIL PROTECTED] Fri Feb 9 12:49:01 + 2007 --- Created an attachment (id=42878) Program file to Test the problem - 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]
[framework-issues] [Issue 74375] read file with fixed recor d len, missing bytes, 2 bytes offset
To comment on the following update, log in, then open the issue: http://www.openoffice.org/issues/show_bug.cgi?id=74375 User szodrow changed the following: What|Old value |New value Attachment data| |Created an attachment (id= | |42879) file with data to t | |est --- Additional comments from [EMAIL PROTECTED] Fri Feb 9 12:49:35 + 2007 --- Created an attachment (id=42879) file with data to test - 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]