unsubscribe
--- IBObjects@yahoogroups.com wrote: >
------------------------ Yahoo! Groups Sponsor

>
>

___________________________________________________________________________

> IB Objects - direct, complete, custom connectivity
> to Firebird or InterBase
> without the need for BDE, ODBC or any
> other layer.
>

___________________________________________________________________________

> http://www.ibobjects.com - your IBO community
> resource for Tech Info papers,
> keyword-searchable FAQ, community code contributions
> and more !
>

------------------------------------------------------------------------

>
> There are 25 messages in this issue.
>
> Topics in this digest:
>
> 1. Re: Sorting Problems
> From: "mmenaz" <mmenaz@...>
> 2. IBO & Delphi Informant
> From: "Rob Schuff"
> <rob@...>
> 3. Re: TIB_LookupCombo and Grids
> From: "Bob" <rcmiszuk@...>
> 4. Antw: Re: 4.2F tiboquery does not show the
> correct data in D5EP Grid ib_6.0.1
> From: Uwe Cramer
> <uwe.cramer@...>
> 5. Re: UPDATE the users-table in isc4.gdb
> From: "pkh2001fi"
> <petter.holmstrom@...>
> 6. ib_query.joinLinks
> From: "Ronaldo Rezende Vilela Luiz"
> <ronaldinho79@...>
> 7. Numeric Entry in a Grid
> From: "Bob" <rcmiszuk@...>
> 8. RE: Sorting Problems
> From: "Marv Cook" <mjcook@...>
> 9. RE: Re: Sorting Problems
> From: "Marv Cook" <mjcook@...>
> 10. Changing MasterLinks at runtime
> From: "Bob" <rcmiszuk@...>
> 11. Re: Numeric Entry in a Grid
> From: "mmenaz" <mmenaz@...>
> 12. Re: Numeric Entry in a Grid
> From: "rcmiszuk" <rcmiszuk@...>
> 13. Re: Two questions on IB_SQL
> From: "Jason Wharton"
> <jwharton@...>
> 14. Re: Numeric Entry in a Grid
> From: "mmenaz" <mmenaz@...>
> 15. Re: ib_query.joinLinks
> From: "Jason Wharton"
> <jwharton@...>
> 16. Re: Sorting Problems
> From: Geoff Worboys
> <geoff@...>
> 17. Re: ib_query.joinLinks
> From: Geoff Worboys
> <geoff@...>
> 18. Re: Re: Numeric Entry in a Grid
> From: Geoff Worboys
> <geoff@...>
> 19. Re: Re: Numeric Entry in a Grid
> From: Geoff Worboys
> <geoff@...>
> 20. Re: Changing MasterLinks at runtime
> From: Geoff Worboys
> <geoff@...>
> 21. Re: Some problems with tib_lookupcombo and
> tib_searchpanel
> From: "Jason Wharton"
> <jwharton@...>
> 22. Re: UPDATE the users-table in isc4.gdb
> From: Geoff Worboys
> <geoff@...>
> 23. RE: Sorting Problems
> From: "Marv Cook" <mjcook@...>
> 24. Re: Numeric Entry in a Grid
> From: "mmenaz" <mmenaz@...>
> 25. Re: UPDATE the users-table in isc4.gdb
> From: Helen Borrie <helebor@...>
>
>
>

________________________________________________________________________

>

________________________________________________________________________

>
> Message: 1
> Date: Mon, 06 May 2002 08:54:05 -0000
> From: "mmenaz" <mmenaz@...>
> Subject: Re: Sorting Problems
>
> Just for curiosity, what happens if you put all your
> table/field names / parameters to UPPERCASE? It
> could be that in some part IBO fails in doing
> Complaint.ComplaintType = :COMPLAINTTYPE...
> Just a supposition...
> Thanks
> Marco Menardi
>
> --- In IBObjects@y..., "Marv Cook" <mjcook@t...>
> wrote:
> > Hi all,
> >
> > With the following Query I got some unusual
> results. I prepare it once and
> > try to use it more than once changing the
> OrderingItemNo. When I do this,
> > the dataset comes back empty. If I immediately
> try it again, it works OK --
> > until I change the OrderingItemNo again. I put IB
> Monitor on it and found
> > that when you change the OrderingItemNo, the Open
> command will cause a new
> > prepare, but that when that happened, one variable
> 'ComplaintType' was being
> > replaced as NULL. If I change the Parameter name
> to 'CT' instead of
> > 'ComplaintType', then everything works as
> expected. I did this as a
> > workaround, but wondered if we need to take a
> closer look at the parameter
> > replacement code or if I am missing something
> (high probability).
> >
> > Marv
> >
> >
> > SELECT COMPLAINT.OPENDATE
> > , COMPLAINT.RESOLUTIONDATE
> > , COMPLAINT.RESOLVEDBY
> > , COMPLAINT.CSCLOSED
> > , (COMPLAINT.FirstNAME ||'
> '||COMPLAINT.LastNAME) as CustomerName
> > , COMPLAINT.ADDRESSNO
> > , STREETNAMES.SNAME
> > , COMPLAINT.PHONE
> > , COMPLAINT.COMPLAINTTYPE
> > , COMPLAINTTYPE.CTYPID
> > , COMPLAINTTYPE.NAME
> > , EMPLOYEE.EID
> > , EMPLOYEE.LASTNAME
> > , EMPLOYEE.FIRSTNAME
> > , EMPLOYEE.MI
> > , STREETNAMES.SNAME
> > , STREETNAMES.SNAMESORT
> > , CPID
> > FROM COMPLAINT
> > Left Outer JOIN COMPLAINTTYPE on
> (ComplaintType.ctypid =
> > complaint.complainttype)
> > Left Outer JOIN EMPLOYEE on Employee.eid =
> Complaint.resolvedby
> > Left Outer JOIN STREETNAMES on STREETNAMES.SID =
> Complaint.sid
> > Where complaint.water = :water
> > and Complaint.ComplaintType = :COMPLAINTTYPE
> <<--- Problem Here --------
> > and complaint.ResolutionDate Between :StartDate
> and :EndDate
>
>
>
>

________________________________________________________________________

>

________________________________________________________________________

>
> Message: 2
> Date: Mon, 6 May 2002 06:26:22 -0700
> From: "Rob Schuff" <rob@...>
> Subject: IBO & Delphi Informant
>
> Great Job Jason!
>
> Delphi Informant Magazine Readers Choice Awards 2002
>
>

http://www.delphizine.com/opinion/2002/06/di200206jc_o/di200206jc_o.asp

>
> IBO Best Database Connectivity 3rd year in a row!
>
>
> rob
>
>
>
>
>

________________________________________________________________________

>

________________________________________________________________________

>
> Message: 3
> Date: Mon, 6 May 2002 09:46:48 -0500
> From: "Bob" <rcmiszuk@...>
> Subject: Re: TIB_LookupCombo and Grids
>
> Thanks Geoff, you're right. It was KeyDescLinks.
> It's working great.
>

=== message truncated ===

__________________________________________________
Do You Yahoo!?
Everything you'll ever need on one web page
from News and Sport to Email and Music Charts
http://uk.my.yahoo.com