Search the web
Sign In
New User? Sign Up
guggiusers · Guggi Discussion Forum
? Already a member? Sign in to Yahoo!

Yahoo! Groups Tips

Did you know...
Want your group to be featured on the Yahoo! Groups website? Add a group photo to Flickr.

Best of Y! Groups

   Check them out and nominate your group.
Having problems with message search? Fill out this form to ensure your group is one of the first to be migrated to the new message search system.

Messages

  Messages Help
Advanced
INSERT and UPDATE query's   Message List  
Reply | Forward Message #34 of 66 |

Good day,

 

I am an associate of Dan, who emailed you last week. I am experiencing a difficulty with Guggi that I would appreciate some assistance with. When I attempt to run an UPDATE query in the SQL Editor I receive errors and the update does not happen.

 

I am trying to run the following query.

 

update table1

set val4 = 'x4'

where val1 = 'x1' and val2 = 'x2' and val3 = 'x3'

 

I highlight the query and click on the black arrow pointing left (Run sql Statement). The Background SQL window appears with my query in it. When I click the black arrow pointing left I receive an error message stating that the "ActiveX component can't create object." When I click on anything else I receive "Object variable or With block variable not set." This includes the four icons to the right of the black arrow pointing left and the red X icon in the upper right hand corner. When I attempt to run an INSERT query the same sequence of events occur.

 

Thank you in advance for your help,

Aaron



Mon Nov 7, 2005 10:48 pm

as3223
Offline Offline
Send Email Send Email

Forward
Message #34 of 66 |
Expand Messages Author Sort by Date

Good day, I am an associate of Dan, who emailed you last week. I am experiencing a difficulty with Guggi that I would appreciate some assistance with. When I ...
Aaron Stallfus
as3223
Offline Send Email
Nov 7, 2005
10:48 pm

Hello Aaron, Thank you for trying Guggi Oracle. It seems that one of the dlls is not installed properly on the computer running Guggi Oracle. The software uses...
vandana_arora
Offline Send Email
Nov 8, 2005
4:02 am

atleast i don't have any problems, but i will definitely like to say that if it finally gets resolved, then add this to a "Troubleshooting FAQ" bye :-) Ashish...
Ashish Ranjan
ashishwave
Offline Send Email
Nov 8, 2005
12:43 pm

Thanks for the response Ashish. Can you please let me know if you have oip10.dll or oip9.dll file in the ORACLE_BASE/ORACLE_HOME/bin folder? Thanks Shakti...
Shakti <skgoel@...>
shakti_k_goel
Offline Send Email
Nov 8, 2005
1:43 pm

i am using Oracle 8i and hence i do have oip8.dll present there. bye :-) Ashish ... __________________________________ Yahoo! Mail - PC Magazine Editors'...
Ashish Ranjan
ashishwave
Offline Send Email
Nov 8, 2005
2:10 pm

Thanks for the information Ashish Hello Guggiusers, As long as the oipXX.dll where XX = 8 or 9 or 10 depending on the database version is installed and ...
Shakti <skgoel@...>
shakti_k_goel
Offline Send Email
Nov 9, 2005
4:18 am
Advanced

Copyright © 2009 Yahoo! Inc. All rights reserved.
Privacy Policy - Terms of Service - Guidelines - Help