Search results for query: *

hi All I need an HTML editor component, could anyone recommend one? It doesn't need to be free as I have approval from the powers above to buy something. Just need a good one. Many thanks Lou

hi I need a component where I can set the 'source' property of html, it displays it and allows the user to type in and edit the display. Then it creates the appropriate html source. Are there any components out there? Preferably not too expensive. many thanks in advance Lou

hi Could someone tell me where and what option to set to stop Delphi 2010 automatically wrapping lines and reformatting them please? It's driving me potty! Many thanks Lou

hi Has anyone used Outlook's api to track, create and log emails? I've written an email tracking system that uses EasyMAPI. It captures emails coming in and out, searches them for anything of interest, if interesting, extracts info from the email, copies it to another public folder and logs...

hi I'm trying to get the tail end of ICValue and then group by the tail end and PrefDisp fields. Is it possible? I have this at the moment which I was hoping would work. Ultimately, I want to extend it to get me the count of each 'tailend' for each PrefDisp. select PrefDisp, ICValue...

Whats the maximum character limit for a query in Sql Server 2005? Many thanks Lou

hi I'm reading a memo field from Sybase and would like to store it in a varchar field in SQLServer. I know that the field contains a hexadecimal number but they're stored as binary on the Sybase end. When I read this field in the field.datatype is ftBytes. How can I convert this hexadecimal...

hi I'm trying to import a spreadsheet. One of the columns has all text data with the odd blank cell and the appropriate field in the DB has a referential integrity constraint on it. For blank XL cells, I need a NULL to be inserted but sql server, I believe, is trying to import a blank string...

hi I have the same table in two different schemas, one of them is acting like a static table and the other is used for test loads of the data we send to the client. The tables have a composite PK but I only really need to check the asset_id col but if I have to use both cols in the PK in the...

hi All I'd like to set the following properties on a file, is it easy to do? Does anyone have a simple example I could steal? I need to get it done quickly and I haven't, as yet, found a relevant example on the net. LastModified Datetime DateCreation Datetime Author Owner Comments Many...

hi I have an app which monitors processes for errors, if an error occurs I want my app to come to the front but not take focus off whatever the user is working in, is this possible? I've tried the following calls but each one makes my monitoring app take focus...

hi All I've just moved over to Delphi 2010 from D7 so I'm still getting to grips with it. 1, I'd like to unembed my forms so I can have my form on one monitor and the code on another. How can I do this? I'm getting a bit fed up at having to do F12 evertime to switch between form and code...

hi All I'm trying to formulate a matrix of all the processes and applications running in our company that connect & disconnect to the different databases when. Is it possible to log this information somehow? Many thanks in advance Lou

hi I'm using D7 and have a TMemo which receives quite a lot of text. Is there a way of limiting the number of lines shown so it always displays, say the last 20 lines added. That is, I want the older lines removing automatically. I thought I could use the Capacity property but no. I know I...

hi all I'm trying to add some radio buttons to a radiogroup at runtime but can't get it to work. I've tried the items.addobject because I need to store the id and explicitly creating the radio buttons but to no avail: procedure TDataModMain.GetRadioButtons(radiogroup : TRadioGroup; sql ...

To assist me in talking to a modem, I wish to use the MSComm active X component. I've managed to install it etc but when I attempt to drop it on my form, I get the following error: License information for TMSComm not found. You cannot use this control in design mode. Reading stuff on the...

I need to find information on how to read and write to a USB port, can anyone point me in a direction as I haven't a clue where to start. Found info on serial port comms but not USB yet. Using D7 btw. Many thanks in advance Lou.

hi What have I done wrong here? delete FROM TestError inner join Test on Test.ID = TestError.ID where Test.State = 1 Test table contents ID State 1 1 2 NULL 3 1 4 2 5 3 6 3 7 2 8 1 9 NULL TestError contents: ID Status 1 A 2 B 3 C 4 D 5 E 6 F 7 G 8 H 9 I Many thanks in advance. Lou

hi All I thought this would be straight forward but can't get it to give me the right results. I have an extract of a simple table as follows ID TypeID 1 2 1 2 1 3 1 2 2 1 2 1 2 1 I;d like the following results. It gives me a distinct count of the...

hi I've written some very simple Excel automation stuff which runs fine on most machines but on 2 machines I get the message "Error -2147352565 has occurred" which isn't very intuitive. The machines are running the exact same version of Excel. The error occurs on the ConnectTo call, the...