markjde
Active Member
This is a multi-part message in MIME format.
------=_NextPart_000_0009_01C0705F.4B92CD90
Content-Type: text/plain;
charset="iso-8859-1"
Content-Transfer-Encoding: quoted-printable
A bit of system information, we are running on a single enterprise =
server with a single deployment server. We use Windows NT (Workstation =
and Server), SQL 7.0 and I am developing on a FAT client. I have a =
custom find/browse form which is over a custom table using a custom =
business view.
=20
Two problems exist, firstly one of the fields in the table is Cost =
Center, but the QBE for that field doesn't function. If I don't use the =
specific QBE field and I use other QBE fields I get the records, but if =
I enter anything in the QBE for the Cost Center I don't get any records =
in the grid. Using the UTB I can see the records contain the Cost =
Center that I am attempting to use in the QBE field, in addition I =
checked the field and QBE is not disabled.
My next problem, I believe is related to the system setup. If I use my =
a Table IO control using the business view (or the table) the system =
doesn't retrieve any records from the table. I have tested this using =
existing JDE business views and the same problem occurs. The reason =
that I think this problem is associated with a system setup issue is =
that initially the client didn't have the JDE ODBC driver on the local =
system. Perhaps we are missing something else...
Any assistance would be greatly appreciated.
Mark Smith
[email protected]
------=_NextPart_000_0009_01C0705F.4B92CD90
Content-Type: text/html;
charset="iso-8859-1"
Content-Transfer-Encoding: quoted-printable
<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.0 Transitional//EN">
<HTML><HEAD>
<META http-equiv=3DContent-Type content=3D"text/html; =
charset=3Diso-8859-1">
<META content=3D"MSHTML 5.50.4611.1300" name=3DGENERATOR>
<STYLE></STYLE>
</HEAD>
<BODY bgColor=3D#ffffff>
<DIV><FONT face=3DArial size=3D2>A bit of system information, we are =
running on a=20
single enterprise server with a single deployment server. We use =
Windows=20
NT (Workstation and Server),SQL 7.0 and I am developing on a FAT=20
client. </FONT><FONT face=3DArial size=3D2>I have a custom =
find/browse form=20
which is over a custom table using a custom business view.</FONT></DIV>
<DIV><FONT face=3DArial size=3D2> </FONT></DIV>
<DIV><FONT face=3DArial size=3D2>Two problems exist, firstly one of the =
fields in=20
the table is Cost Center, but the QBE for that field doesn't =
function. If=20
I don't use the specific QBE field and I use other QBE fields I get the =
records,=20
but if I enter anything in the QBE for the Cost Center I don't get any =
records=20
in the grid. Using the UTB I can see the records contain the Cost =
Center=20
that I am attempting to use in the QBE field, in addition I checked the =
field=20
andQBE is not disabled.</FONT></DIV>
<DIV><FONT face=3DArial size=3D2></FONT></DIV>
<DIV><FONT face=3DArial size=3D2>My next problem, I believe is related =
to the system=20
setup. If I use my a Table IO control using the business view (or =
the=20
table) the system doesn't retrieve any records from the table. I =
have=20
tested this using existing JDE business views and the same problem =
occurs.=20
The reason that I think this problem is associated with a system setup =
issue is=20
that initially the client didn't have the JDE ODBC driver on the local=20
system. Perhaps we are missing something else...</FONT></DIV>
<DIV><FONT face=3DArial size=3D2></FONT></DIV>
<DIV><FONT face=3DArial size=3D2>Any assistance would be greatly=20
appreciated.</FONT></DIV>
<DIV>
<FONT face=3DArial size=3D2>Mark Smith</FONT></DIV>
<DIV><FONT face=3DArial size=3D2></FONT></DIV>
<DIV><A href=3D"mailto:[email protected]"><FONT face=3DArial=20
size=3D2>[email protected]</FONT></A></DIV></BODY></HTML>
------=_NextPart_000_0009_01C0705F.4B92CD90--
------=_NextPart_000_0009_01C0705F.4B92CD90
Content-Type: text/plain;
charset="iso-8859-1"
Content-Transfer-Encoding: quoted-printable
A bit of system information, we are running on a single enterprise =
server with a single deployment server. We use Windows NT (Workstation =
and Server), SQL 7.0 and I am developing on a FAT client. I have a =
custom find/browse form which is over a custom table using a custom =
business view.
=20
Two problems exist, firstly one of the fields in the table is Cost =
Center, but the QBE for that field doesn't function. If I don't use the =
specific QBE field and I use other QBE fields I get the records, but if =
I enter anything in the QBE for the Cost Center I don't get any records =
in the grid. Using the UTB I can see the records contain the Cost =
Center that I am attempting to use in the QBE field, in addition I =
checked the field and QBE is not disabled.
My next problem, I believe is related to the system setup. If I use my =
a Table IO control using the business view (or the table) the system =
doesn't retrieve any records from the table. I have tested this using =
existing JDE business views and the same problem occurs. The reason =
that I think this problem is associated with a system setup issue is =
that initially the client didn't have the JDE ODBC driver on the local =
system. Perhaps we are missing something else...
Any assistance would be greatly appreciated.
Mark Smith
[email protected]
------=_NextPart_000_0009_01C0705F.4B92CD90
Content-Type: text/html;
charset="iso-8859-1"
Content-Transfer-Encoding: quoted-printable
<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.0 Transitional//EN">
<HTML><HEAD>
<META http-equiv=3DContent-Type content=3D"text/html; =
charset=3Diso-8859-1">
<META content=3D"MSHTML 5.50.4611.1300" name=3DGENERATOR>
<STYLE></STYLE>
</HEAD>
<BODY bgColor=3D#ffffff>
<DIV><FONT face=3DArial size=3D2>A bit of system information, we are =
running on a=20
single enterprise server with a single deployment server. We use =
Windows=20
NT (Workstation and Server),SQL 7.0 and I am developing on a FAT=20
client. </FONT><FONT face=3DArial size=3D2>I have a custom =
find/browse form=20
which is over a custom table using a custom business view.</FONT></DIV>
<DIV><FONT face=3DArial size=3D2> </FONT></DIV>
<DIV><FONT face=3DArial size=3D2>Two problems exist, firstly one of the =
fields in=20
the table is Cost Center, but the QBE for that field doesn't =
function. If=20
I don't use the specific QBE field and I use other QBE fields I get the =
records,=20
but if I enter anything in the QBE for the Cost Center I don't get any =
records=20
in the grid. Using the UTB I can see the records contain the Cost =
Center=20
that I am attempting to use in the QBE field, in addition I checked the =
field=20
andQBE is not disabled.</FONT></DIV>
<DIV><FONT face=3DArial size=3D2></FONT></DIV>
<DIV><FONT face=3DArial size=3D2>My next problem, I believe is related =
to the system=20
setup. If I use my a Table IO control using the business view (or =
the=20
table) the system doesn't retrieve any records from the table. I =
have=20
tested this using existing JDE business views and the same problem =
occurs.=20
The reason that I think this problem is associated with a system setup =
issue is=20
that initially the client didn't have the JDE ODBC driver on the local=20
system. Perhaps we are missing something else...</FONT></DIV>
<DIV><FONT face=3DArial size=3D2></FONT></DIV>
<DIV><FONT face=3DArial size=3D2>Any assistance would be greatly=20
appreciated.</FONT></DIV>
<DIV>
<FONT face=3DArial size=3D2>Mark Smith</FONT></DIV>
<DIV><FONT face=3DArial size=3D2></FONT></DIV>
<DIV><A href=3D"mailto:[email protected]"><FONT face=3DArial=20
size=3D2>[email protected]</FONT></A></DIV></BODY></HTML>
------=_NextPart_000_0009_01C0705F.4B92CD90--
