Fai la tua domanda

bobde's profile - attività

2018-08-26 01:13:52 +0200 received badge  Entusiasta
2018-08-26 01:13:52 +0200 received badge  Entusiasta
2018-08-21 15:39:31 +0200 received badge  Domanda notevole (source)
2018-08-19 22:56:24 +0200 received badge  Domanda gettonata (source)
2018-08-19 21:25:34 +0200 ha risposto a una domanda Query design

Hi Ratslinger I'm trying to get information from a table that contains details on each member. what team each member is

2018-08-19 18:50:46 +0200 received badge  Domanda notevole (source)
2018-08-19 18:50:46 +0200 received badge  Domande famose (source)
2018-08-19 18:36:52 +0200 ha posto una domanda Query design

Query design I have a database with 900+ members. Each member is assigned to three teams with different positions on eac

2018-06-20 18:11:28 +0200 received badge  Domande famose (source)
2018-03-20 22:15:04 +0200 received badge  Domanda notevole (source)
2018-01-21 18:08:34 +0200 ha accettato una risposta Base settings

I click on tools > options > advanced > check " use java runtime......" click OK, the window closes.. I go back to the advanced window and " use java runtime....." is unchecked.. How do I fix this ?? I'm using 64bit LO V5.4.4.2 , JRE-8u162-windows-x64 , running as admin

Thanks Bob

2018-01-21 18:08:10 +0200 ha commentato una risposta Base settings

Thanks !! got it..Removed Java with Revouninstaller ( in advanced mode ) and then cleared the registry with ccleaner, re

2018-01-21 16:59:14 +0200 ha commentato una risposta Base settings

Yup.. exactly After restarting LO I go back to advanced and everything is unchecked and nothing is in the box.. Very Str

2018-01-21 15:31:04 +0200 ha commentato una risposta Base settings

OOps.. Running windows 10 pro.. I thought it might be a permissions issue so I tried it as admin.. Also I'm running xam

2018-01-21 15:30:44 +0200 ha commentato una risposta Base settings

OOps.. Running windows 10 pro.. I thought it might be a permissions issue so I tried it as admin.. Also I'm running xam

2018-01-21 15:02:52 +0200 received badge  Domanda gettonata (source)
2018-01-21 04:54:30 +0200 ha commentato una risposta Base settings

Thanks for the quick answer.. but no joy... I downloaded and installed the latest JRE, and rebooted.. When I click " us

2018-01-21 04:04:43 +0200 ha posto una domanda Base settings

Base settings I click on tools > options > advanced > check " use java runtime......" click OK, the window clos

2018-01-20 16:52:51 +0200 ha accettato una risposta Can not add JRE to 5.4

I am trying to install java in libreoffice 5.4.4 . I go to tools , advanced , check use java runtime , add the jar file click ok, again ok, restart libreoffice and try to get into my database and get

No SDBC driver found... soooo I go back to tools, advanced, and find everything unchecked. Is there anyway to add JRE to 5.4.4 ?? Bob

2018-01-20 01:47:55 +0200 received badge  Domanda notevole (source)
2018-01-18 13:04:11 +0200 received badge  Domanda gettonata (source)
2018-01-15 17:42:54 +0200 ha commentato una domanda Can not add JRE to 5.4

I'm on windows 10 64bit running LO 5.4.4.2 64bit using JRE-9.0.1.. Now when I go to tools - advanced - check use java ru

2018-01-15 17:22:04 +0200 ha risposto a una domanda Can not add JRE to 5.4

I'm on windows 10 64bit running LO 5.4.4.2 64bit using JRE-9.0.1.. Now when I go to tools - advanced - check use java ru

2018-01-15 04:51:21 +0200 ha posto una domanda Can not add JRE to 5.4

Can not add JRE to 5.4 I am trying to install java in libreoffice 5.4.4 . I go to tools , advanced , check use java run

2017-12-25 21:11:18 +0200 received badge  Domanda gettonata (source)
2017-12-25 03:08:28 +0200 ha commentato una risposta How do you search several fields

Thank You !! That's perfect .. Again Thanks Bob

2017-12-25 03:07:13 +0200 ha accettato una risposta How do you search several fields

I'm new at this.. I'm trying to search across three fields . The only way I've been able to do this is to input the value 3 times. I'd like to be able to search the three fields with one input.. Is that possible Here is what I've got.. SELECT "RosterInfo"."Team", "RosterInfo"."Team2", "RosterInfo"."Team3", "RosterInfo"."RosterID", "RosterInfo"."Position", "memberPersonalInfo"."Phone_Number", "memberPersonalInfo"."First_Name", "memberPersonalInfo"."Last_Name", "memberPersonalInfo"."Notes", "RosterInfo"."Status" FROM "security"."rosterinfo" AS "RosterInfo", "security"."memberpersonalinfo" AS "memberPersonalInfo" WHERE "RosterInfo"."RosterID" = "memberPersonalInfo"."RosterID" AND ( "RosterInfo"."Team" = ? OR "RosterInfo"."Team2" = ? OR "RosterInfo"."Team3" = ? )

Thanks Bob

2017-12-25 02:13:08 +0200 ha posto una domanda How do you search several fields

How do you search several fields I'm new at this.. I'm trying to search across three fields . The only way I've been abl

2017-12-25 01:53:05 +0200 received badge  Domande famose (source)
2017-12-25 01:53:05 +0200 received badge  Domanda notevole (source)
2017-08-22 16:07:14 +0200 ha commentato una risposta Boolean value

Thank You.. I think I got it .. I've got the search form working.. Thanks Again Bob

2017-08-22 16:05:49 +0200 ha accettato una risposta Boolean value

First I new at this.. I'm following a tutorial from the frugal computer guy on building a filter for a search form. Created the table, entered the first field no problems.. Tried to enter a field type as boolean ( Yes/No[BOOL] ) set the length to 1 and default value to no.. Save the table and the field type changes to Tiny Integer [TINYINT] , length to 3 and default value to false..

Am I doing something wrong or is this a bug ??

Thanks Bob

2017-08-22 14:55:16 +0200 received badge  Domanda gettonata (source)
2017-08-22 14:20:17 +0200 ha commentato una risposta Boolean value

No joy.. Set the length to 0 and as soon as I save it the length changes to 3 Is there a config file for the fields type

2017-08-22 04:00:13 +0200 ha posto una domanda Boolean value

Boolean value First I new at this.. I'm following a tutorial from the frugal computer guy on building a filter for a sea

2017-08-02 03:25:03 +0200 ha accettato una risposta Foreign key constraint is incorrectly formed

I hope someone can help me with this.. ( I'm very new at base ) As a test, I created two tables, both with a clientID field, consecutive numbers in each field, both set as primary keys, both field types the same, both field names exactly the same. When I tried to relate the two tables I get Can't create table security.#sql-19c4_f4 (errno: 150 "Foreign key constraint is incorrectly formed") So I deleted the data in both tables and with two empty tables tried to relate the two fields and got the same error message

Thanks

Bob

2017-08-02 03:25:03 +0200 received badge  Studioso (source)
2017-07-30 23:25:08 +0200 received badge  Domanda gettonata (source)
2017-07-30 15:56:00 +0200 ha posto una domanda Foreign key constraint is incorrectly formed

Foreign key constraint is incorrectly formed I hope someone can help me with this.. ( I'm very new at base ) As a test,