testsql | Generate test data from SQL files | Testing library

No two SQL dialects are exactly the same for exact transferability. Simply, MariaDB's SQL will not perfectly align to MS Access' SQL similar to running same query from Oracle to Postgres, MySQL to SQL Server, Sybase to DB2... There will need to be some translation.

Specifically:

• DATE_FORMAT is not an available function in MS Access. Instead use FORMAT with appropriate format pattern which does not use %.

• More than one JOIN require parentheses wrapping in MS Access. However, your mix of RIGHT JOIN and LEFT JOIN may require nested joining.

  (Admittedly, this is a frustrating requirement for new Access users to build complex queries with Query Designer and not SQL. I raised this suggested change among others to Access' SQL dialect.)

• Fortunately, backticks are supported in MS Access though square brackets, [...], are the more popular form to escape identifiers with special characters or keywords.

Consider following adjustment:

Use Option Explicit, like Hans said. Always use Option Explicit!

You're missing a reference to the Microsoft Office ##.# Access Database Engine object. This is where dbFailOnError is defined. Because you don't have that reference, dbFailOnError is not defined. This reference is added to all Access databases by default, and I strongly recommend adding it.

And because you're not using Option Explicit, VBA doesn't mind that it's undefined and just casts that undefined variable to a zero.

If, for some reason, you don't want to add the reference, use the corresponding value for dbFailOnError:

This should do what you need:

str(r[‘a’])

You can get the literal valubof any RDFliteral by just casti it to a string with Python’s str() method so just pass the value as above, not just r, to the template.

How do I get my packages.config folder back where it was?

If you do not absolutely need packages.config, then do not go back. The PackageReference format offers lots of benefits that you do not want to miss in the long run, your link does not lie. It even solves your next problem.

How do I Uninstall the packages I did not install?

You simply don't, because it will break your library. A NuGet package represents a module or set of features consisting of artifacts like assemblies, content files or build scripts. Such a module may have dependencies that it requires to work, for example an SQLite library. Instead of creating one giant archive that contains all assemblies and files that are required, packages specify dependencies to other packages. This way, you can flexibly consolidate and update packages, especially if there are common dependencies of multiple packages, which also prevents having multiple copies of the same assemblies or files in different versions, which can become problematic.

Let's look at the dependencies of the packages that you are using.

• System.Data.SQLite.Core
  • No dependencies
• WeCantSpell.Hunspell
  • System.Memory for .NET Framework >= 4.5

[...] the only package installed was System Data SQLite Core

This package does not have any dependencies, that is why there were not additional packages.

[...] I only installed System Data SQLite Core and WeCantSpell.Hunspell

If you look at the list above, the Hunspell package requires System.Memory, that explains why it is installed, too. Hunspell will not work without it, it depends on it. I hear you ask, where do the other packages come from then? Each package can have dependencies. Consequently a package can depend on a package that depends on other packages that... I think you get the idea. So let's take another look at dependencies for .NET Framework >= 4.6.1.

• System.Memory
  • System.Buffers
  • System.Numerics.Vectors
  • System.Runtime.CompilerServices.Unsafe

I think that these are all the dependencies that you were looking for. All these packages will be added to your packages.config and this is one good reason to migrate to PackageReference, because it handles transitive package references way better. Suppose you add one package A with a dependency to package B and that has a dependency to package C. Then A has a dependency to C. This is called a transitive dependency.

The older packages.config will add all packages, while PackageReferece will only add A and is smart enough include the other packages, without explicitly adding them. In your example, the project file would only contain the references below.

To prevent sorting on columns, which appears to be your main question, do the following:

Ok, I found out that the problem was that when the user already existed, I did not commit the database, which resulted in the connection not closing, and when I tried to create another one (i.e. used the mysql command), the latter waited forever for the first to end.

To prevent this: either commit or close a connection to the database, or close the cursor before creating another connection to the database (or use the same cursor to restore).

You have a few different types of mistakes... the variables cannot be within the quotes, and since the field CXI_ID is a String, it does need quotes.

This assumes that the Consent field is numeric and the combobox is returning a numeric value as well.

Directories in Oracle should point to actual directories on the Database server, not your PC. UTL_FILE cannot work with files on your PC