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

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'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?

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

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