Devart Forums

Shalex wrote:This works for one table only. If your select contains several tables, you can choose one table you are interested in by setting the UpdatingTable property to the name of that only table. Other tables from the select command will not be updated.

I didn't help:


dataset1.table2.InsertCommand = null;
dataset1.table2.UpdateCommand = null;
dataset1.table2.RefreshMode = RefreshRowMode.Both;
dataset1.table2.UpdatingTable = "b"; //update table b

// Using this:
dataset1.table2.RefreshingFields = "aa, bb";
// I get error ORA-00926: missing VALUES keyword
//dataset1.table2.InsertCommand is null

//Using this: asking for updating only column of the b table
dataset1.table2.RefreshingFields = "bb";
// I get error:
//ORA-06550: line 1, column 35:
//PL/SQL: ORA-00926: missing VALUES keyword
//ORA-06550: line 1, column 7:
//PL/SQL: SQL Statement ignored
//dataset1.table2.InsertCommand is null
________
Jaguar aj-v6 engine history

It is not comfortable and not usefull, besides Odac Delphi components handle it wihtout any problem.

Please recommend how can I update columns which belong to onother table, not the one which columns are being updated from UI.
________
Maine Dispensary

Your suggestion does not work:


{System.InvalidOperationException: Dynamic SQL generation is not supported against multiple base tables.
at System.Data.Common.DbDataAdapter.UpdatingRowStatusErrors(RowUpdatingEventArgs rowUpdatedEvent, DataRow dataRow)
at System.Data.Common.DbDataAdapter.Update(DataRow[] dataRows, DataTableMapping tableMapping)
at System.Data.Common.DbDataAdapter.UpdateFromDataTable(DataTable dataTable, DataTableMapping tableMapping)
at System.Data.Common.DbDataAdapter.Update(DataTable dataTable)
at Devart.Common.DbDataTable.Update()
at Devart.Data.Oracle.OracleDataTable.Update()
at Centric.CommonLib.DBBindingHandler.PostDataSource() in C:\src\PCM\Projects\Centric\MVV4all.NET\CommonLib\DBButtons.cs:line 185}
________
GRIEF OR LOSS ADVICE

Sorry, what about my questions about Sequential Fetch Mode?

It is a bug?
________
CROP INSURANCE FORUM

- the button used to post the edited record to the associated datasource
- the button used to delete the currect record from the datasource. So this should be marked as deleted in the oracle table.

No changes in the server, no messages to the server - that's why you don't see anything in the DB Monitor
________
Zx14 vs hayabusa

degas wrote:The records get selected but when i press "end edit", the changes are not posted.

This is correct. Help for EndEdit Button of the EmbeddedNavigator says: "... the button used to post the edited record to the associated datasource." So it posts data to the datasource (oracle table), but not to the server.
________
Mywebcamhookup

Grid is DevExpress.XtraGrid
I use ver 5.0.22
I tried in ver 5.20.29 - the same bug =(

DBMonitor shows only "insert" call. no select call.

only if I scroll in Master - I see Grid 2 Column Values

Please help, may be I miss some kind of property that should be set?
________
XL7

Situation:
Typed dataset. Master-Detail.

Master:
dataset1.table1 is master. SQL Text : select a.aa from a
In the Grid1 dataset1.table1 is shown.
Detail:
Detail dataset1.table2 is detail. SQL Text : select b.bb, b.bb as bb2, a.aa from a, b where a.aID = b.aID
dataset1.table2.RefreshMode = RefreshRowMode.Both;
dataset1.table2.RefreshingFields = "aa, bb";
In the Grid2 dataset1.table2 is shown. Grid2 has two columns:
- column 1 shows bb column.
- column 2 shows aa column
I also have control binded to bb2 column.
I do:
I add new record to dataset1.table2. Set bb2 column value and save (dataset1.table2.Update()).
I see in the grid that new record has been added, but both columns are empty.

Question: Why autorefresh does not work? Why fields values are not retrieveed from the server after an UPDATE statement execution.
________
HEADSHOP

Dear Devart Suppot Team, we have some problems ?Sequential Fetch Mode? used with DevExpress Grid.

We want: "When client needs to fetch more records (for example, user scrolls a grid), another request to server is performed."

We use Devart 5.0.1.0 with DevExpress Grid v8.3.

we want to use ?Sequential Fetch Mode?, so we done everything as described in documentation. We created a typed dataset and a tables in it. We set tables properties in order to use ?Sequential Fetch Mode?.
dataset1.table1.FetchAll = false;//by default
dataset1.table1.QueryRecordCount = true;
dataset1.table1.MaxRecords = 0; //by default

I do:
calling dataset1.table1.active = true;

I see:
1) dataset1.table1.RecordCount = 1383
dataset1.table1.Rows.Count = 1103
2) The sql text (SelectCommand.CommandText) of this table executed in SQLNavigator returns 1383 rows.

Question 1 : why so many records retrieved at once in the beginning? It slows down the functionality very much =(


In another example
I do:
calling dataset1.table2.active = true;
I see:
1) dataset1.table1.RecordCount = 1478
2) dataset1.table1.Rows.Count = 1478

Question 2: why all records are fetched??? All records are fetched!

I do:
calling dataset1.table1.active = true;
I?m on the first record. Grid shows the number of records 1383 (Rows.Count = 1103 RecordCount = 1383). I start scrolling through the records in the grid. When I reach record number 1280 the grid shows that the number of records is 1381 (Rows.Count = 1381 RecordCount = 1381). That? it. I see only 1381 record in the grid. But really there are 1383 records should be.

Question 3: Why it finally shows wrong number of records.

I do:
calling dataset1.table1.active = true;
I?m on the first record. Grid shows the number of records 1383 (Rows.Count = 1103 RecordCount = 1383). I open the filter (the pop up list of all values of some column). As far as I understand now all records should be fetched by the grid in order to form distinct list of values of this column. What I see after this action is Rows.Count = 1381 RecordCount = 1381. Again the same problem as in the previous example.

Question 4: Why it finally shows wrong number of records.

Is there some special things that I should check?
________
Lenders Mortgage Insurance Advice

PropertyInfo pi = gen.GetType().GetProperty("CodeProvider", BindingFlags.Instance | BindingFlags.NonPublic);
CSharpCodeProvider prov = new CSharpCodeProvider();
pi.SetValue(gen, prov, null);

gen.Generate(inputFileName, rdr, "MyNamespace", out rgbOutputFileContents, out pcbOutput, progress);
string Code = Marshal.PtrToStringAnsi(rgbOutputFileContents);


________
VAPORIZER REVIEW

OracleDataSetGenerator has public method SetSite(object pUnkSite).
Will you please tell me how should it be used? What should I pass to it?
Please help me. I'm tring to figure it out....
________
Rehab community

I want is generate *.Designer.cs file for xsd-file of the typed dataset.

I want to do it in the run time or from the command line. NOT by "Run Custom Tool".

Do you have some kind of tool like standard .NET xsd.exe file.

Or will you please help me with generating from the code. I tried this:

class DummyProgress : CoreLab.Common.Design.IVsGeneratorProgress {
public void GeneratorError(bool isWarning, int dwLevel, string
bstrError, int dwLine, int dwColumn) {
}
public void Progress(int nComplete, int nTotal) {
}
}


private void GenerateOracleCodeFile(string inputFileName) {

CoreLab.Oracle.Design.OracleDataSetGenerator gen = new
CoreLab.Oracle.Design.OracleDataSetGenerator();
string rdr = File.ReadAllText(inputFileName);
IntPtr rgbOutputFileContents;
int pcbOutput = -1;
CoreLab.Common.Design.IVsGeneratorProgress
pGenerateProgress;
gen.Generate(inputFileName, rdr, "MyNamespace", out
rgbOutputFileContents, out pcbOutput, progress);
}

I get an error "Get CodeDomProvider Interface failed.". I tried different ways to set CodeDomProvider, but unfortunately I haven't succeeded.

Will you please help me...
________
Mercedes wiki

Thank you a lot. It is clear now.
________
Extreme Vaporizer Review

I also tried version 4.75. The same as in version 4.70.
________
Gift Cards

Thank you for the answer.

Yes, I've seen this example before and reviewed it again. It is NOT what I want. I do NOT want to fetch all data at once.

I want to fetch from the server only those records for the detail table which are connected to the selected master record. so the request to the server should be
"SELECT EMPNO,ENAME,JOB,MGR,HIREDATE,DEPTNO FROM Emp
where DEPTNO = :DEPTNO"

So I used this:
OracleConnection connection = new OracleConnection(connStr);
connection.Open();
OracleDataTable deptTable = new OracleDataTable("SELECT * FROM dept", connection);
OracleDataTable empTable = new OracleDataTable("SELECT * FROM emp", connection);
empTable.ParentRelation.ParentTable = deptTable;
empTable.ParentRelation.ParentColumnNames = new string[] { "deptno" };
empTable.ParentRelation.ChildColumnNames = new string[] { "deptno" };
deptTable.Owner = this;
empTable.Owner = this;
deptTable.Open();
empTable.Open();
deptDataGrid.DataSource = deptTable;
empDataGrid.DataSource = empTable;


But this example illustrates the work with oracle data tables. I want to use TYPED DATASETs.

So ones again. I create typed dataset. I create two tables in it. The select text is just like in the example. I created the object of this typed dataset on the form. Then in the design time in the Properties window I've set ParentRelation.ParentTable, ParentRelation.ParentColumnNames, ParentRelation.ChildColumnNames for the detail table. Detail table is inside the typed dataset. I also conected Master and Detail tables to the grids in order to see the results.
I run this test application. I scroll the master grid, detail grid is not updated, but it must. Each time I scroll master grid there should be a request to the server. something like "select * from detail table where parentID = :parentID" where parentID paremeter = ParentID selected in the master grid.

Hopefully now the question is clear.

I tried in ver 4.70.

with kind regards,
Tatyana
________
MARIJUANA MEDICAL