Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

Register Log in
  • Congratulations Rhinorhino on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Search results for query: *

  1. LucieLastic

    HTML component recommendations

    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
  2. LucieLastic

    HTML editor component recommendation

    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
  3. LucieLastic

    How to stop Delphi 2010 auto formatting my code

    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
  4. LucieLastic

    EasyMapi and Outlook's api questions

    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...
  5. LucieLastic

    Possible to Group By on a function?

    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...
  6. LucieLastic

    Whats the max. size of an SQL Query in SQL Server 2005?

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

    Help needed converting ftBytes to string

    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...
  8. LucieLastic

    Importing from Excel - Nulls for blank varchar fields & Ref Integrity

    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...
  9. LucieLastic

    Ref. Integrity constraint on a PK and across diff schemas - problem

    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...
  10. LucieLastic

    Setting properties on a file, eg Author, owner etc

    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...
  11. LucieLastic

    Poss. to bring window to front without focus?

    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...
  12. LucieLastic

    Delphi 2010 - how can I unembed my forms in IDE? & couple of Qs

    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...
  13. LucieLastic

    Is it possible to log who connects/disconnects and when?

    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
  14. LucieLastic

    Limit no. of lines shown in a TMemo - show latest lines only

    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...
  15. LucieLastic

    Add Radiobuttons to RadioGroup at runtime

    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 ...
  16. LucieLastic

    MSComm32.ocx - 'License information for TMSComm not found'

    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...
  17. LucieLastic

    Read & Write to USB Port - anyone done it?

    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.
  18. LucieLastic

    DELETE FROM with INNER JOIN doesn't work

    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
  19. LucieLastic

    Group by question - counting records within a group

    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...
  20. LucieLastic

    ExcelApp.ConnectTo error -2147352565

    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...

Part and Inventory Search

Back
Top