Recent content by jfreak53

Well I think I want to go with caching the DB locally. But like I said, how do I cache a DB locally and then run my SQL commands on that local version?

No the program itself is fast, if I use a localhost connection to the DB it is fast, it is the fact that it is pulling 10K cats over the NET. I have a 1024 connection so that's not it, it gets slow waiting for the cats. The other connections are fine, when it downloads the manufacturers or the...

Ok so now the big question, how do I cache a DB in Delphi? I have been working with DB's in delphi for many years but never learned how to cache one, how do I do this? Right now it uses as the index of the table the category_id field, so that's already set and works quite nicely actually, I...

Yes actually, my SQL statements grab only what's needed. Problem being is that for the program to function the WHOLE list of categories is needed no matter what. Or the user does not know what they are doing if the whole list of cats is not there. But yes, in other scenarios that is all it's...

Ok so my previous questions have been worked out all good, thanks everyone. Now I have one regarding DB problems. I have MySQL DAC installed and querying data from a remote MySQL DB. Everything works fine, the only problem is that one of my clients has a HUGE db, we're talking 10K plus items...

Yeah well I've been there once again this morning and still breaking so I am going to have to make a small hack to make it work the way I want it to. Ok I found a demo, but I need this now. How would I make a function that takes a string and finds the last occurence of a "space" for instance...

Hmm it would be an option yes, but about 6 months ago I tried that and for some reason it wouldn't install on my Delphi, I mean it installed but I had major major errors. So I just forget it. I would really like to find something for this version if possible. If not I guess I can try that...

Does anyone know where I can find a good exmaple or tutorial on Delphi 6 and Indy 8 for FTP? I found one for indy 10 but to be honest the differences I see are too much. Any ideas? I just want a simple directory lister and navigator, that's it. But between indy 10 and 8 are driving me crazy...

Hmm interesting, maybe it is something with my IE. Hmm, I will try a couple of things with it then. So msn with errors, who would guess Microsoft had errors ha ha ha. Thanks for the help.

It's an image cropping component, it's exactly like TImage component in the way it works, it just allows for cropping. And before I installed this component I had the same problem with the tImage component.

OS is XP SP2, and IE is 8. But I did try it on another XP install, brand new one, with IE7, still same. procedure TakeBrowserScreenShot(doc : IHTMLDocument2; Image : TCropImage); var ViewObject: IViewObject; sourceDrawRect: TRect; begin Doc.QueryInterface(IViewObject, ViewObject); if...

Hmmm, ok I am attaching two pictures so you can see what it is doing to me. It works the first time, loads google just fine. But when I put in another address, it still comes up with a blank image on the canvas. Is there another way, like destroying it and then recreating? Or is this just an...

Ok still no go, it navigates just again doesn't clear the canvas of the TImage component. Ok maybe I didn't explain what was happening right. The program I have browses, no problem. And on the first time it takes the screen shot just fine, no problem. What it doesn't do is if I try to...

Ok after finding out I needed MSHTML in my uses clause I now get these errors: [Error] Unit1.pas(1126): Missing operator or semicolon [Error] Unit1.pas(1126): Statement expected, but expression of type 'Text' found [Error] Unit1.pas(1127): Undeclared identifier: 'Timer_detectdlg' [Error]...

Ok so I have this Timage control on the board, and I am taking a screenshot of a tbrowser component, and that works fine. The problem is that if I go to another web page the old image stays in the image control and the new one doesn't load. How do I clear this canvas and re-load something new...