Search results for query: *

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

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

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

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

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

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

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

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.

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.