Subject | Problem with insert |
---|---|
Author | erikmlakar |
Post date | 2006-08-24T14:34:39Z |
I am using IB_Query, IB_Datasourse, IB_Connection, IB_Transaction
TABLE IN Firebird is
CREATE TABLE TEAMS (
AUTONOM INTEGER NOT NULL,
TEAMNOM INTEGER NOT NULL,
TEAMNAME VARCHAR(40) NOT NULL;
ALTER TABLE EKIPE ADD PRIMARY KEY (AUTONOM);
When a simple query in program. Here everting is ok. I not using
trigger to determinate wich AutoNom is next, but I am using my own
avtoinciment function witch work very good and it is set on
IB_QueryNewRecord.
SELECT
TEAM. AUTONOM,
TEAM. TEAMNOM,
TEAM. TEAMNAME
FROM
TEAM
WHERE (1=1)
Problem is next:
IF i have query like
SELECT
TEAM. AUTONOM,
TEAM. TEAMNOM,
TEAM. TEAMNAME
FROM
TEAM
WHERE (1=1) And (TEAM. AUTONOM >= 1 and TEAM.AUTONOM <= 1)
And I am trying to insert values (5, 1, 'PRO TEAM'), the values are
all correct but when i post the query. Values disapear from the grid
wich is correct. Then I am going to look the record in the base and it
isn't there , but there is a record wich have values ('-3242343453',
Null, Null').
What is here wrong?
TABLE IN Firebird is
CREATE TABLE TEAMS (
AUTONOM INTEGER NOT NULL,
TEAMNOM INTEGER NOT NULL,
TEAMNAME VARCHAR(40) NOT NULL;
ALTER TABLE EKIPE ADD PRIMARY KEY (AUTONOM);
When a simple query in program. Here everting is ok. I not using
trigger to determinate wich AutoNom is next, but I am using my own
avtoinciment function witch work very good and it is set on
IB_QueryNewRecord.
SELECT
TEAM. AUTONOM,
TEAM. TEAMNOM,
TEAM. TEAMNAME
FROM
TEAM
WHERE (1=1)
Problem is next:
IF i have query like
SELECT
TEAM. AUTONOM,
TEAM. TEAMNOM,
TEAM. TEAMNAME
FROM
TEAM
WHERE (1=1) And (TEAM. AUTONOM >= 1 and TEAM.AUTONOM <= 1)
And I am trying to insert values (5, 1, 'PRO TEAM'), the values are
all correct but when i post the query. Values disapear from the grid
wich is correct. Then I am going to look the record in the base and it
isn't there , but there is a record wich have values ('-3242343453',
Null, Null').
What is here wrong?