Pergunte aqui

Perfil de MQ-818 - atividade

2019-10-07 06:58:49 +0200 Medalha recebida  Pergunta popular (fonte)
2019-10-07 02:26:11 +0200 Resposta comentada Split Base DB. Field is Decimal. Decimal places was 2, now it's 0??? How to fix it!!!

Got it Thanks for your help!

2019-10-07 02:11:42 +0200 Resposta comentada Split Base DB. Field is Decimal. Decimal places was 2, now it's 0??? How to fix it!!!

I think this is where I went wrong!!! 1) I added new fields on an existing table (Not a problem) 2) My last few number

2019-10-07 01:38:17 +0200 Resposta editada Split Base DB. Field is Decimal. Decimal places was 2, now it's 0??? How to fix it!!!

Looks like I can use SQL command One field at a time. But if you have a better approach, please share it. Thanks! ALTER

2019-10-07 01:36:55 +0200 Respondeu uma pergunta Split Base DB. Field is Decimal. Decimal places was 2, now it's 0??? How to fix it!!!

Looks like I can use SQL command One field at a time. But if you have a better approach, please share it. Thanks! ALTER

2019-10-07 01:34:16 +0200 Pergunta editada Split Base DB. Field is Decimal. Decimal places was 2, now it's 0??? How to fix it!!!

Split Base DB. Field is Decimal. Decimal places was 2, now it's 0??? How to fix it!!! Hi, For several years I am using

2019-10-07 01:31:48 +0200 Resposta editada Im having a problem with Base app. I cant get it to work. It keeps asking for JRE. I installed it from Java, but its still doesnt work.

Use Split-DB. It's very reliable. Please check UNDER: Tools >> Options >>Advanced >> Java Options //

2019-10-07 01:27:27 +0200 Pergunta comentada Split Base DB. Field is Decimal. Decimal places was 2, now it's 0??? How to fix it!!!

1) DataBase Version: Version: 6.2.7.1 (x64) Build ID: 23edc44b61b830b7d749943e020e96f5a7df63bf CPU threads: 8; OS: Wind

2019-10-07 00:48:22 +0200 Respondeu uma pergunta Im having a problem with Base app. I cant get it to work. It keeps asking for JRE. I installed it from Java, but its still doesnt work.

Use Split-DB. It's very reliable.

2019-10-07 00:41:06 +0200 Perguntou Split Base DB. Field is Decimal. Decimal places was 2, now it's 0??? How to fix it!!!

Split Base DB. Field is Decimal. Decimal places was 2, now it's 0??? How to fix it!!! Hi, For several years I am using

2019-07-26 08:17:19 +0200 Medalha recebida  Autodidata (fonte)
2017-09-17 16:32:44 +0200 Medalha recebida  Pergunta famosa (fonte)
2016-11-17 02:27:21 +0200 Resposta comentada Base DB opens as write document

I learned a way to connect LOBase to MySQL. (ODBC Unicode Driver)

Would it prevent me from this type of head ache? Please advice!!!

2016-11-16 21:28:09 +0200 Pergunta comentada Base DB opens as write document

I don't know any backup.... Do you know where to find backup? Is there a way to setup for auto backup?

2016-11-16 21:27:20 +0200 Resposta comentada Base DB opens as write document

Thanks for getting back. Is there any youtube video that I can follow ? or Is it possible to have (1,2,3 type) step by step easy to follow guide?

Sorry novice user here.

2016-11-16 00:25:59 +0200 Medalha recebida  Pergunta notável (fonte)
2016-11-15 08:04:35 +0200 Medalha recebida  Pergunta popular (fonte)
2016-11-14 19:51:02 +0200 Perguntou Base DB opens as write document

I am so disappointed. Everything worked two days ago. Today I need some information and my BASE DB is opening as Write document. It even asked me if I would like to fix it....I choose YES. Now what? Please help me...

Version: 5.1.4.2 Build ID: f99d75f39f1c57ebdd7ffc5f42867c12031db97a CPU Threads: 2; OS Version: Windows 6.2; UI Render: default; Locale: en-US (en_US)

Thanks in advance. Monjur

