질문하기

# mabra's profile - activity

 2016-03-20 11:41:46 +0200 받은 배지 ● 정리의 달인 2015-09-12 16:42:48 +0200 받은 배지 ● 주목할 만한 질문 (source) 2015-09-12 16:42:48 +0200 받은 배지 ● 유명한 질문 (source) 2015-07-12 07:57:10 +0200 받은 배지 ● 주목할 만한 질문 (source) 2015-07-12 07:57:10 +0200 받은 배지 ● 유명한 질문 (source) 2014-06-30 02:18:07 +0200 받은 배지 ● 인기있는 질문 (source) 2014-05-14 16:40:42 +0200 질문하였습니다 Cannot find the right SQL dialect: "case when" .. fails Hello ! Though I cannot make dependend fields working - have to omit a space, if one field contains null - so, I do not have to omit the filed itself. Cocatenating fields in the true/false fields for a condition does not work. So I thought, make a query/view and build the field completely in sql. So I have this: select "VORNAMEN,C,27" AS "VORNAMEN", "Sheet1"."NAMENSPREF,C,3" as "b", --see the data "Sheet1"."STRASSE,C,25" as "d", case when ("Sheet1"."NAMENSPREF,C,3" is not null) then "Name" = 'aa' else "Name" = 'bb' end  from Sheet1; But I am getting these errors: SQL Status: HY000 Error code: 1000 syntax error, unexpected \$end, expecting BETWEEN or IN or SQL_TOKEN_LIKE If I do the query like this: select "VORNAMEN,C,27" AS "VORNAMEN", "Sheet1"."NAMENSPREF,C,3" as "b", "Sheet1"."STRASSE,C,25" as "d", case when ("Sheet1"."NAMENSPREF,C,3" is not null) then 'aa' else 'bb' end as "Name"  from Sheet1; I get no data for the field, although I see, that this data exists. I hope to get a little help. I am using a ODB, which i made from ODS. I cannot find which dialect is right. BTW, I tried both, hitting F5 in the designer and using sql direct. Any help would be great. Thanks anyway and best regards, ++mabra 2014-02-22 04:34:52 +0200 받은 배지 ● 인기있는 질문 (source) 2014-02-16 17:04:53 +0200 질문에 답변하였습니다 [Impress]Looking for webbrowser control: Make a page active in presentation Hi ! Sorry, if I was not precise enough. I am looking for a control, which can be embedded, mostly in Impress, to show webpages. If I try to include an OLE object - under windows - the MS webbrowser control is not there. Ok, I really looking for that working with Linux too, this would speedup my migration. Having presentations with embedded live webpages would be much better than to start a separate webbrowser via embedded link. I hope, I am more clear now. Thanks anyway and best regards, mabra 2014-02-16 02:25:37 +0200 질문하였습니다 [Impress]Looking for webbrowser control: Make a page active in presentation Hello ! I was very impressed with Impress ;-) to see, that GIF animations are really working! In my last presentation, I refer to too many webpages and so, have to link to them/leaving Impress. I am not expecting a full webbrowser, but what could be probably done, is build a control. Just a wish. Now locking for anmimated svg ... Thanks anyway and best regards, mabra