SmartQuery1->Edit();

Discussion of open issues, suggestions and bugs regarding ODAC (Oracle Data Access Components) for Delphi, C++Builder, Lazarus (and FPC)
Post Reply
niniramos
Posts: 11
Joined: Tue 04 Jul 2006 07:40

SmartQuery1->Edit();

Post by niniramos » Fri 18 Aug 2006 09:33

I hav two diferent windows, in each windows i use one SmartQuery. the two SmartQuery use the same session object.

each SmartQuery make a Select from a Diferent Table.

In the first window i make SmartQuery1->Edit();


then I try in the second window SmartQuery1->Edit();

but i can´t make that because in the first window the object is in edit mode, if I cancel the edit mode in the first window and then i try to make SmartQuery1->Edit() now i can.

the problem is tha i need to make edit in the diferents windows. how can I make?


Thanks, i hope that you can understand me, because my english i so sort.

niniramos
Posts: 11
Joined: Tue 04 Jul 2006 07:40

Post by niniramos » Fri 18 Aug 2006 10:58

the problem is that the tow SmartQuerys are in se same transaction, when i cancel in the first i cancel in the second

Plash
Devart Team
Posts: 2844
Joined: Wed 10 May 2006 07:09

Post by Plash » Mon 21 Aug 2006 09:30

You should use different TOraSession components for each TSmartQuery. Otherwise only one TSmartQuery can be in edit mode at the same time.

niniramos
Posts: 11
Joined: Tue 04 Jul 2006 07:40

Post by niniramos » Mon 21 Aug 2006 11:46

sorry i new in oracle DB, and i think that when I have, for example, five licenses i only have five simultaneous session with the data base. if i have for example 6 diferents windows with 6 diferents session I have one problem, no??

sorry but i am not a native english speaker.

thanks

niniramos
Posts: 11
Joined: Tue 04 Jul 2006 07:40

Post by niniramos » Mon 21 Aug 2006 11:51

and i think that my application i exect it slowly. but if I have one session that is faster, no??

Plash
Devart Team
Posts: 2844
Joined: Wed 10 May 2006 07:09

Post by Plash » Tue 22 Aug 2006 09:52

Send to ODAC support address complete sample that demonstrates the problem and include script to create server objects. Then we'll see if the problem can be solved using one TOraSession component.

Post Reply