[dba-issues] [Issue 77175] Substring autoformat in ba se gives sql error
To comment on the following update, log in, then open the issue: http://www.openoffice.org/issues/show_bug.cgi?id=77175 User clu changed the following: What|Old value |New value Status|RESOLVED |CLOSED --- Additional comments from [EMAIL PROTECTED] Tue Oct 23 08:16:57 + 2007 --- => 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: [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 77175] Substring autoformat in ba se gives sql error
To comment on the following update, log in, then open the issue: http://www.openoffice.org/issues/show_bug.cgi?id=77175 User clu changed the following: What|Old value |New value Status|UNCONFIRMED |RESOLVED Resolution| |INVALID --- Additional comments from [EMAIL PROTECTED] Tue Oct 23 08:16:23 + 2007 --- clu->tlkhorses: that is no bug, because the design view is pretty limited in picturing sql statements - there are near endless possibilities (hundreds of different drivers and databases) that cannot be interpreted all, at the current state :( - 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 77175] Substring autoformat in ba se gives sql error
To comment on the following update, log in, then open the issue: http://www.openoffice.org/issues/show_bug.cgi?id=77175 --- Additional comments from [EMAIL PROTECTED] Thu Sep 6 23:15:11 + 2007 --- I also get the same thing with the following query: Select InstallTimes.TIME, InstallTimes.Username, InstallTimes.CustomerID, InstallTimes.Status, Customer.Firstname, Customer.LastName FROM InstallTimes, Customer Where InstallTimes.Status IS NOT NULL AND InstallTimes.Time BETWEEN '2007-08-01 00:00:00' AND '2007-09-01 00:00:00' AND InstallTimes.CustomerID = Customer.CustomerID ORDER BY InstallTimes.Status, InstallTimes.Time; Works when run directly but syntax error when trying to go to design view. - 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 77175] Substring autoformat in ba se gives sql error
To comment on the following update, log in, then open the issue: http://www.openoffice.org/issues/show_bug.cgi?id=77175 --- Additional comments from [EMAIL PROTECTED] Thu Sep 6 23:12:28 + 2007 --- Ok, I misunderstood. Just fyi we have since upgraded to mysql 4.1.20 with same results. I did run the sql query directly and that worked. In design view I get the sql error mentioned. - 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 77175] Substring autoformat in ba se gives sql error
To comment on the following update, log in, then open the issue: http://www.openoffice.org/issues/show_bug.cgi?id=77175 User clu changed the following: What|Old value |New value Keywords| |needmoreinfo --- Additional comments from [EMAIL PROTECTED] Mon Sep 3 14:34:09 + 2007 --- cannot be the same result, because you cannot switch in design view if you run sql directly (i meant, does the sql string work then?) - i am a little bit confused - what exactly is the problem: 1. by switching into design view you get the sql error => the ui cannot interprete your sql string 2. your sql string does work over console, but not in oo base (even if you switch on 'run sql directly') -> sounds like a driver 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]
[dba-issues] [Issue 77175] Substring autoformat in ba se gives sql error
To comment on the following update, log in, then open the issue: http://www.openoffice.org/issues/show_bug.cgi?id=77175 --- Additional comments from [EMAIL PROTECTED] Tue Jun 26 15:42:59 + 2007 --- Yes, with the same results. - 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 77175] Substring autoformat in ba se gives sql error
To comment on the following update, log in, then open the issue: http://www.openoffice.org/issues/show_bug.cgi?id=77175 --- Additional comments from [EMAIL PROTECTED] Tue Jun 26 15:34:19 + 2007 --- have you tried out the 'run sql directly' button? - 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 77175] Substring autoformat in ba se gives sql error
To comment on the following update, log in, then open the issue:
http://www.openoffice.org/issues/show_bug.cgi?id=77175
Issue #|77175
Summary|Substring autoformat in base gives sql error
Component|Database access
Version|OOo 2.1
Platform|Macintosh
URL|
OS/Version|All
Status|UNCONFIRMED
Status whiteboard|
Keywords|
Resolution|
Issue type|DEFECT
Priority|P3
Subcomponent|none
Assigned to|dbaneedsconfirm
Reported by|tlkhorses
--- Additional comments from [EMAIL PROTECTED] Thu May 10 00:32:54 +
2007 ---
I am using an old version of MySQL, 3.x, and am unable to update it due to the
programs populating it. I am trying to use Base to query it. Below is part of
a thread I have running in the base forum:
I ran the following in console and it worked:
select
Customer.customerid,Customer.lastname,Customer.firstname,Customer.status,CustomerEventLog.username,
substring(CustomerEventLog.Text,(locate('-',CustomerEventLog.Text)+1),2),
substring(CustomerEventLog.Text,(locate('@',CustomerEventLog.Text)+1),2),
substring(CustomerEventLog.Text,(locate('sec',CustomerEventLog.Text)-3),7),
InstallTimes.username, InstallTimes.status from Customer, CustomerEventLog,
InstallTimes where CustomerEventLog.time > 20070401 and CustomerEventLog.subject
like '%survey%' and locate('@',CustomerEventLog.Text)>0 and Customer.customerid
= CustomerEventLog.customerid and Customer.customerid = InstallTimes.customerid
order by CustomerEventLog.customerid, CustomerEventLog.time, InstallTimes.time;
If I run the following in console I get the same error as my initial post here:
SELECT `Customer`.`CustomerID`, `Customer`.`LastName`, `Customer`.`FirstName`,
`Customer`.`Status`, `CustomerEventLog`.`Username`, SUBSTRING (
`CustomerEventLog`.`Text`, ( LOCATE( '-', `CustomerEventLog`.`Text` ) + 1 ), 2
), SUBSTRING ( `CustomerEventLog`.`Text`, ( LOCATE( '@',
`CustomerEventLog`.`Text` ) + 1 ), 2 ), SUBSTRING ( `CustomerEventLog`.`Text`, (
LOCATE( 'sec', `CustomerEventLog`.`Text` ) - 3 ), 7 ),
`InstallTimes`.`Username`, `InstallTimes`.`Status`, `CustomerEventLog`.`Time`,
`CustomerEventLog`.`CustomerID`, `InstallTimes`.`Time` FROM
`powernoc`.`Customer`, `powernoc`.`CustomerEventLog`, `powernoc`.`InstallTimes`
WHERE ( `Customer`.`CustomerID` = `CustomerEventLog`.`CustomerID` AND
`Customer`.`CustomerID` = `InstallTimes`.`CustomerID` ) AND ( (
`CustomerEventLog`.`Time` > {D '2007-04-01' } AND `CustomerEventLog`.`Subject`
LIKE '%survey%' AND LOCATE( '@', `CustomerEventLog`.`Text` ) > '0' ) ) ORDER BY
`CustomerEventLog`.`Time` ASC, `CustomerEventLog`.`CustomerID` ASC,
`InstallTimes`.`Time` ASC;
If I try to put the first select into base and go to design view I get sql
error.
If I try to paste the first select here into the base sql I get sql error (and
thats all) when I try to switch to design view.
In the second SELECT above if I remove the space between SUBSTRING and the (
then that one works also in console. However, trying to put it into base query,
it automatically inserts that space back into it therefore it will not work.
tk
-
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]
