Subject | RE: [IBO] IB_Query/SP/KeyLinks |
---|---|
Author | Jason Wharton |
Post date | 2004-11-01T21:59:56Z |
Alan,
If you are selecting from a stored procedure there isn't a practical way to
refresh just a single record. I've tampered with the idea of allowing you
to create a second stored procedure tailored just for returning a single
record and allowing you to plug it in so that IBO can do this.
For the time being, I recommend that you do not rely upon this capability of
IBO in this way. As it is right now, the server would have to run the whole
dataset until it finds the record you are after. This doesn't seem
appropriate to me.
There may be some other ways to approach this too, so I'm open to ideas.
When using a stored procedure set KeyLinks blank and set KeyLinksAutoDefine
to false.
Jason Wharton
If you are selecting from a stored procedure there isn't a practical way to
refresh just a single record. I've tampered with the idea of allowing you
to create a second stored procedure tailored just for returning a single
record and allowing you to plug it in so that IBO can do this.
For the time being, I recommend that you do not rely upon this capability of
IBO in this way. As it is right now, the server would have to run the whole
dataset until it finds the record you are after. This doesn't seem
appropriate to me.
There may be some other ways to approach this too, so I'm open to ideas.
When using a stored procedure set KeyLinks blank and set KeyLinksAutoDefine
to false.
Jason Wharton
> -----Original Message-----
> From: Alan McDonald [mailto:alan@...]
> Sent: Friday, October 29, 2004 1:32 AM
> To: IBObjects@yahoogroups.com
> Subject: [IBO] IB_Query/SP/KeyLinks
>
>
>
> I have an IB_Query set with the following SQL
> SELECT FIELD1, FIELD2, FIELD3 FROM LOAN_S_ALL(:FK_SECCODE) WHERE ...
> I have the KeyLinks property set to 'FIELD1'
> and the MasterParamLinks set to 'FIELD3=FIELD3'
> where this field is present in the mastersource datasource dataset.
>
> Now my question is - How does the keylinks record get
> resolved here if this
> one record is being refreshed?
>
> I ask this question because I am now getting a "cursor
> unknown error" and
> I'm pretty sure it's from this query.
> Is there some additional setting I should be obeying? What
> other way can I
> set the keylinks property?
>
> thanks
> Alan