Database Discussion Boards

Re: ms access 2016 database

Richard MacCutchan2-Jul-17 22:44

2-Jul-17 22:44

Yes it will, you just need to click your mouse to the left of the item you want to download. If it still does not work, then you need to complain to Microsoft.

Re: ms access 2016 database

jschell5-Jul-17 6:40

jschell

5-Jul-17 6:40

To be fair, I tried that link myself, and it failed for me, presumably in the same way as for the OP. (I was wondering how it could be so hard.)

Turns out there is a hidden check box or button just to the left of the files.

Re: ms access 2016 database

Richard MacCutchan5-Jul-17 7:51

Richard MacCutchan

5-Jul-17 7:51

Yes it took me a while to figure out the how to do it. But it is Microsoft of course.

Re: ms access 2016 database

Mayank Kumar2-Jul-17 22:46

Mayank Kumar

2-Jul-17 22:46

by clicking on the link that u provided m taking to the download page and when i click on download then it takes me to file selection option but m not able to slelec any file there

Re: ms access 2016 database

jschell5-Jul-17 6:43

jschell

5-Jul-17 6:43

I just tried it. It didn't seem to work for me either.

It is a really weird screen.

If you click just to the left of the two files listed a 'box' will appear. It is just white space until you click on it. The box will disappear once your mouse moves away. However once selected the text box to the right will say that you have selected a file (or two) and the 'Next' button at the bottom of the screen will be highlighted.

Re: ms access 2016 database

Richard Deeming5-Jul-17 7:54

Richard Deeming

5-Jul-17 7:54

It must be your browser. The checkboxes appear and work fine for me in Firefox 54. Smile | :)

"These people looked deep within my soul and assigned me a number based on the order in which I joined."
- Homer

Re: ms access 2016 database

Richard MacCutchan5-Jul-17 21:56

Richard MacCutchan

5-Jul-17 21:56

I tried this (and another similar Microsoft page) in both Chrome and Edge, and the checkboxes did not show up in either.

Re: ms access 2016 database

Richard Deeming6-Jul-17 0:58

Richard Deeming

6-Jul-17 0:58

That's very odd. The checkboxes show up fine for me in Firefox, Chrome (v59), Chrome Canary (v61), Edge (v40.15063.0.0), IE11 (v11.413.15063.0), and Opera (v46).

"These people looked deep within my soul and assigned me a number based on the order in which I joined."
- Homer

Re: ms access 2016 database

Richard MacCutchan6-Jul-17 1:19

Richard MacCutchan

6-Jul-17 1:19

Even odder, they now show up for me on both the pages I was trying the other day. I suspect a recent web update.

Re: ms access 2016 database

jschell10-Jul-17 4:18

jschell

10-Jul-17 4:18

They now show up for me also.

Re: ms access 2016 database

jschell10-Jul-17 4:16

jschell

10-Jul-17 4:16

Richard Deeming wrote:
The checkboxes appear and work fine for me in Firefox 54

Mine is Firefox 54.0.1

Something odd I just noted however - it says 32 bit. My box is 64 bit.

Re: ms access 2016 database

Richard Deeming10-Jul-17 4:39

Richard Deeming

10-Jul-17 4:39

AFAIK, the default download for Firefox is 32-bit, even if you're on a 64-bit OS. You have to click on the "Firefox for Other Platforms & Languages" button to get the 64-bit version.

"These people looked deep within my soul and assigned me a number based on the order in which I joined."
- Homer

Trying to replace local file links with actual file contents

J Snape2-Jul-17 19:53

J Snape

2-Jul-17 19:53

I've been trying to do this for while and haven't made any progress.

I have a tab-delimited file with records for a database file. One of the fields has a local file link for a text file. Each record points to a different text file and there are 151,806 rows, so replacing the file names ("C:\files\LAW_SECTION_TBL_1.lob", "C:\files\LAW_SECTION_TBL_2.lob", ..., "C:\files\LAW_SECTION_TBL_151806.lob") one-by-one with the file text will take a decade or so. The .lob files are utf-8 plain text files.

I'd like to load the text files into the individual records as I insert all the data, but I'm not sure how to do it. The file I have to load it into MySQL has the following lines (shortened to essentials only):

...
  ,HISTORY
  ,@var1      // Where the "C:\files\LAW_SECTION_TBL_1.lob" is stored
  ,ACTIVE_FLG
  ,TRANS_UID
  ,TRANS_UPDATE
)
SET CONTENT_XML=LOAD_FILE(concat('c:\\files\\',@var1))

I just don't know how to do it for MS SQL Server. Any help or links to webpages that will help me write this INSERT statement are extremely appreciated!

Re: Trying to replace local file links with actual file contents

J Snape3-Jul-17 19:51

J Snape

3-Jul-17 19:51

I figured it out in Excel using the following code on a macro:

Sub Button1_Click()
    Dim TextFile As Integer
    Dim FilePath As String
    Dim FileContent As String
    
    Dim i As Long
    For i = 2 To 151807
        
        FilePath = "C:\pubinfo\" & Cells(i, 8).Value
        
            TextFile = FreeFile
            Open FilePath For Input As TextFile
            FileContent = Input(LOF(TextFile), TextFile)
            Close TextFile
            
        FileContent = Right(FileContent, Len(FileContent) - 74)
        FileContent = Left(FileContent, Len(FileContent) - 15)
        
        Cells(i, 9).Value = FileContent
    Next i
    
End Sub

It took about two hours to pull in all the text, by the way!

Re: Trying to replace local file links with actual file contents

jschell5-Jul-17 6:51

jschell

5-Jul-17 6:51

Just noting....

"lob", from the file name suggests binary data.