2016-03-21 21:38:18 +0200 Medalha recebida  Pergunta famosa (fonte)
2016-02-21 08:47:31 +0200 Medalha recebida  Pergunta famosa (fonte)
2016-02-20 20:21:55 +0200 Marcada como a melhor resposta How to create an Update query in BASE SQL

SYNTAX: UPDATE table SET column = Expression [, ...] [WHERE Expression];

UPDATE "tblMainCustInfo" SET "Cell_Phone1_Name" = 'Some text' WHERE "Cell_Phone1_Name" IS NULL

I tried this but NO GO....!!!!

Not sure how to solve this.

FYI: I am super new in SQL; so please be patient with me.

Thanks in Advance.

2016-01-08 20:51:56 +0200 Medalha recebida  Pergunta famosa (fonte)
2015-10-05 01:09:48 +0200 Medalha recebida  Pergunta notável (fonte)
2015-10-05 01:09:48 +0200 Medalha recebida  Pergunta famosa (fonte)
2015-09-14 10:53:22 +0200 Medalha recebida  Pergunta famosa (fonte)
2015-08-18 19:08:42 +0200 Marcada como a melhor resposta base text_date_field to Base_Date_field Update/Convertion

Hi, I have a base table, where there is valid dates (fldBirthDateOLD) but the field type is Varchar/Text. I need this field (fldBirthDateOLD)to be Date Field (fldBirthDateNEW). I am not sure how to do this, since Update SQL stop's due to data type mismatch.

I have a feeling there is something very simple that I am missing that I can add to my SQL, so TEXT date can be converted and update into the correct DATE filed.

UPDATE "tblBirthDayDetail" SET "fldBirthDateNEW" = "fldBirthDateOLD"

Thanks in advance for your kind input and teaching.

2015-06-12 22:03:58 +0200 Medalha recebida  Pergunta notável (fonte)
2015-06-12 22:03:58 +0200 Medalha recebida  Pergunta popular (fonte)
2015-06-08 08:00:51 +0200 Medalha recebida  Pergunta notável (fonte)
2015-06-08 08:00:51 +0200 Medalha recebida  Pergunta popular (fonte)
2015-05-22 03:30:21 +0200 Medalha recebida  Pergunta notável (fonte)
2015-05-06 15:23:20 +0200 Medalha recebida  Pergunta popular (fonte)
2015-04-20 04:54:05 +0200 Resposta comentada How to Hide/Unhide Field(s) on a Base Form or a SubForm

How do I upload/attach/send my ODB file for you?

I need to have FIELD level control. So, that I can Hide/UnHide based on user needs FIELDS

2015-04-19 17:01:00 +0200 Medalha recebida  Editor (fonte)
2015-04-19 16:56:43 +0200 Perguntou How to Hide/Unhide Field(s) on a Base Form or a SubForm

I am in need of this control. Since LOBase doesn't have TAB like Access does; So I am thinking have Push Buttons on the top underneath set of fields from different subforms. Issue is too many fields to display at the same time; so I would like to hide the once aren't needed at the present stage of the user flow. Here is an example:

  • I have buttons for ADDRESS, CONTACT,NOTEs etc.
  • So when pressed Address_Button, only subForm_Address will be visible on the MainForm. CONTACT subForm and NOTEs SubForm will be non-Visible.
  • After lot of Google; I found following set of code which will control the background color of a field; now I need to access the property of Visible to set it to be True/False

    Dim oForm As Object, oTempAdd1 As Object

    oForm=oEvent.Source.Model.Parent REM CODE BOUND TO FORM BUTTON

    oTempAdd1= oForm.getByName("txtAdd1")

    tempColor = oTempAdd1.Background

    oTempAdd1.BackgroundColor = "255"

Thanks in advance for your TEACHING!!!

