hate | Hate - Ruby OpenGL Game Engine | Game Engine library

I have a trusted MS Access database about invoices, procurement. I use it 4 years ago now, but need a re-do, to solve problems, build new things in to it, make it more easier to use. I started using MS Access more then a decade ago, but this is the first time I must ask.

I have only one problem doing that. I have two tables which has a relationship, one-to-many. One is about invoice data, the other is invoice items. In the invoice table the invoice number is an autonumber with a specified format. There is a split form, where should be a filtered datasheet, filtered to the actual invoice numbers. Now it is not working, because the two connected field parameters are not match. Yes the one is auto number, the other stored as short text.

In the old database I stored the invoice number as short text, but I hate to fill a new invoice number all the time when I create one. This must be a new feature to the database, to fill it automatically.

For more precise information:
Invoice number:
Data type: autonumber
Field size: Long integer
New values: Increment
Format: "SZ"00000

If you believe my approach is not ideal, your ideas are welcome.

Why aren't the props being passed to the component in InventorySectionGroupItemComponent

https://codesandbox.io/s/cgvbc

?

There's a warning:

Problem

I have a large JSON file (~700.000 lines, 1.2GB filesize) containing twitter data that I need to preprocess for data and network analysis. During the data collection an error happend: Instead of using " as a seperator ' was used. As this does not conform with the JSON standard, the file can not be processed by R or Python.

Information about the dataset: Every about 500 lines start with meta info + meta information for the users, etc. then there are the tweets in json (order of fields not stable) starting with a space, one tweet per line.

This is what I tried so far:

1. A simple data.replace('\'', '\"') is not possible, as the "text" fields contain tweets which may contain ' or " themselves.
2. Using regex, I was able to catch some of the instances, but it does not catch everything: re.compile(r'"[^"]*"(*SKIP)(*FAIL)|\'')
3. Using literal.eval(data) from the ast package also throws an error.

As the order of the fields and the legth for each field is not stable I am stuck on how to reformat that file in order to conform to JSON.

Normal sample line of the data (for this options one and two would work, but note that the tweets are also in non-english languages, which use " or ' in their tweets):

I have a JS function that works with a button; basically, it's supposed to show the HTML code after clicking the button. However, for some reason, when I load the page, the HTML is visible before clicking the button; clicking the button once makes the code disappear, and then clicking it again makes the code re-appear. It seems like the function is doing the opposite of what I want it to do, but I have no idea why it's doing this: comparing my code to other code that does what I want it to do, I don't see any visible differences.

Here is the script:

I have two separate arrays of objects coming back as a data response. I'm currently comparing the two arrays for all items with matching IDs and taking the properties from items in array2 and adding them to the matching item in array1.

Right now I'm using a nested for loop to accomplish this but I hate using nested loops and I'm trying to figure out if there's a cleaner way to write this.

As of now this is my function and a working CodeSandbox:

I am trying to upgrade from Spring Boot 2.2.x to 2.3 I have encountered an issue with the upgrade of spring-data-jdbc. In 1.1.x one could write the following query and it would work as expected

I have a database that allows for more than one ethnicity per person. Unfortunately, our answers are essentially Yes Hispanic, Not Hispanic, and Unknown, and there are some who do indeed have multiple selections. I need to run a large query that pulls lots of info, one of which is ethnicity, and I want to "convert" those that have multiple selections as Unknown.

person_ethnicity_xref table:

mstr_lists table:

I've been struggling with this as I can't use a For XML Path with two tables, so I'm now trying to use the logic of Case When count(ethnicity_ID)>1 then 'Unknown' Else Ethnicity End

Here's what I have

I want my bot to respond to commands that are typen with capital letters, but where should I put it, I really don't know... :heh:. So yea where should I put the .toLowercase for my bot to respond to capital letters?

Beginner in both rust and async programming here.

I have a function that downloads and stores a bunch of tweets in the database: