Recent content by mghafoori

How can I find the Owner or person who created a folder or file. I know I can use TsearchRec to find out the name, date, and attributes, but I can not find a routine that would give me the owner name. Any help is appreciated.

I use Cryptocx in delphi to decrypt files that i receive from our clients. some of the files can not be decrypted and some of them will. has anyone come across such problem. any suggestions. all of them use the same code to decrypt and the sender uses the same code to encrypt.

hello: I am using an activex component called Cryptocx which is used for PGP encryption. when i try to compile the package, i receive the following error: EasyByte_Cryptocx_TLB.pas(1246): Property setters cannot take var paramaeters I have talked to the author and they said it doesn't use...

Hello: I have Norton Antivirus 5.0 installed on Windows 98. Recently, i was installing my Comcast cable modem software and after all installation was done (successfully), the next time i rebooted my machine, i got a message that virus is found in memory and need to insert the rescue disk...

Hello: I am trying to use CopyFileTo to copy a file from one location to another in Delphi 6. When compiling my code, it comes up as undecalred identifier. Do I need to set any paths, or files. any help is appreciated. Also, is there a MoveFile function in Delphi or do i have to use copy...

Hello: I am trying to load a tab delimited file using sql loader. I know sql loader looks for WHITESPACES as a delimiter, but since none of my fileds are enclosed in any character, then as soon as it finds a space it tries to inser into next field which is too large and then i get errors. Is...

you should always put the function in " ". the Decode function should work if you put it in " "

I need to load about 1 million rows into a table that is indexed. I know you need to disable the index before the insert in order to speed the process. Currently, I drop the indexes and recreate them after loading. Is there a disable/enable index command. I found "Alter table disable...

I had tried dynamic sql method earlier, but i was getting some kind of error. I tried it again and now it works. Thanks Karluk for your input.

Hello: I need to find the 30th, 40th, 50th, ... percentile for a set of values. I know oracle has a percent_rank function, but it doesn't work the way i want it to. Therefore i wrot my own function to calculate that and in that function I need to get all the values and insert them into a temp...

Sorry, My Db_Block_buffer is 55,000 not 5,500 and the db_file_multiblock_read_count is 8. What is STATSPACK?

My db_block_size is 8192 and db_block_buffers is 5500 and sort_area_size is 20,971,520

Hello Forum, I am running into performance problem trying to update a large table (440 Million records). I have never worked on such a bigh table before. I tried running the following update statement and it did not finish in 48 hours and therefore i killed it: update /*+ index( r idx_hcpcs)...

I have a form that creates a batch file and I want to send a report from that file. I have the following syntax in my batch file. Does anyone know the exact syntax for sending a report in an e-mail: rwrun60 d:\cps\reports\Revenue_Pipeline_Summ.rep password PARAMFORM=NO DESTYPE=MAIL BATCH=YES...

How can i use parameters in a pass-through query. I know you can use & to get the user to enter a parameter in Oracle, but I can't use that in Access Pass-through. any help?