`

2015-04-04 04:00:36 +0200 Pergunta comentada Update DATA between two tables

Where do I check my HSQLDB version. I am running Windows 8.1 Pro / 64bit LibreOffice Base Version: 4.4.1.2 Build ID: 45e2de17089c24a1fa810c8f975a7171ba4cd432 Locale: en_US

I changed it to IF EXISTS and gave me error saying if in IF statement....So, I changed it back to WHERE EXISTS and took a change and WORKED .... !!! I tried it three different times and every time it worked just the way original code was. Not sure why it didn't run the other day; when I posted the message...

THANKS DOUG

2015-04-04 03:21:16 +0200 Resposta comentada base text_date_field to Base_Date_field Update/Convertion

Doug: Thanks for being such a good sportsman. Believe it or not after all these I still wasn't able to execute your code. Just bothering me. I was wondering Is there a way if I could email or upload the table for you to see where I am going wrong?

Thanks- Monjur MonjurQ@hotmail.com

2015-04-01 07:08:49 +0200 Respondeu uma pergunta Writer: Is there some way to fly to a particular page in a document?
Insert Bookmark

Inserts a bookmark at the cursor position. You can then use the Navigator to quickly jump to the marked location at a later time. In an HTML document, bookmarks are converted to anchors that you can jump to from a hyperlink.

To access this command... Choose Insert - Bookmark Open Insert toolbar, click

Bookmark

To jump to a specific bookmark, press F5 to open the Navigator, click the plus sign (+) next to the Bookmark entry, and then double-click the bookmark. You can also right-click the Page Number field at the left end of the Status Bar at the bottom of the document window, and then choose the bookmark that you want to jump to. Bookmarks Type the name of the bookmark that you want to create. The lower list contains all of the bookmarks in the current document. To delete a bookmark, select it in the list, and then click Delete. You cannot use the following characters in a bookmark name: / \ @ : * ? " ; , . # Delete To delete a bookmark, select the bookmark from the Insert Bookmark dialog and click the Delete button. No confirmation dialog will follow.

2015-04-01 07:01:58 +0200 Perguntou Update DATA between two tables

So I have two tables; tblAppDetail and tblMainCustInfo. I need to update one column (Appt_Sidemark) between these two tables. tblApptDetail has field called: Appt_Sidemark and tblMainCustInfo has field called: Sidemark. These two tables has CustID Linked. When I try the following SQL, I am getting

1: Unexpected token:   in statement [update "tblApptDetail" set "tblApptDetail"."Appt_Sidemark" =]

Here is what I am running at TOOLS-->SQL update "tblApptDetail" set "tblApptDetail"."Appt_Sidemark" =  (select "tblMainCustInfo"."Sidemark" from "tblMainCustInfo" where "tblApptDetail"."CustID" = "tblMainCustInfo"."CustID") where exists (select "tblMainCustInfo"."Sidemark" from "tblMainCustInfo" where "tblApptDetail"."CustID" = "tblMainCustInfo"."CustID")

I know it is me....just not smart enough to figure it out by myself. So your kind help is greatly appreciated.

2015-04-01 06:52:06 +0200 Resposta comentada base text_date_field to Base_Date_field Update/Convertion

I still can't run it.....Can you please help me to run it. I know it sounds stupid, that it is working in your machine but I can't run it.

So my TEXT table has them as VARCHAR what looks like MM/DD/YYYY and my new table with DATE format MM/DD/YYYY.

Lets make life simpler for me; use these names for SQL PLEASE... table1 , fldTxtDATE , fldDATE

2015-04-01 05:48:25 +0200 Medalha recebida  Pergunta notável (fonte)
2015-03-31 15:55:41 +0200 Resposta comentada base text_date_field to Base_Date_field Update/Convertion

It is VARCHAR. Format is MM/DD/YYYY.

Thanks for your help and continued support.

2015-03-31 09:10:38 +0200 Resposta comentada base text_date_field to Base_Date_field Update/Convertion

THIS ONE ACTUALLY WORKED.....JUST COPY THE TABLE TO CALC AND FORMAT EACH COLUMN TO DATE (IF YOU HAVE A TIME FIELD THAT REQUIRES CHANGE FROM TEXT TO TIME THEN TAKE CARE OF IT WHILE YOU ARE AT IT) THEN COPY & PASTE TO BASE AS A NEW TABLE....BUT MANUALLY DO THIS PROCESS....GO STEP BY STEP AND MAKE SURE YOU CHOOSE THE NEW TABLE WITH CORRECT FIELD TYPE...THIS WAS A QUICK AND EASY FIX