I am trying to use golang’s sqlc for my project, but currently this downloadable file only supports MySQL but want to use PostgreSQL in my case. The package supports go get and I imported into my go.mod but I believe I still have to add sqlc into environment variable for my windows setup to actually ..
I’m currently trying to find a way, library or anything else that allows my program to get notified when the contents of my table/database changes. For example, this is what I’d like to do: Program connects to the database Program interacts (add/edit/delete rows) with the database Database detects interaction and sends notification Program receives notification ..
I’m reling on community expertise to guide me in the best way about following topic. In a professional context runing on windows without possibility to install MS-Office application I need to distribut to my team a way to join 2 CSV files and produce a 3rd CSV files as output. Exactly as if we run ..
I’m new in sql and c#. I have a problem on accessing a column of database. I have two buttons that will access the different column of table database at the same time. I used select and update command. Any button that is pressed first, don’t have problems to access the column from the table, ..
I’m new in sql and c#. I have a problem in accessing a column of a database. I have two buttons that will access the different column of table database at the same time. I used select and update statement. Any button that is clicked first, don’t have problems to access the column from the ..
I’m migrating a SQL Server 2008 database to SQL Server 2019, I have used Microsoft Data Migration Assistant, to look for search any breaking changes, issues or syntax errors. I getting errors for some of my procedures: Object [dbo].[PROCEDURE1] has syntax errors. Must declare the variable or parameter "@SINI". Error number 70590. For more details, ..
After hours of researching how to do this, I am stumped and need help from the experts of stack overflow. I am not a WPF developer and only started teaching myself Monday, so please be patient – but I need to create a user interface to allow an end user to update a few fields ..
I need to make a Desktop Application that will be using .NET on the frontend and SQL Server Express edition as the backend. I need to make sure that this application works even if the internet goes down. How should I make this application working in offline mode? Please keep in mind that this application ..
I try to add an SLQ representation of c++ object inside generate code. Each c++ class have a builder and is in charge of save/restore object from SQL database. I have a call like this SELECT With_ext_key.id,With_ext_key.name3, (k1_table.id,k1_table.name1,k1_table.name2,k1_table.re) as k1, (k2_table.id,k2_table.name1,k2_table.name2,k2_table.re) as k2 FROM With_ext_key INNER JOIN With_key AS k1_table ON k1_table.id = With_ext_key.k1 INNER ..
I am just using QSql with C++ to work with a MS Access database. This works so far. The problem is that i can not get the original SQL string when have created a view/query. The Access table MSysQueries contains some information but is somehow cryptic. Code snippets are welcome, wether QSql C++ or pure ..