I am having trouble executing this in visual basic: strQuery2 = "Select Max(invno) ""invnomax"" from master" Set OraMasterset =...
Barry Stubbs
bgs@...
Apr 2, 2001 6:45 pm
1082
Try this: tmpinvno = OraMasterset.Fields(0) ... From: Barry Stubbs To: oo4ole@yahoogroups.com Sent: Monday, April 02, 2001 11:43 AM Subject: [oo4ole] returning...
Gennady
gennadyb@...
Apr 2, 2001 8:30 pm
1083
... FIELDS PROPERTY Applies To: OraDynaset Description: Returns the collection of fields for the current row. Not available at design time and read-only at run...
Antonio Guadagnin
antonioguadagnin@...
Apr 3, 2001 6:54 am
1084
You have given the Max(invno) column an alias of invnomax. So I expect that has become the field name. So you can either remove the alias and run the query...
Jim Markham
jim.markham@...
Apr 3, 2001 7:42 pm
1085
You can try with GetFieldByOriginalNam ... (invno). If I ... something...
rkumar@...
Apr 4, 2001 9:34 pm
1086
Hi all, I am writing a VB6 app with Oracle 8.1.6. DB. I want to have my app working without any pb whatever are the local windows settings of the user (french...
stephane@...
Apr 14, 2001 7:17 am
1087
Anybody know of a site that summarizes which features of the latest oo4o are not supported by Oracle 7.3?...
Louie_Medina@...
Apr 25, 2001 2:14 pm
1094
I am getting the following error: SQL execution error, ORA-00905: missing keyword Code: sql = "SELECT cola, colb from DB1 FOR UPDATE WHERE Cola = 'abc'" ...
Hugh.Guilbeau@...
May 1, 2001 9:39 pm
1095
IIRC, you cannot use the SELECT... FOR UPDATE syntax together with the dynaset edit/update methods. Tim Romano ... From: <Hugh.Guilbeau@...> To:...
Tim Romano
tim@...
May 2, 2001 1:06 am
1096
Hi all, I hope i'm not too far off topic here but can anyone answer me this: Precompile step in code I no nothing about. /oracle/product/8.0.5bin/proc code=cpp...
mgcornick@...
May 2, 2001 8:12 pm
1097
Hello, I have the following problem using oo4o 8.1.7.3.12 with VC++ 6.0: I can detect a disconnection but I cannot reconnect to the server. There is no problem...
Roberto de Paiva
rpaiva@...
May 2, 2001 10:29 pm
1098
Thanks for the suggestion, but the examples in what little documentation there is for 0040 show "select ... for update ...". When I take out the "for update" I...
Hugh.Guilbeau@...
May 3, 2001 12:16 am
1099
Hugh, Here's what I have in my oo4o help file: "Normally, when a dynaset is created, rows are not locked in the database until Edit is invoked. If this is not...
Tim Romano
tim@...
May 3, 2001 2:47 am
1100
Your installation is probably broken in one of two ways: 1)You do not have the correct version of the oracle client installed from that version of Pro*C or it...
Mark Tomlinson
marktoml@...
May 3, 2001 3:20 am
1101
Doesn't the FOR UPDATE clause need to go after the WHERE clause? ... __________________________________________________ Do You Yahoo!? Yahoo! Auctions - buy...
c shay
cshay@...
May 3, 2001 7:11 am
1102
Where can I get a description of the methods of the oradc with VC++ ? How can I use the wrapper-classes? Thanks!...
Peter Burucker
pburucker@...
May 3, 2001 11:52 am
1103
I finally figured this out, and I think that it is a bug. When I do the select with column names (particularly a date), it will not work. If I code select * it...
Hugh.Guilbeau@...
May 3, 2001 10:39 pm
1104
hi 0040 folks i'm trying to call the stored PL/SQL function below, grab the boolean result into an Excel VBA variable with no luck. I could find no examples of...
dalemotsiff@...
May 7, 2001 3:36 am
1105
Hi We have tried this also but to no avail (Not sure if possible ?) We have however found a work around though, this bascially uses an extra parameter for...
padraicmulligan@...
May 8, 2001 12:03 pm
1106
interesting solution. if i understand you correctly, you no longer write PL/SQL "functions" which return a single value, but now your code returns "out"...
dalemotsiff@...
May 9, 2001 4:12 pm
1107
Hi Guys, Does anyone knows if the oipsr** files created by oo4o on my tempdir can causes crashes on my application? The environment I am using is VC++ and...
Roberto de Paiva
rpaiva@...
May 9, 2001 8:41 pm
1108
Hi, i have a problem with inserting big number of rows from an VB Application into Oracle. In the pas i used a 16-bit VB Application in conjunction with Oracle...
Stefan.Waldschmitt@...
May 10, 2001 7:36 am
1109
Dale Here is the answer taken from URL http://technet.oracle.com/doc/oracle8i_816/nt.816/a99998/o4o00321.htm Sample function is found in O4OO Pack 'Execute the...
padraicmulligan@...
May 10, 2001 1:49 pm
1110
Guys I am using Executesql and am having some untraceable speed problems. When I use OO4O or ADO to execute simply SQL queries speed is very good and compable...
padraicmulligan@...
May 10, 2001 2:19 pm
1111
When you run the code in sqlplus you already have a session open, but I notice in VB you are opening a new session which than has to connect to the database...
Griffiths, Stewart
stewart.griffiths@...
May 10, 2001 2:37 pm
1112
Dale I'm not working with PL/SQL functions but with packaged procedures, but the solution I'm using for the BOOLEAN parameters can be applied to function...
Guido Schmutz
guido.schmutz@...
May 10, 2001 2:54 pm
1113
Griff In the example I have created I have removed all the connection pooling that is used (This application runs under MTS) But I am allowing of the extra...
padraicmulligan@...
May 10, 2001 3:51 pm
1114
thanks Guido. I haven't had a chance to fiddle with the code for a function, but you're right, that looks like it should work for me fine. also, thanks for...
dalemotsiff@...
May 11, 2001 4:40 pm
1115
Hi Dale Yes, I'm using my own generator to generate 100% of the necessary code to access PL/SQL procedures from VB via OO4O. Originally the generator was build...
Guido Schmutz
guido.schmutz@...
May 14, 2001 4:20 pm
1116
that's some beautiful work Guido! now you've opened my eyes to whole new slew of questions about auto-coding from the data dictionary. immediately after...
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.
