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
LVL 3
jdthedjAsked:
Who is Participating?
I wear a lot of hats...

"The solutions and answers provided on Experts Exchange have been extremely helpful to me over the last few years. I wear a lot of hats - Developer, Database Administrator, Help Desk, etc., so I know a lot of things but not a lot about one thing. Experts Exchange gives me answers from people who do know a lot about one thing, in a easy to use platform." -Todd S.

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

Experts Exchange Solution brought to you by

Your issues matter to us.

Facing a tech roadblock? Get the help and guidance you need from experienced professionals who care. Ask your question anytime, anywhere, with no hassle.

Start your 7-day free trial
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
It's more than this solution.Get answers and train to solve all your tech problems - anytime, anywhere.Try it for free Edge Out The Competitionfor your dream job with proven skills and certifications.Get started today Stand Outas the employee with proven skills.Start learning today for free Move Your Career Forwardwith certification training in the latest technologies.Start your trial today
Delphi

From novice to tech pro — start learning today.