• Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 148
  • Last Modified:

DBGrids and Windows NT 4

Hi

I am having problems with my D4 ap when it is run under Windows NT 4.

I have several forms with DBGrids on them attached to queries and there are no problems with them, but one form has its DBGrid attached to a TTable component in a master-detail arrangement.  (The grid is attached to the detail table)

When I run the program on my WIN98 machine all is well, but under NT4 there is no data in the grid linked to the table.  I have carefully checked my MasterSource,MasterFields and IndexName properties.

Any ideas??

John
0
jdthedj
Asked:
jdthedj
1 Solution
 
rwilson032697Commented:
Are you running as a normal NT user, or an administrator user?

If a normal user try running it as an administrator to eliminate problems with access permissions...

Cheers,

Raymond.
0
 
kretzschmarCommented:
? maybe the detailtable is empty or not open on the NT-Workstation, just a guess

meikl
0
 
ITugayCommented:
Yes jdthedj!

There are difficult to understending, but after browsing in master table, data in connected to detail table DBGrid may dissapear. (It happen only with NT).
To solve this I suggest:

1) Change deatail TTable to TQuery
2) Define SQL: select * from table_name where some_field=:param_name
(do NOT assign DataSource property in detail TQuery, do not forget to define type of parameter)
3) MasterDataSource.onDataChange event:

begin
   DetailQuery.Close;
   DetailQuery.ParamByName('param_name').AsSomething:=MasterTable.FieldByName('field_name').AsSomething;
   DetailQuery.Open;
end;

Usually it help;)

PS: I was tried a lot, but solution described above look more easy & attractive.

Best regards
Igor
0
 
jdthedjAuthor Commented:
Hi Raymond, Meikl and Igor - thanks for the replies.

There are only 2 NT machines linked together in a peer to peer arrangement, and the prog is installed locally on one of them together with the tables.

Igor's idea works, so I will go with that!

Thanks again.

John
0

Featured Post

[Webinar] Improve your customer journey

A positive customer journey is important in attracting and retaining business. To improve this experience, you can use Google Maps APIs to increase checkout conversions, boost user engagement, and optimize order fulfillment. Learn how in this webinar presented by Dito.

Tackle projects and never again get stuck behind a technical roadblock.
Join Now