Recent content by jessicatx

From another Access/VB rookie, thank you, Zameer! The links look to be very helpful. BTW, I also looked at your Missing people site and appreciate your thoughtfulness in posting the links there.

Dave - I debugged it and found out that I am a little too quick at the ol' keyboard (but not accurate - you saw the title on this problem "S[COLOR=red]P[/color red]L*Plus" - s/b SQL!). I mistyped the directory name and SQL*Plus must obviously look for the directory name right away, even before...

I was just in the process of doing that when your last request came in. Here it is -- SQL> spool c:\spoolfiles\listtable.txt press Enter and this pops up - SP2-0332: Cannot create spool file. I never even get to the Select statement.

Dave - We are both in SQL*plus. I ran into this while trying to type in a Spool command as the first statement. Hit enter, and away it ran. She did the same thing and was able to go on her way entering more code. When I keyed in Select, I was able to (as you said would happen) continue coding...

Hope that someone can provide an answer to a puzzle that I have. One of my co-workers can get into SQL*Plus and use the enter key with no impact. She merely goes on to the next line. If I do that, it interprets that I have code all ready to go - and of course I get error messages when it tries...

Thanks. Appreciate the clarification.

Thanks! Do I understand you correctly - that I cannot upgrade from 8.0, and need to go to 8.5 BEFORE the 10.0 can be applied? (or am I just misreading?)

About to upgrade my pc to XP, but unsure if 8.0.1 will run okay under this OS. 8.0.1 is all that I have available now (supposedly, purchase of 10.0 is awaiting an OK from upper mgmt). Thanks in advance for any reply.

Left out some info: I don't know what the expected output should be. All I do know is that this input table (which carries actual and budget figures for each acctg. period) is definitely a View. This data normally is carried on two or more of the vendor-provided tables. Plus, this table has been...

I posted in a hurry and afterward, realized that I left out the (usual) basics: CR 8.5, Oracle db, ODBC connectivity. (Really, I am looking for magic, because this discovery has put us in a quandry.) I have already looked at the SQL query, which merely tells me the "how-to" for this report...

I have never used views nor have I ever used stored procedures. So my question may sound naive, but... In the process of upgrading our financial software, we have users testing their Crystal Rpts. because some of the db tables may have changed. Well, surprise, surprise! One of the accountants...

I read the back-and-forth info from a posting in November 2002, where someone had this same problem. I am in a quandry, because two of my to-be-exported fields are from formulas, and the formula name is always preceded by "@". What can I do? I assume that this is a special character, from the...

You caught me. I was cutting and pasting the code (because it was requested that I post it), and in getting rid of a bunch of my **comments**, I accidentally deleted the paragraph that you just mentioned. So I re-keyed it, and I made a goof (obviously). The actual code DOES read "go to...

Ygor - Where would I put this parameter - compiler directives? In Net Express's Compiler Directives, when I go into Advanced Directives, I see these settings - ESQL Preprocessor: OpenESQL Directive: DBMAN Current Settings: SQL(DBMAN=ODBC) Remarks say "Enables ANSI SQL92 Entry level...

Thanks, Abhijit. Here is some of the relevant code, which seems pretty basic. And yet... Hope the following sheds some light on my problem. Thanks for any ideas you can toss me. EXEC SQL OPEN AROIHDR-CURSOR END-EXEC. IF SQLCODE NOT = 000...