nb6.9.1 & javafx composer & mySql help needed

[akrynski]

Hi,
I am fresh new to javaFx so my problem may be trivial
I have grid binded to some records in mySql table with help of jdbcdataSource.
Problem is how to delete some records from db?
I tried jdbcdataSource.remove("here_table_name", " column_name = {labelInGrid.text}"); but it throws exception:
Unknown column name 'here_right_name_from_labelInGrid.text' in where clause.
"table_name.column_name = ..." doesn't work too.

Is this wrong way?

How to add, remove, update, select records using jdbcdataSource component?

[Maros Sandor]

Hi,

JDBC data source has methods that can insert, update and delete database
rows. To remove rows from a table, execute DbDataSource.remove() method.
Its signature is:

remove(table : String, whereClause : String)

executes this sql statement:
var sql = "DELETE FROM {table} WHERE {whereClause}";

The problem is probably in the WHERE clause, I would recommend printing
it out for verification, maybe also print out the resulting SQL statement.

HTH,

Maros

On 06.10.2010 04:48 PM, akrynski wrote:

[akrynski]

Here it is what I exactly was doing:

[Maros Sandor]

So the record is not deleted in the database? If this is the case, you
should first find a DELETE statement that works for you in your
database, this is not a problem in javafx, it just feeds JDBC driver
with SQL statements.

Maros

On 14.10.2010 03:27 PM, akrynski wrote:

[Tony]

Its a long time since I played with JBDC, but isn't it necessary to flush
the connection after a delete to clear the cached records?

Tony

-----Original Message-----
From: akrynski [mailto:address-removed]
Sent: 14 October 2010 14:27
To: address-removed
Subject: [nbusers] nb6.9.1 & javafx composer & mySql help needed

Here it is what I exactly was doing:

Code:

function butDeleteKlientaActionAtklienci(): Void {
//TODO

try {
var rs = jdbcdataSource.getRecordSet();

jdbcdataSource.remove("pismak_users.client",
"pismak_users.client.name = {rs.currentField({
nameValueLabel.text
})}");
//jdbcdataSource.execute("START TRANSACTION;DELETE FROM pismak_users.client
WHERE client.name={nameValueLabel.text};COMMIT;"); no effect visible
//jdbcdataSource.execute("DELETE FROM pismak_users.client WHERE
pismak_users.client.name={nameValueLabel.text}"); no effect visible
//jdbcdataSource.query = "DELETE FROM pismak_users.client WHERE
pismak_users.client.name={nameValueLabel.text}"; no effect visible
jdbcdataSource.refresh();
} catch (e) {
label.text = e.getMessage(); } finally { label.text = "Record
{nameValueLabel.text} deleted"; }

}



Label on 'finally' clause changes to i.e. "Record 'John Doe' deleted"
Display changes moving back to first record in db, but table stays intact.
If I click on Next button 'deleted' record comes back!
So I think I've tried everything possible.

Best regards

------------------------
Andrzej Kryński

[akrynski]

[akrynski]

[Maros Sandor]

If there is no DELETE statement that works in your database then you are
discussing this issue in a wrong forum I guess.

Maros

On 15.10.2010 11:13 AM, akrynski wrote:

[akrynski]

[Bredie]

akrynski wrote:

[Maros Sandor]

http://forums.mysql.com/

On 17.10.2010 03:33 PM, akrynski wrote: