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: *

  • Users: Sonix
  • Order by date
  1. Sonix

    DDQ: Lookup stored proc doesn't return value

    I'm using a data driven query with a lookup query that calls the following stored procedure: CREATE PROCEDURE sp_getnextid ( @key CHAR(20), @next_id d_count OUTPUT ) AS SELECT @next_id = (NEXT_NO+1) FROM NEXT_NO WHERE NEXT_KEY = @key UPDATE NEXT_NO SET NEXT_NO = @next_id WHERE NEXT_KEY =...
  2. Sonix

    File import to Table with validation help

    I'm new to DTS and scripting and want to create a DTS to automate import from a text file (csv) into a database table using the following rules. The text file may be updated a number of times in the day and so I want to fire this routine regulary. Most importantly it must follow the rules. 1...
  3. Sonix

    GET URL

    If you simply what to visually see the page in the default browser then add ShellAPI to your uses clause and uses ShellAPI; var MyUrl: String; procedure DoIt; begin ShellExecute(0, 'open', PChar(MyUrl), '', '.', SW_SHOWMAXIMIZED); end; If you want to do it behind the scenes...
  4. Sonix

    How can I search the registry for any instance of a certain key?

    Out of interest did you work this one out, I also need to know now? I've searched the net but I still havn't found the answer.
  5. Sonix

    How do I set up a sequence/generator in Access?

    So you have use your own table to do this. Hmm, I thought it might come to that. You sure you can't call the autoincrement operation manually by some API or SQL?
  6. Sonix

    How do I set up a sequence/generator in Access?

    I don't want Access to automatically populate the value of the primary key (numeric) column of a table i.e. use autoincrement columns. Instead I want to call the function (as you would use a sequence in databases like Oracle) directly so that I can set the value of the column manually in my app...
  7. Sonix

    Can you parametise a script ?

    I want to essentially pass a parameter (the path to the datafiles) to my createtablespaces.sql script. Could you explain how I may use this feature to solve my problem? Thanks in advance
  8. Sonix

    Batchfile for replacing occurance of one string in a file w another?

    I'm really desprate for some example code for doing this I don't want to use 3rd party utilities or scripting languages? Can anyone help?
  9. Sonix

    Embedded 'Select' in stored procedure won't work!

    Can you show us the SQL, maybe theres some brackets missing?
  10. Sonix

    Can you parametise a script ?

    I'd like to parametise a sql script in this way ... svrmgrl @createtablespaces.sql 'c:\oracle\data\' So if the script connects say as system then issues ... create tablespace t1 ... <path>\data01.dbf / create tablespace t2 ... <path>\index01.dbf / it will use the path in the parameter to...
  11. Sonix

    HELP! installing 8.1.7 on Linux is driving me mad!

    I've now tried to edit the shell script but it was to no avail. I even went to lengths of deleting the file and rewriting it manually. But when I ran it I still get ... file or directory does not exist Also, I tried running the second runInstaller (the binary file) as root and got a message...
  12. Sonix

    HELP! installing 8.1.7 on Linux is driving me mad!

    Hi, The CD was created with Windows however I don't find the terminal characters you talk about. Also just to clarify there are two runInstaller files and they are NOT symbolically linked or anything. The first one as you say is a sh shell script, which when looking at the code I can see...
  13. Sonix

    HELP! installing 8.1.7 on Linux is driving me mad!

    I'm having difficulties installing 8.1.7 for Linux (as distributed at the technet site). I'm using Mandrake 7.1 and the Oracle files have been put onto a CD - which I'm trying to install from it. I've closely followed the instructions as supplied by http://jordan.fortwayne.com/oracle/817.html...
  14. Sonix

    Problems publishing files

    Thanks for the reply however I've also tried this ... ftp://localhost/t1.html but I get the error ... A network error occured while Netscape was receiving data (network Error: Broken pipe) Try connecting again Can you tell us what I'm doing wrong?
  15. Sonix

    Problems publishing files

    Hi, I'm running Apache on Linux as a local setup and I'm trying to publish some files to it using Composer. I know Apache is running but when I try to publish a file I get the following message... Netscape: 405 Method Not Allowed Error uploading files The server responded: Method Not Allowed...
  16. Sonix

    Beginner..., I have it installed but...

    If 'nothing happens' it actually means that the server started without any problems. But double check by running this in a command window ps -ef | grep httpd If you see a list like ... root 2323 ... ./httpd nobody 2324 2323 ./httpd It means that its running OK (p.s. to shut down...

Part and Inventory Search

Back
Top