da-soft - Data Access Technologies

Additional

dbCAP

AnyDAC

ThinDAC

NCOCI8

Topic: Get DataSet Props button don't work?

Forum List » AnyDAC » v 1.x General English

Noname Cowboy
User

Fresh Boarder

Posts: 8

Karma: 0

Get DataSet Props button don't work?

Posted: 2005/07/06 19:25

Hi!

In UpdateSQL component's Update SQL Editor why can't get any information from owner dataset by Get DataSet Props button?

All of properties are sets. What's the problem with it?

Regards, Cowboy

Diman

Admin

Posts: 1495

Karma: 19

RE: Get DataSet Props button don't work?

Posted: 2005/07/07 00:40

Hi !

1) What is your DBMS ?
2) What is your query ?
3) You wrote "can't get any information". It means you cannot get PK fields ?

Regards,
Dmitry

Noname Cowboy
User

Fresh Boarder

Posts: 8

Karma: 0

RE: Get DataSet Props button don't work?

Posted: 2005/07/07 03:17

Hi!

1) ORACLE
2) example:
select
a.id,
a.name,
a.date
b.addr
from
tbl1 a,
tbl2 b
where a.id=b.tbl1_id

3) I wrote that but I wrote fools.

Get DataSet Props button don't get datas from owner dataset.

Sorry.

Diman

Admin

Posts: 1495

Karma: 19

RE: Get DataSet Props button don't work?

Posted: 2005/07/07 12:14

Hi Cowboy !

Do following:
1) Select "Table Name". That will be table to update. Editor will use it name to generate SQL's.
2) Press "Get DBMS Info". That will fill 3 field listboxes with columns of "Table Name".
3) Press "Get Dataset Props". That will select fields as they are in dataset.

But there is bug. Open daADGUIxFormsfUSEdit unit, find line: "FetchOptions.RowsetSize := 0", and replace 0 with 1.

Regards,
Dmitry

Noname Cowboy
User

Fresh Boarder

Posts: 8

Karma: 0

RE: Get DataSet Props button don't work?

Posted: 2005/07/07 19:25

Thx a lot!

I'm thinking that this component works as IBUpdateSQL component's Editor. Because that's component offering to choose table, field etc...

Regards, Cowboy

Forum List » AnyDAC » v 1.x General English