hii all, I want to retrive limited number of data from a large amount of data.I am using oracle database and OO4OLE for connection from my asp page. I would...
hi all, i just saw the query which was posted by one of the members about inserting image in the database.i am just trying to insert the image directly in the...
Hi Pallavi Let me know what tools u r using. Regds Mahesh Sethuraman Wellington House, 273 - 275 High Street, London Colney, St Albans, Herts, AL2 1HA Tel:44...
I know Oracle 9i comes with OCCI which is a C++ Classs Library version of the OCI. One feature in OO4O that you rarely find in other similar Oracle products is...
Adrian Capp
a.capp@...
Jan 18, 2002 9:25 am
1288
I believe that ODBC is the main alternative to OO4O. ... -- Ken Sutherland J-MAC SYSTEM, INC. 81+11-726-6262 ken@... http://www.j-mac.co.jp...
I have some llama questions regarding OO4O. Can anyone point me to a good FAQ? The online docs aren't all that helpful. Just a teaser: I'm trying to test my...
Hello I would appreciate some advice on increasing the speed of processing fields from an Oracle Database. I have a client\server situation and I require the...
Probably the best thing you could do is use 'GetRows' instead of MoveFirst/MoveNext. GetRows just puts the entire recordset into an array, and moving through...
Hi, Could someone explain to me how to use the following OraDataBase's method CreateCustomDynaset (SQL, Options, sliceSize, PerBlock, Blocks, FetchLimit,...
I don't know, but it should be slightly faster or lesser slow. But I think you're expecting another kind of suggestion. With Dynaset For i = 0 To Fieldcount -...
Have you considered doing the concatenation at the server end? If each row returned was just one field rather than 12 there would be less to do in the loop. ...
Jim Markham
jim.markham@...
Jan 25, 2002 5:40 pm
1295
There is no need for you to execute the "Set Field = Fields(i)" command in the 2nd "i" loop inside the process of the rows in the dynaset. First, this is an...
doug.boling@...
Jan 28, 2002 1:39 pm
1296
This should be considerably quicker: Private Session as OraSession Private Database as OraDatabase Private Dynaset as OraDynaset Private Fields as OraFields ...
hi, i am creating an module which will generate Storedprocedure for Oracle table using VB. I write the Storeprocedure in VB and i need to store it in Oracle. ...
1. I have been recently asked to check and improve the performance of a Vb dll, which is used in a web application. The person who designed the application has...
I'd imagine whichever SQL statement you use to generate procedures through SQL Plus would work just as well within VB, just use the 'execute' method, and know...
1) If you have lots of visitors, it's probably better not to store the connection in your session object. This is because each new visitor will cause the...
Thanks To Fabio who informed my of the slow speed of the '&' operator. Using an adapted StrConcat function I improved performance by a further 26 seconds. ...
... Of course it does -- or atleast the latest version does (I'm using 3.11). 'assuming a database pool has been created in the OraSession variable dim...
Just to know.. why don't you use a view to return you a single field already concatenated, instead of cycling through all the fields in the for..next loop? ...
I don't know if it would work but it should be worthy a try... The server machine probably is better than the client one. Probably, I don't know, Oracle may...
Latest News :-- #9658;Because of lots of requests, the exam rates are slashed drastically Check the rates at the end (MCSE pack & CCNA +CCNP pack for as low as...
Thanks to all the people giving me ideas... To Sam Berlin... it turned out I had an old version of 0040 and hence I had no GetRows method. I have since...
I have Oracle 8 personal edition and OO4O. But I don't seem to have a documentation of properties and methods of the objects. Can someone tell me what...
Can you use oo4o with personal edition? I haven't heard anything either way, though I'd tend to guess 'no'. I'd be interested to know if its possible. Sam ...
I have OO4O apps running against personal oracle on my laptop with no difference or problems at all. Works very well. Regards, Todd Trask MicroEase Ltd. ... ...
Trask, Todd (ELG/EGL)
ttrask@...
Feb 8, 2002 12:52 pm
1311
Look for the help file that installs with OO4O; it contains all the documentation. You should have a shortcut to it from your start menu if OO4O is correctly...
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.
