IT SOLUTIONS
Your full service technology partner! 
-Collapse +Expand
PANTLORD
PANTLORD
Parent Co: PANTLORD
Search PANTLORD:

Advanced
-Collapse +Expand More Board Options
MOREINFO...
-Collapse +Expand My Moderator Settings
MODERATOROPTONS

BOARDSTATS
Posts: 16061
Threads: 4728
Topics: 95
Boards: 34
Groups: 34
 
   ► MB Lobby ► This Topic!  Print This     

PANTLORD Message Board Activity

  


5 Message Board Posts:


Thread 5 of 5
Thread Starter or a Reply (but not last)  Group

PANTLORD
ComboBox Text won't clear.
Hi there,, , Does anyone know how to clear the text dispplayed in a combo box? Mine just holds the last value and doesn't overwrite it when I tab back to it ideally I want it cleared and ready for the next entry. , , I've tried setting .Text := ''; but it doesn't work even if I set it to '1'; it doesn't display a 1 only the previous value. The whole text line seems to be higlighted rather than just the text. Any ideas?, , Thanks, Mully
Posted to MB Topic: Delphi VCL « Delphi Board
19 years ago

Anonymous
ComboBox.clearselection; :) ..  --- salambanan
8 years ago
Nothing New Since Your Last Visit
11542
Hits

Pascal and Delphi Coding

Thread 4 of 5
Thread Starter or a Reply (but not last)  Group

PANTLORD
SQL won't work with combobox as param!
Hi there,, , I am trying to pass the text from a combo box I have to an SQL statement but it doesn't seem to like it. It keeps taking the combobox text as a field which it is not i.e. it is a value in the field., , OpDetailsSQL.SQL.Add('SELECT OPERATOR_LEVEL FROM OPERATOR_DETAILS WHERE OPERATOR_NAME =' + OpNameCombo.Text);, , Any ideas ? Ideally i would like to have two where parameters in the statement one from a combobox the other a text box., , Thanks, PL I
Posted to MB Topic: Delphi Single User Apps « Delphi Board
19 years ago

PANTLORD
Hi again,, , Found a solution to this outlined below., , SQL.Add('WHERE OPERATOR_NAME = "'+OpNameCombo.Text+'"');, , Thanks, Niall :)
19 years ago
Nothing New Since Your Last Visit
2258
Hits

Pascal and Delphi Coding

Thread 3 of 5
Thread Starter or a Reply (but not last)  Group

PANTLORD
Re: SQL won't work with combobox as param!
Hi again,, , Found a solution to this outlined below., , SQL.Add('WHERE OPERATOR_NAME = "'+OpNameCombo.Text+'"');, , Thanks, Niall :)
Posted to MB Topic: Delphi Single User Apps « Delphi Board
19 years ago
Nothing New Since Your Last Visit
2
Hits

Pascal and Delphi Coding

Thread 2 of 5
Thread Starter or a Reply (but not last)  Group

PANTLORD
Rollback won't undo all changes.
{Too Long!}
Posted to MB Topic: Delphi Single User Apps « Delphi Board
19 years ago
Nothing New Since Your Last Visit
1666
Hits

Pascal and Delphi Coding

Thread 1 of 5
Thread Starter or a Reply (but not last)  Group

PANTLORD
Cannot insert into triggered interbase field.
Hi there,, , I'm having trouble inserting a value into one of my interbase tables. The table in question has 5 fields, the primary key Operator_ID has a trigger set on it to autoincrement. It is a NOT NULL field as it is the primary key, so I don't enter a value via my Delphi front end. I have also set the required property for this field in Delphi to false., , I consistently am getting the message 'Field XXX requires a value however'., , Should interbase not handle this itself the trigger type is BEFORE INSERT. Within delphi I am using a DataModule with a an IBdatabase/IBTransaction/IBTable and a standard datasource as components and am attempting o do the insert via a navigation component and dbgrid. , , Any suggestions this thing is driving me crazy slowly but surely., , Thanks in advance, PL
Posted to MB Topic: Interbase « DBA Board
19 years ago

Simon Wood
I use this technique all over the place in my apps and don't see the problem that you have. I am using ObjectPAL and pass-through SQL., , Have you tried inserting a record using an INSERT statement in Windows iSQL ? If this fails then you have an InterBase problem otherwise it is something in your Delphi App, , Have you tried doing a simple hard-coded insert using a TQuery component under a button in your Delphi App ?
19 years ago
Nothing New Since Your Last Visit
3438
Hits

DBA, Databases, & Data
Sales Website: www.prestwood.com Or visit our legacy sales site: 
legacy.prestwood.com


©1995-2021 Prestwood IT Solutions.   [Security & Privacy]