setquerywhere

Posted by ucansu on 25-Aug-2011 07:12

smartviewer ,smartbrowser  on container

initialize-object

DYNAMIC-FUNCTION('setquerywhere' IN h_dsipbas01,'for EACH ekinci.sipbas use-index key-unite NO-LOCK,
                      EACH ekinci.firma OF ekinci.sipbas NO-LOCK INDEXED-REPOSITION').
    DYNAMIC-FUNCTION('openQuery' IN h_dsipbas01).

when i update

** Starting position for SUBSTRING, OVERLAY, etc. must be 1 or greater. (82)

and

Invalid rowid for FIND-BY-ROWID method of BUFFER object <name>. (7341)

what can i do

thanks

All Replies

Posted by Håvard Danielsen on 25-Aug-2011 09:46

ucansu wrote:

smartviewer ,smartbrowser  on container

initialize-object

DYNAMIC-FUNCTION('setquerywhere' IN h_dsipbas01,'for EACH ekinci.sipbas use-index key-unite NO-LOCK,
                      EACH ekinci.firma OF ekinci.sipbas NO-LOCK INDEXED-REPOSITION').
    DYNAMIC-FUNCTION('openQuery' IN h_dsipbas01).

when i update

** Starting position for SUBSTRING, OVERLAY, etc. must be 1 or greater. (82)

and

Invalid rowid for FIND-BY-ROWID method of BUFFER object . (7341)

what can i do

thanks

My first guess would be that you run into some issue due to the fact that you qualify the tables with the databasename. I could be completely wrong. I do not remember whether this was supported at all or if you had to generate the SDO with the AppBuilder setting to qualify with database name.

You should avoid qualifying table references with database name unless you absolutely have to.

If this is not your problem make sure you show us the stacktrace of the error. ( run with -debugalert and press help when you get the error)

This thread is closed