In general, programming languages differentiate between binary and text data.

Your code used a "String" type.

That works under one or both of the following conditions.
1. The files wear in fact text
2. Excel did not attempt to translate them.

You can validate the above by exporting at least one file and verifying that it matches the input both in length and content.

How do I get all the Ids from my last insert in Mysql?

karengsh27-Jun-17 18:05

karengsh

27-Jun-17 18:05

Hi,

I am using MySQL.

Can someone tell me how to write the sql query for retrieving all the last inserted Ids (plural) ?

I have a table in which a column has been inserted by serveral rows everytime depending on how many subject the users tick in the checkboxes.

Now, I have to get all the auto-incremental Ids from all the Ids that have just been inserted.

Is there a way to do it via sql query ?

Re: How do I get all the Ids from my last insert in Mysql?

Richard MacCutchan27-Jun-17 19:54

Richard MacCutchan

27-Jun-17 19:54

If you know the number of rows that you want: Mysql: Select top N max values? - Stack Overflow[^].

Re: How do I get all the Ids from my last insert in Mysql?

karengsh27-Jun-17 21:07

karengsh

27-Jun-17 21:07

Hi Richard,

I won't be able to know because each time the subject_Ids varies, it is dependent on the user's no of checkboxes that have been ticked.

So, how ?

Re: How do I get all the Ids from my last insert in Mysql?

Richard MacCutchan28-Jun-17 8:51

Richard MacCutchan

28-Jun-17 8:51

You will have to use some other logic to find out how many new records have been added. Possibly by finding the highest ID number before you start.

Re: How do I get all the Ids from my last insert in Mysql?

Richard Deeming27-Jun-17 23:51

Richard Deeming

27-Jun-17 23:51

In MS SQL Server, you'd use the OUTPUT clause. Unfortunately, there doesn't seem to be an equivalent for MySQL.

Selecting the top N rows won't work - another user might have inserted rows between your INSERT and SELECT statements. That's why the LAST_INSERT_ID function exists.
MySQL :: MySQL 5.7 Reference Manual :: 27.8.15.3 How to Get the Unique ID for the Last Inserted Row[^]

I suspect you might need to insert the values one at a time, and use LAST_INSERT_ID to retrieve the ID.

"These people looked deep within my soul and assigned me a number based on the order in which I joined."
- Homer

Re: How do I get all the Ids from my last insert in Mysql?

karengsh28-Jun-17 0:36

karengsh

28-Jun-17 0:36

But, how do I insert one at a time when my situation requires me to insert by batch ?

Re: How do I get all the Ids from my last insert in Mysql?

ZurdoDev28-Jun-17 9:48

ZurdoDev

28-Jun-17 9:48

You can add a timestamp or guid column to mark them. Essentially, you need to have your own logic.

There are two kinds of people in the world: those who can extrapolate from incomplete data.

There are only 10 types of people in the world, those who understand binary and those who don't.

Access ComboBox Query Question

Bassam Abdul-Baki27-Jun-17 14:16

Bassam Abdul-Baki

27-Jun-17 14:16

It's been a while since I've used Access.

I have an Access database with three tables summarized as follows.

Table1
- ID (Primary Key)
- Title (Text)

Table2
- ID (Primary Key)
- Type (Table1.ID combobox lookup single select)
- Other_Fields

Table3
- ID (Primary Key)
- Type (Table1.ID combobox lookup single select)
- Data (Table2.Type combobox multiselect using a query)
- Other_Other_Fields

Without using a form, I would like the Data combobox in Table3 to display only the rows in Table2 where Table2.Type = Table3.Type (=Table1.ID). An inner join is what I'm using, but it's joined to Table1.

SELECT Table2.ID, Table2.Type, Table2.Other_Fields
FROM Table2 INNER JOIN Table1 ON Table2.Type = Table1.ID
WHERE (Table2.Type=Table3.Type);

Here's the problem, according to most of the examples that I've 'oogled, this is done by using a form and requerying the data upon combo update. However, I'm trying to implement this in the table.

The problem that I'm seeing is that when I click on any of the Data fields in Table3, it uses the Type ID of the very first row in Table3. If I change that value of the first row's Type field, the table gets repopulated using this new value for all rows. However, if I click on the Home | Records | Refresh menu (not Refresh All), the row that is selected stays selected and the combobox gets populated with the correct data using that row's Type ID.

So my question is, is there a workaround for this without using a form or am I banging my head against a wall? Is this a "by-design feature" (aka bug)?

Thanks!

Web - BM - RSS - Math - LinkedIn

Need to load bulk Data with some conditions

indian14327-Jun-17 10:14

indian143

27-Jun-17 10:14

Hi All,

I have three Tables, TableA, TableB and TableC, TableA is loaded from a huge Flat file, TableB is Temp Table or Table Variable, TableC is the Table which is in Production.

I want to load only those records into TableB which are not existing in TableC, I have to check all the columns of the TableC for loading into TableB, means if there are duplicate rows coming from TableA (or from Flat file which already exists in TableC) then those shouldn't be loaded into TableB, we need to check the duplication for all the Columns in every row.

Any advice will be greatly helpful, thanks in advance.

Thanks,

Abdul Aleem

"There is already enough hatred in the world lets spread love, compassion and affection."

Re: Need to load bulk Data with some conditions

Mycroft Holmes27-Jun-17 19:26

Mycroft Holmes

27-Jun-17 19:26

What have you tried or what ideas do you have?

One way would be to use a left outer join on all the fields and records that are null will need inserting.

Never underestimate the power of human stupidity
RAH

Use Ctrl+Left/Right to switch messages, Ctrl+Up/Down to switch threads, Ctrl+Shift+Left/Right to switch pages.