by Michae » Tue, 11 Jan 2000 04:00:00
The query is: SELECT DISTINCT sedcode FROM forms_processed WHERE
form_id='NYSED-2R' ORDER BY sedcode
Sedcode - 99999999
Year - 1998, 1996
I have a sedcode 99999999 for 1996 and one for 1998. This query works
perfectly in Oracle, but when using VB/ADO control, we are receiving
duplicates.
Does anyone have ideas?
Thanks
by Peter Stambaug » Sat, 15 Jan 2000 04:00:00
Peter S
Quote:> Hi I am helping a coworker fix a bug in a VB program. We have a query
that
> was tested in Oracle, but does not work when used in the VB 6.0 program.
> The query is: SELECT DISTINCT sedcode FROM forms_processed WHERE
> form_id='NYSED-2R' ORDER BY sedcode
> Sedcode - 99999999
> Year - 1998, 1996
> I have a sedcode 99999999 for 1996 and one for 1998. This query works
> perfectly in Oracle, but when using VB/ADO control, we are receiving
> duplicates.
> Does anyone have ideas?
> Thanks
1. Oracle Query not working in VB
Hi I am helping a coworker fix a bug in a VB program. We have a query that
was tested in Oracle, but does not work when used in the VB 6.0 program.
The query is: SELECT DISTINCT sedcode FROM forms_processed WHERE
form_id='NYSED-2R' ORDER BY sedcode
Sedcode - 99999999
Year - 1998, 1996
I have a sedcode 99999999 for 1996 and one for 1998. This query works
perfectly in Oracle, but when using VB/ADO control, we are receiving
duplicates.
Does anyone have ideas?
Thanks
3. Works in Query Analyser, but not VB
4. SQL Server 2000 on Terminal Services Box
5. Query works in ISQL but not VB
6. Add table to existing Database..
7. Union query not working only in vb
8. Recent postings to comp.databases...
9. Optional paramater, works from query analyzer, not from VB
10. Query works in MSAccess but not in VB 6.0 (Unify via ODBC)
11. Query works in ISQL but not VB
12. Like Query Works in Access but not via VB/ADO
13. Query works in Access, not in VB