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 Chriss Miller 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. ludmart

    Selecting Distinct for a Condition B-)

    Please supply more info, then someone may be able to assist.
  2. ludmart

    Merging all overlapping time periods in a table

    This is a simplified example of my actual table: CREATE TABLE TimePeriods( TimePeriodID int IDENTITY (1, 1) NOT NULL , StartDateTime datetime NOT NULL , EndDateTime datetime NOT NULL ) ON [PRIMARY] StartDateTime will always be less than EndDateTime. The table may contain...
  3. ludmart

    4 fields, all numbers need to select max...

    This will give the same results, but may be easier to expand if more lengths must be compared. I dont know about performance. select fish_id, MaxLen = ( select max(AnyLen) from ( select AnyLen = length1 union select length2 union select...
  4. ludmart

    How to include Record Number in Query Result

    Assume your table was called YourFirstNameLastNameTable. You may first select into a temporary table, with an Identity column added for the Record# column, then select from this temp table: SELECT [Record#] = IDENTITY(int, 1, 1), FirstName, LastName from YourFirstNameLastNameTable into...
  5. ludmart

    TDateTimePicker, Check Box when showing time.

    Correction for my previous question! "TDateTicker" should be TDateTimePicker! Sorry.
  6. ludmart

    TDateTimePicker, Check Box when showing time.

    When I set a TDateTicker's Kind := dtkTime and ShowCheckBox := True, then, at runtime, if I select the hours, minutes or seconds, and try to increment or decrement it using the up-down control on the right, it only works once. It looks like the focus shifts to the checkbox. Any work-arounds for...
  7. ludmart

    OpeningProjects

    The way I use is to create a shortcut to delphi32.exe file, either on the Desktop or on the start menu, and the change the "Start In" property to the roor of my project folder. This only means that when I start Delphi, or I start a new project, the "Open" and "Save&quot...
  8. ludmart

    I need a ComboBox with Height less than 19 pixels.

    I want to use a TComboBox as an in-place editor on another control. It needs a drop down list. Such a combobox does not allow me to set the height to less than 19. Is there a quick-fix for this, or will I have to create my own component.
  9. ludmart

    SQL Needed to Compare Two Tables

    The "minus" is not an operator in SQL Server. The following: select * from updated_table minus select * from other_table simply means that the minus is a table alias for the table of the firts select statement. This is therefore simply two select statments, and not what is required.

Part and Inventory Search

Back
Top