I would like to know how to perform error handling for corrupted files? Currently if a db query is running and it encounters a file (dbf) that is corrupted and cannot be opened, it will hang at that point. I would like for it to be able to log the file that is corrupted and skip that file and resume...

What about error handling for corrupted files? Currently if a db query is running and it encounters a file that is corrupted and cannot be opened, it will hang. I would like for it to be able to log the file that is corrupted and skip that file and resume running the query. If anyone is willing to p...

Disk or network problems. Seeing some code might be helpful. If nothing else, what's on line 192? Its a db query. Line 191: Let>SQL=SELECT number, type, date, time FROM STAFFIO where station 'D' AND number '' AND Date IS NOT NULL AND Time dbID,SQL,ResultData,NoRowCount,NoFieldCount,1 The error usua...

I am experiencing a problem where MS hangs when I read a huge CSV file containing more than 10k records. What is another alternative to using csvfiletoarray? I have to read all records from the csv and then transfer it to the database. Would DB query be a better option? Or Readln (and removing the d...

Hi,

Is there a way to get MS to run even when the computer is logged off?

Hi guys

I am experiencing a random error in the midst of running a macro. I get a message box prompt saying "Line 192- Disk or network error". I click OK, and the macro continues as normal. What could cause such an error?

JRL wrote:Running your script and not getting any errors. I'm running v14.0.17 on WinXP SP3.

Have you tried closing Macro Scheduler and reopening it?

Sometimes the easiest problems can be solved by just opening and closing (or rebooting). After restarting MS, I can't simulate the problem any longer.

I am facing an access violation error at address 0020003D. Before this error, a debugging error shows, saying that the dialog already exists. I have been using the same script for other macros without any problems. Can anyone try to help me debug? Let>InsertCount=1 Let>ErrorCount=0 Let>UpdateCount=0...

Hi, May I know how to include a link as part of the body of the email using SMTPSendMail?

Say in my body, I want to include a link to http://www.facebook.com, is there a way to do that?

I have a notification saying that I have one new message but everytime I click on that link,i get redirected to the Forum home page http://www.mjtnet.com/usergroup/index.php. I have logged in already.

Hi, So far you guys have been really awesome in helping me out with my MS problems. My program currently calls an Excel file to read from it. Before I call it, I will have a task kill function to kill any running excel tasks. I will call it again at the end to make sure any excel tasks are closed. H...

Better yet if I am able to capture different variations entered by user, say EBB12-Jason , EBB12:Jason, EBB12 Jason. I guess I will limit it to 3 different variations "-" , ":" and " ". Too many and I will have a hard time. EBB12 is an ID by the way.

I need to read from a set of strings, eg EBB21-Jason or EBB203-Jason but I want to be able to capture only the code in front (EBB21 and EBB203 respectively). Which means I would have to capture any characters before "-". What is the simplest way to do that? Do I use regex? I am not familiar with reg...

Worked like a charm. Thanks JRL. Repped.

I have created this Dialog box. Can anyone teach me how to automatically timeout and close it after say 5s? I can do it if its a Message, but not sure how to for Dialog or MessageModal. Dialog>Dialog1 object Dialog1: TForm Left = 247 Top = 97 HelpContext = 5000 BorderIcons = [biSystemMenu] Caption =...