IT SOLUTIONS
Your full service technology partner! 
PANTLORD [Unspecified] -Collapse +Expand
-Collapse +Expand
PANTLORD
-Collapse +Expand Profile◄╣
Member Info
Member Narration

POSTS:
MB Posts (5)

Search PANTLORD:

Advanced
Personal Account . . .
PANTLORD
 (Inactive)
-- USA



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

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
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 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
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 :)
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
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
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
3435
Hits

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


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