Search results for query: *

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 =...

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...

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...

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.

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?

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...

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

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?

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

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...

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...

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...

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...

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?

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...

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...