DBNavigator problem
lazarus / 16-Databases

----------------------------------------------------------------------
mpetya · 2012-11-21 09:17

Hi,

There is a DBgrid, sqlquery, IBconnection, SQLTransaction, DataSource,
DBNavigator. The grid will appear in the data, but I can not
DBnavigator edit, delete, or insert new data.

The DBNavigator Tdatasource the DataSource is set.

How can I force a function DBNavigator?

Thanks in advance for the answers.

----------------------------------------------------------------------
anis2505 · 2012-11-21 10:47

Hi,
Add
Code: [Select]procedure TForm1.SQLQuery1AfterDelete(DataSet:
TDataSet);
begin
     SQLQuery1.ApplyUpdates;
     SQLTransaction1.CommitRetaining;
end;

procedure TForm1.SQLQuery1AfterPost(DataSet: TDataSet);
begin
  SQLQuery1.ApplyUpdates;
  SQLTransaction1.CommitRetaining;
end;

----------------------------------------------------------------------
mpetya · 2012-11-21 11:22

SQLQuery1: no delete query specified and failed to generate one. (No
fields for inclusion in where statement found)

----------------------------------------------------------------------
anis2505 · 2012-11-21 11:25

Quote from: mpetya on November 21, 2012, 12:22:28 pmSQLQuery1: no
delete query specified and failed to generate one. (No fields for
inclusion in where statement found)

Code: [Select]SQLQuery1.DeleteSQL.Text:='DELETE FROM tablename WHERE
IDTable=:IDTable';

IDTable and :IDTable: The exact Table identifier name

----------------------------------------------------------------------
mpetya · 2012-11-21 12:14

Just insert the works of new and delete does not work.

----------------------------------------------------------------------
anis2505 · 2012-11-21 12:34

Quote from: mpetya on November 21, 2012, 01:14:19 pmJust insert the
works of new and delete does not work.


Take a look at this example using MS Access DB

http://uploadhero.com/dl/jq8Thret

Another example using FireBird

check the join file

regards

----------------------------------------------------------------------
mpetya · 2012-11-21 22:48

Hi,

Thank you very much helped example. I was stupid, because I wrote for
table name lowercase letter beacuse I wrote it so bad. The table name
must be writen capital letters.

Thank you,

----------------------------------------------------------------------
anis2505 · 2012-11-22 07:47

Glad That helps.

But the capital letters is your system problem. I guess you are using
Mac or Linux If so you should take care about spellings. on windows it
doesn't matter

regards

----------------------------------------------------------------------
BigChimp · 2012-11-22 07:58

Quote from: anis2505 on November 22, 2012, 08:47:13 amBut the capital
letters is your system problem. I guess you are using Mac or Linux If
so you should take care about spellings. on windows it doesn't matter
No, it depends on the databases. Some databases have no problem with
the case (capital letters or lowercase) but others require the same
case you used when creating the tables.

If he's using Firebird, it's strange - normally case doesn't matter.
Perhaps he used double quotes around his table names etc, or Dialect
1...

----------------------------------------------------------------------
anis2505 · 2012-11-22 08:19

Quote from: BigChimp on November 22, 2012, 08:58:48 amQuote from:
anis2505 on November 22, 2012, 08:47:13 amBut the capital letters is
your system problem. I guess you are using Mac or Linux If so you
should take care about spellings. on windows it doesn't matter
No, it depends on the databases. Some databases have no problem with
the case (capital letters or lowercase) but others require the same
case you used when creating the tables.

If he's using Firebird, it's strange - normally case doesn't matter.
Perhaps he used double quotes around his table names etc, or Dialect
1...

Well I thought it was the System's issue because I know FB doesn't
care about letters case. Sometimes thing doesn't look as it is.