• Post Reply Bookmark Topic Watch Topic
  • New Topic

netbeans6.9.1 & mySql CRUD help needed  RSS feed

Andrzej Krynski
Posts: 3
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
could you help me with this?:
I have folowing label in Grid Form

To delete actual record from db I added a button which performs following action:

But it returns error massage: Unknown column 'here_value_from_{nameValueLabel.text}' in 'where clause'
Value from {nameValueLabel.text} is right column value.
Database has simple structure:
table: client-
id - primary key
name - column
subdomain - index
table: another ... ect.

In where clause I tried "client.name = {nameValueLabel.text}" and "name = {nameValueLabel.text}" and neither works.

Question is what am I doing wrong and how to perform Copy, Retrieve, Update, Delete actions correctly?

Best regards, Andrzej Kryński

Lately I tried with:

but with no success too
This code changes datasource I think ( on screen data are removed) but doesn't act on database physically.
  • Post Reply Bookmark Topic Watch Topic
  • New Topic
Boost this thread!