Subject Problem with insert
Author erikmlakar
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?