Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

Register Log in
  • Congratulations derfloh on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Search results for query: *

  1. listener22

    Oracle Forms - insert text at current insertion point

    Forms are discussed in Oracle: Enterprise Developer Suite, but that's usually a pretty quiet forum. Jim oracle, vb
  2. listener22

    Inserting information into an access database

    Right before the execute statement, put in msgbox that displays SQL, and see if you can spot an error in the string. Also check if SQL is reserved. Jim oracle, vb
  3. listener22

    Return Length of a String

    Isn't it just len(the_string)? Jim oracle, vb
  4. listener22

    VB / SQL help with add records

    OK, forget my first suggestion. The error message seems to be indicating that "Test" is read only. Can you verify that? Can you write a short routine that opens up Test, reads it, and attempts to update it? Use debug and highlight the various variables to see their values, if...
  5. listener22

    NT operating system command from PL/SQL

    if all else fails, find code for a daemon that will listen for commands via a pipe. You can find code like that on the internet, or in oracle's book on your version of oracle. In the stored procedure, pipe the command to the daemon, which will execute it. Well, in unix it's called a daemon, in...
  6. listener22

    VB / SQL help with add records

    Try moving the addnew outside of the Do section, so that it is a stand-alone command. Jim oracle, vb
  7. listener22

    How to find table name/s if a column name is known

    try sys.dba_tab_columns Jim oracle, vb
  8. listener22

    NT operating system command from PL/SQL

    try host Jim oracle, vb
  9. listener22

    How to put SQL update into a procedure

    Although in an insert method, order by is not needed... Jim oracle, vb
  10. listener22

    Run-time error 2486 - Access 2000 VB error

    Which line in the module does debug highlight? Jim oracle, vb
  11. listener22

    Inserting Array Values into dbase

    I don't remember for sure, but don't you have to provide a break or some such statement to keep the case statement from continuing on to to the next choice? Jim oracle, vb
  12. listener22

    Auto insertion of sequence in tables

    Note that depending upon your sequence buffer setting, among others, that you may experience some gaps in your sequence(s). The buffer gets some number of sequences, say 10 or 20, but if they're not used in some period of time, the remaining are tossed and the sequence starts again at a higher...
  13. listener22

    Long data tye

    Isn't there a way to convert a long to a varchar2, assuming the long isn't over 32k or whatever the current limit is? You could then convert the varchar2 to a number. Jim oracle, vb
  14. listener22

    Create XML using PL/SQL

    There's a book something like XML and Oracle that shows how to generate XML using Oracle commands. I'll take a look at the title tonight if you can't locate it. Jim oracle, vb
  15. listener22

    Cannot find data after commit

    is your exe multi-thread? Jim oracle, vb
  16. listener22

    Need to SELECT info from one table that is not in another table.

    Test it first, but if you are using embedded sql then Delete from Orderinfo where Orderinfo.ID not in (select Iteminfo.ID from Iteminfo) will delete the entire set of records. If you only want to clear the id in Orderinfo, use an update statement, instead. Jim oracle, vb
  17. listener22

    grouping

    first, to get only the records that have 'duplicates' in your select statement add having count(*) > 1 before your group by statement second, in Oracle sql*plus you can define columns, and you can define something like levels, sorry it's been too long, so that your report would...
  18. listener22

    Delete messages in Access table

    or, just delete from Board; ( as long as you don't have a where clause, all records will be deleted ) Jim oracle, vb
  19. listener22

    select distinct ... order by ...

    By the way, in Oracle you can order by some column(s) you don't select. Jim oracle, vb
  20. listener22

    Auto Database startup?

    There were some dbstart scripts that didn't work correctly; I think it had to do with the version (of Oracle) checking that they did. Make a copy of the script and either take out the checking or review/ modify it, or just hardcode your version in everyplace that a version is asked for. Jim...

Part and Inventory Search

Back
Top