C# Discussion Boards - CodeProject

Mr Shah 411-Jul-21 1:45

11-Jul-21 1:45

THX for your lenghty reply this forum is not for amateur like me i just need little help not asked you to code big app for me i just want this function to be done its not a big deal BYE..!

OriginalGriff11-Jul-21 1:51

11-Jul-21 1:51

Member 15284301 wrote:
i just need little help not asked you to code big app for me

Quote:
could u plz apply the method change the code as required thx

That sounds like "write the code for me" to me.

You will not get anywhere trying to do complicated stuff unless you understand the basics: and clearly you don't. I'd strongly suggest you sit down with a book (or take a course) and learn how to do things rather than trying to dive into projects you aren't skilled enough to do yet...

Mr Shah 411-Jul-21 1:56

11-Jul-21 1:56

Thank You i just need to use this tool for personnel use i told you i am not coder anyway thx Good Day

OriginalGriff11-Jul-21 2:21

11-Jul-21 2:21

You are trying to play with encryption: that's a bad idea for the unskilled.
It's very, very easy to make a trivial mistake and c**k it up completely - which means that your data will end up lost forever, or about as secure as an open window!

Really and truly, if you want to encrypt stuff, get an app that can do it for you: try WinZip which can move your data into a encrypted ZIP file for example.
Writing encryption code is not a job for a beginner.

Richard MacCutchan11-Jul-21 2:45

Richard MacCutchan

11-Jul-21 2:45

If this is a homework assignment ... OMG | :OMG:

OriginalGriff11-Jul-21 3:12

11-Jul-21 3:12

Maybe the teacher is moonlighting as a "ransomware fixer"? Laugh | :laugh:

Richard Andrew x6411-Jul-21 4:01

Richard Andrew x64

11-Jul-21 4:01

It probably doesn't reference real encryption. The assignment likely has a faux encryption function.

The difficult we do right away...
...the impossible takes slightly longer.

Eddy Vluggen11-Jul-21 7:06

Eddy Vluggen

11-Jul-21 7:06

Member 15284301 wrote:
BYE..!

/wave.

It's not like the site *needs* your question. You come here, with a basic question.

As for me, it doesn't tickle me. At all. I could not care any way, since that's what I is paid. Nothing.

And bloody easy to do, but I do not owe you an answer, do I? Smile | :)

Bastard Programmer from Hell Suspicious | :suss:

"If you just follow the bacon Eddy, wherever it leads you, then you won't have to think about politics." -- Some Bell.

Mr Shah 411-Jul-21 7:19

11-Jul-21 7:19

@Eddy Vluggen No body ask you for reply so buzz off dude i got my reply here no one wants to help simple thing i am not a coder Smile | :)

so no issues for me will find other forums BYE BYE..!

Eddy Vluggen11-Jul-21 12:25

Eddy Vluggen

11-Jul-21 12:25

Member 15284301 wrote:
i am not a coder

Obvious, not a problem usually. You challenging one who is.

Member 15284301 wrote:
BYE BYE..!

Yeah, like I'm missing out on that.

I'll be sitting here crying. For months, I crying for missing your project. The horror of missing it!

Bye, bye Smile | :)

May we never meet again.

Bastard Programmer from Hell Suspicious | :suss:

"If you just follow the bacon Eddy, wherever it leads you, then you won't have to think about politics." -- Some Bell.

Mr Shah 411-Jul-21 15:43

11-Jul-21 15:43

@Eddy Vluggen baby dont cry forever!!! Dont brag about ur coding skill there are better coder than u YES surely we dont meet again 4 good Big Grin | :-D

What is the syntax error in this SQLite query?

Eddy Vluggen12-Jul-21 7:57

Eddy Vluggen

12-Jul-21 7:57

I do not need to brag Smile | :)

"ur"? Like I said, I need not brag.

Bastard Programmer from Hell Suspicious | :suss:

"If you just follow the bacon Eddy, wherever it leads you, then you won't have to think about politics." -- Some Bell.

Alex Dunlop8-Jul-21 7:29

Re: What is the synntax error in this SQLite query?

8-Jul-21 7:29

query is:

SQL

INSERT INTO FileInfo VALUES ('2021', 'ALex', 'Dunlop') WHERE NOT EXISTS (SELECT 1 FROM FileInfo WHERE EqpCode='2021')

The table has 3 columns.
SQLite says:
syntax error near WHERE
How can I fix it?

modified 8-Jul-21 13:40pm.

OriginalGriff8-Jul-21 7:46

