Ask Your Question

kasloman's profile - activity

2019-02-14 17:44:14 +0200 commented answer How To: Decrypting MSQL Fields

Many thanks. Worked like a charm changing "myPW" to 'myPW' in single quotes. R

2019-02-14 10:58:32 +0200 received badge  Popular Question (source)
2019-02-14 08:03:49 +0200 edited answer How To: Decrypting MSQL Fields

I am connected to a MySql database. SELECT "IDno", "Company", cast(DES_DECRYPT("AccountNo", "myPW")AS char(50)) AS "Ac

2019-02-14 08:02:34 +0200 received badge  Editor (source)
2019-02-14 08:02:34 +0200 edited answer How To: Decrypting MSQL Fields

SELECT "IDno", "Company", cast(DES_DECRYPT("AccountNo", "myPW")AS char(50)) AS "AccountNo" FROM "account"; Returns - "T

2019-02-14 07:19:20 +0200 answered a question How To: Decrypting MSQL Fields

Yes, I got OBJECT returned also. I didn't know what to do with it though. I'll try this cast.

2019-02-14 02:29:26 +0200 received badge  Famous Question (source)
2019-02-14 02:01:31 +0200 asked a question How To: Decrypting MSQL Fields

How To: Decrypting MSQL Fields I have this MySql query: SELECT IDno, Company, des_decrypt(AccountNo, "myPassWord") AS '

2019-02-12 06:05:17 +0200 received badge  Popular Question (source)
2019-02-12 02:49:56 +0200 answered a question How do you name a header or footer for future use in another document

Thanks much. I'll look up templates. R

2019-02-11 23:54:01 +0200 asked a question How do you name a header or footer for future use in another document

How do you name a header or footer for future use in another document It seems to me that there ought to be a way to nam

2019-01-20 19:10:03 +0200 received badge  Famous Question (source)
2018-03-15 18:42:55 +0200 received badge  Notable Question (source)
2018-02-22 21:20:20 +0200 received badge  Famous Question (source)
2018-01-22 02:00:05 +0200 received badge  Popular Question (source)
2018-01-09 18:11:03 +0200 commented question how to repeat group header if group goes over one page

Did I phrase this question wrong?? If so someone let me know and I will try to re-phrase it. Thanks, R

2018-01-07 21:38:00 +0200 received badge  Notable Question (source)
2018-01-07 00:49:49 +0200 received badge  Enthusiast
2018-01-06 22:59:09 +0200 asked a question how to repeat group header if group goes over one page

how to repeat group header if group goes over one page i've set up a group header but it will not repeat the header labe

2017-12-24 12:08:15 +0200 received badge  Popular Question (source)
2017-12-22 22:38:13 +0200 answered a question Get Subtotal of a column in Detail area

Thanks Ratslinger, I added group header and footer where the footer contained subtotal and page header and footer where

2017-12-22 18:00:30 +0200 asked a question Get Subtotal of a column in Detail area

Get Subtotal of a column in Detail area OK, I've got the grand total in the Page Footer of my Report by using a text box

2017-12-22 08:51:31 +0200 received badge  Student (source)
2017-12-22 06:11:47 +0200 received badge  Popular Question (source)
2017-12-22 00:30:31 +0200 commented answer BASE REPORT WRITER How to add the Total of a column in footer

Thanks much, I now see what a text box can do!! R

2017-12-21 22:10:23 +0200 asked a question BASE REPORT WRITER How to add the Total of a column in footer

BASE REPORT WRITER How to add the Total of a column in footer I am basing a report on a number of fields, some of which

2017-12-21 00:00:57 +0200 received badge  Notable Question (source)
2017-12-20 17:44:07 +0200 edited answer Can't get Report to execute due to errors

Thanks, I am running Ubuntu MATE 16.04 with MariaDb - Server version: 10.0.31-MariaDB-0ubuntu0.16.04.2 Ubuntu 16.04 My

2017-12-20 16:50:11 +0200 answered a question Can't get Report to execute due to errors

Thanks, I am running Ubuntu MATE 16.04 with MariaDb - Server version: 10.0.31-MariaDB-0ubuntu0.16.04.2 Ubuntu 16.04 My

2017-12-20 03:57:34 +0200 received badge  Popular Question (source)
2017-12-20 00:06:07 +0200 answered a question Can't get Report to execute due to errors

The following are images of the report written in the wizard based on subject query

2017-12-19 18:11:26 +0200 asked a question Can't get Report to execute due to errors

Can't get Report to execute due to errors This query works in queries but using it in a report produces all kinds of err

2017-12-19 01:00:50 +0200 marked best answer connect calc to registered db

Hi, I've created a MySql database and then used LOBase to connect to it. It shows the tables correctly. How can I connect a LOcalc sheet to this registered db?.

One site , [Tutorial] Using registered datasources in Calc, I visited says: "In Calc hit F4, browse your database and drag the table (or a query for the same purpose) from the left pane onto a cell."* Pressing F4 puts up a box saying LibreOffice 5.4.3.2 No cell references are found in the selected cells.

2017-12-19 01:00:49 +0200 received badge  Scholar (source)
2017-12-18 22:38:35 +0200 asked a question connect calc to registered db

connect calc to registered db Hi, I've created a MySql database and then used LOBase to connect to it. It shows the tab