PANTLORD
| Real Name: |
PANTLORD [Unspecified]
|
| Primary Role: |
Coder |
| Joined: |
Feb 2002 (19 years ago) |
| Visits: | 35 |
|
|
|
|
Email Not Verified!
Once email is verified, we will review and approve the account.
|
|
Web Presence Hidden.
Once above is taken care of, full Profile content will display including back links, about me, my message, custom Profile html,
social networking links, message board signature, company profile, etc.
|
 Message Boards Activity
5 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
Anonymous | ComboBox.clearselection;
:) ..
---
salambanan
|
| 
 11538
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 
PANTLORD | Hi again,, , Found a solution to this outlined below., , SQL.Add('WHERE OPERATOR_NAME = "'+OpNameCombo.Text+'"');, , Thanks, Niall :) |
|
2257
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 :) |
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!} |
1662
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
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 ? |
|
3435
Hits | 
DBA, Databases, & Data | |
|
|
|
PANTLORD