Re: What is the synntax error in this SQLite query?

8-Jul-21 7:46

First off, don't INSERT like that - always list the columns into which you want to ISNERT values - if someone (very sensibly) adds an ID column for example, it can really mess up your code, even if the ID column is of IDENTITY type so you can't INSERT to it!
Listing the columns in the order you supply their values makes your code safer and easier to maintain in future.

Secondly, you can't add a WHERE clause to an INSERT operation because it doesn't affect any existing rows - it only ever adds new ones.
If you want to do an insert if no matching rows exist use IF[^] or CASE[^] instead.

I'd probably use COUNT(...) = 0 instead of EXISTS(...) as well.

Alex Dunlop8-Jul-21 7:55

Re: What is the synntax error in this SQLite query?

8-Jul-21 7:55

Do you mean this:
INSERT INTO FileInfo (EqpCode, EqpName, FileName) VALUES ('123', 'rty', 'iuo') WHERE NOT EXISTS (SELECT 1 FROM FileInfo IF EqpCode='123')

It has the same Error.

Dave Kreskowiak8-Jul-21 8:32

Dave Kreskowiak

8-Jul-21 8:32

Again, there is no such thing as a WHERE clause on an INSERT statement. Remove everything from WHERE to the end of the statement.

Asking questions is a skill
CodeProject Forum Guidelines
Google: C# How to debug code
Seriously, go read these articles.

Dave Kreskowiak

Re: What is the synntax error in this SQLite query?

Alex Dunlop8-Jul-21 7:57

Re: What is the synntax error in this SQLite query?

8-Jul-21 7:57

I had used a similar query in C# and it was working well (SQL server CE):

SQL

mycommand.CommandText = $"INSERT INTO MyData([Wo], [EqN], [Code], [Work], [Cost]) SELECT '{DataGridView3.Rows[i].Cells[0].Value}', '{DataGridView3.Rows[i].Cells[1].Value}', '{DataGridView3.Rows[i].Cells[2].Value}', '{DataGridView3.Rows[i].Cells[3].Value}', '{DataGridView3.Rows[i].Cells[4].Value}' WHERE NOT EXISTS (SELECT 1 FROM MyData WHERE [Wo]='{DataGridView3.Rows[i].Cells[0].Value}' AND [Code]='{DataGridView3.Rows[i].Cells[2].Value}')";

Richard MacCutchan8-Jul-21 21:12

Richard MacCutchan

8-Jul-21 21:12

Yes, but the WHERE clause is connected to the SELECT, not the INSERT.

Re: What is the synntax error in this SQLite query?

Alex Dunlop8-Jul-21 8:50

8-Jul-21 8:50

I found an easy way. I changed EqpCode column type to UNIQUE and Unique Conflict Clause to REPLACE. Smile | :)

Then:

SQL

INSERT INTO FileInfo(EqpCode, EqpName, FileName) VALUES ('123', 'test01', 'test02')
ON CONFLICT(EqpCode) DO UPDATE 
SET EqpName = EXCLUDED.EqpName,
    FileName = EXCLUDED.FileName;

modified 8-Jul-21 15:04pm.

SeeSharp29-Jul-21 5:47

SeeSharp2

9-Jul-21 5:47

Some have given you the answer but not really shown you what they mean. You can't use WHERE without a SELECT. So, you do something like this:

SQL

INSERT INTO Table1(Field1, Field2, ...)
SELECT '2021', 'Alex', ...
WHERE NOT EXISTS (...)

OriginalGriff9-Jul-21 19:04

9-Jul-21 19:04

DevParty wrote:
You can't use WHERE without a SELECT.

Um ... you sure?

SQL

UPDATE MyTable SET MyColumn = @MyValue WHERE MyOtherColumn = @MyOtherValue

Victor Nijegorodov9-Jul-21 21:39

Victor Nijegorodov

9-Jul-21 21:39

OriginalGriff wrote:
DevParty wrote:
You can't use WHERE without a SELECT.

Um ... you sure?
SQL
Copy Code

SQL
UPDATE MyTable SET MyColumn = @MyValue WHERE MyOtherColumn = @MyOtherValue

I'm pretty sure he meant an INSERT, clause, not an UPDATE one! OMG | :OMG:

OriginalGriff9-Jul-21 22:31

9-Jul-21 22:31

What he may have meant and what he said are not necessarily the same thing! Laugh | :laugh:

Particularly with beginners, you have to be accurate - a bald statement like "WHERE only works with SELECT" is not accurate and can confuse.