Recent content by DerickD

Hi All, I have started working with Oracle and I have some very basic questions I am sure. Anyway, I want to check the a field contains 4 letters then 2 numbers : 1234ab = true 1234 ab = true ab1234 = false 1a2b34 = false 12a = false 1a234 = false 1234abc = false abc12345 = false...

As this was my first attempt at working with triggers, I have learnt a valuable lesson : Make Sure You Delete Unwanted Triggers. It works fine now!! Thanks alot nigelrivett, it sound as if you speak from experience :)

It still does not work .... :( I used : CREATE TRIGGER ValueTwo ON testTrigger FOR INSERT AS UPDATE testTrigger SET Value2 = testtrigger.Value1 + 100 from inserted , testtrigger WHERE testtrigger.ID=inserted.ID as it returned Value1 as Ambiguous, What is going on....When I insert a new...

I have done a search for Trigger questions an answers and there are lots... but I just can not get it working. I have a simple table with 3 fields: ID(autonumber);Value1;Value2 I want Value2 to always be 100 higher than Value1. So : CREATE TRIGGER ValueTwo ON testTrigger FOR INSERT AS UPDATE...

Perfect....! Thanks alot.

I do not think that I made my clear, I can see why you wrote that, I want to update the field TableOld.Missing with '1' where the file in TableOld does not appear in TableNew. This will allow me to then run a query in other tables to delete data where the filenames is the same and Missing =...

Hi Gnism, On winzip.com there is a download for winzip that makes it accessible from command the command line. You could then use these commands via the shell.command function in the code behind the button. Make some tests with it. I found that I could not zip files that were on network...

Hi 'yall I have a simple problem, but I just can not find a way of getting the SQL server to see that it is simple :) I have two tables, one with 10 records (TableOld) and one with 9 (TableNew). 9 of the records in both tables match. I wish to update TableOld with the one record that does not...

Hi all, Basicly, I need to extract the short (16bit) folder and file name into a table. If I use the parameter 'c:\' I want it to return strings like: C:\Proram`1\Kazaa`1\My~1\IN2043~3.WAV Is there a way? Thanks Derick

Hi All, I am trying to cerate a *.bat file but I need to somehow get a list of the files in the short name format. I have used dir /X and this brings back the name of the files in short, but I also need to get the name of the directory in short?? I am using a .exe where I need to place the...

Hi All, I have a job that runs every morning at about 04:00 and about 30% of the time, when I arrive at work the job is still 'executing'. I then have to stop the job and re-start it, and 60% of the time it works fine. When it runs correctly it only takes 1 minuet.... Is there a way to say, If...

Hi All, Thanks for taking the time..... I have a form in an asp page and as a security messure would like to Prevent people pasting information. This means that they have to type it out every time. Is this possble? Thanks alot again, Derick

Thanks for the offer shogun0803 but I am working in The Netherlands and do not think that my compnay would appreciate the phone call..... But. 1) The list is Hiarichal. 2) They use a drop down box with pr-defined selection. If you can send me the db at poopymail@popmail.com I have 5mb of...

Hi All, BASICLY: I want to have an Item in a list box selected automaticly? FULL: I have 4 list boxes next to each other. (Left to right) In the fisrt box you have 5 items, if you select one item, it brings up the relevant options in the second box, If you select an item in the second box it...

Hi All, Thanks for taking the time. I have a Database that imports all the folder names from a specified place and puts them all into a single column table. I would then like to go through each of these folders and delete the folder and all contents. So the original folders contain many more...