Scripting.Dictionary object Issue

Hello All,

I am facing a very strange problem in one of our vb6 apps. The problem
details are as follows.

We have a reporting application written in VB6.
We connect to a database at the end of the day and pull all the records
entered during the day from a table. We then load them in a
Scripting.Dictionary object with recordId as the key and generate a
report.

When the application runs on a Win 2000 or windows XP box it works fine
but when we put the same built on a WinNT box the application pulls
maximum of 65338 records into the report whereas the actual no. of
records are over 90000.

All 90000 reocrds are pulled in Win2000 and XP but it fails on WinNT
box and app. does not log any errors.

What additional should I do to fix this problem for WinNT.

Help is appreciated.

Nadeem

mayayana
Wed Jun 14 08:09:41 CDT 2006

I don't know the answer to that, but it seems to
me that you'd be better off without the Dictionary, anyway.
A dictionary class - emulating a dictionary through
the use of wrapped arrays - should be more efficient and
won't need to depend on SCRRUN.DLL.

SCRRUN.DLL,
dictionaries and the FileSystemObject are not part of VB6.
They were just tacked on to cover a slightly embarassing
gap in functionality. (The lack of hash tables and up-to-date
file operations.) According to the author of VB and VB6 in a
Nutshell, dictionaries are actually very fast. But they still require
an unnecessary dependency.

(Also, this is a VBS group, not
a VB6 group. For that try:
comp.lang.basic.visual.misc )

>
> I am facing a very strange problem in one of our vb6 apps. The problem
> details are as follows.
>
> We have a reporting application written in VB6.
> We connect to a database at the end of the day and pull all the records
> entered during the day from a table. We then load them in a
> Scripting.Dictionary object with recordId as the key and generate a
> report.
>
> When the application runs on a Win 2000 or windows XP box it works fine
> but when we put the same built on a WinNT box the application pulls
> maximum of 65338 records into the report whereas the actual no. of
> records are over 90000.
>
> All 90000 reocrds are pulled in Win2000 and XP but it fails on WinNT
> box and app. does not log any errors.
>
> What additional should I do to fix this problem for WinNT.
>
> Help is appreciated.
>
> Nadeem
>

Jim
Wed Jun 14 08:22:39 CDT 2006

why post this to a vbSCRIPT group?


<nadeem_far@yahoo.com> wrote in message
news:1150269406.932907.320330@p79g2000cwp.googlegroups.com...
> Hello All,
>
> I am facing a very strange problem in one of our vb6 apps. The problem
> details are as follows.
>
> We have a reporting application written in VB6.
> We connect to a database at the end of the day and pull all the records
> entered during the day from a table. We then load them in a
> Scripting.Dictionary object with recordId as the key and generate a
> report.
>
> When the application runs on a Win 2000 or windows XP box it works fine
> but when we put the same built on a WinNT box the application pulls
> maximum of 65338 records into the report whereas the actual no. of
> records are over 90000.
>
> All 90000 reocrds are pulled in Win2000 and XP but it fails on WinNT
> box and app. does not log any errors.
>
> What additional should I do to fix this problem for WinNT.
>
> Help is appreciated.
>
> Nadeem
>

nadeem_far
Wed Jun 14 21:05:17 CDT 2006

I was finding alot of posts on Scripting.Dictionary object in this
group so I thought this was a right group to ask the question, but I
guess I was wrong.

Thanks though.

Nadeem

Jim wrote:
> why post this to a vbSCRIPT group?
>
>
> <nadeem_far@yahoo.com> wrote in message
> news:1150269406.932907.320330@p79g2000cwp.googlegroups.com...
> > Hello All,
> >
> > I am facing a very strange problem in one of our vb6 apps. The problem
> > details are as follows.
> >
> > We have a reporting application written in VB6.
> > We connect to a database at the end of the day and pull all the records
> > entered during the day from a table. We then load them in a
> > Scripting.Dictionary object with recordId as the key and generate a
> > report.
> >
> > When the application runs on a Win 2000 or windows XP box it works fine
> > but when we put the same built on a WinNT box the application pulls
> > maximum of 65338 records into the report whereas the actual no. of
> > records are over 90000.
> >
> > All 90000 reocrds are pulled in Win2000 and XP but it fails on WinNT
> > box and app. does not log any errors.
> >
> > What additional should I do to fix this problem for WinNT.
> >
> > Help is appreciated.
> >
> > Nadeem
> >