Hi All/Helen,

>What version of the database are you using?

WI-T6.2.679 FireBird Release Candidate 2

>What are you using to do the insert?

The SQL for the TIB_Query:-

SELECT COVEREDMEM.RELATIVETYPEID
,COVEREDMEM.PERSONID
,COVEREDMEM.FUNDID
,COVEREDMEM.OPTIONID
,COVEREDMEM.MEMBERID
,COVEREDMEM.STATUSID

,PERSON.PERSONID
,PERSON.FIRSTNAME
,PERSON.SURNAME
,PERSON.DOB
,PERSON.TITLEID
,PERSON.INITIALS
,PERSON.HOMETEL
,PERSON.WORKTEL
,PERSON.EMAIL
,PERSON.ID
,PERSON.UNIONID
,PERSON.GROUPID

,(SELECT TITLE
FROM TITLE
WHERE TITLE.TITLEID = PERSON.TITLEID)
AS TITLENAME

,(SELECT NAME
FROM RELATIVETYPE
WHERE RELATIVETYPE.RELATIVETYPEID =
COVEREDMEM.RELATIVETYPEID)
AS RELNAME

,(SELECT MEMSTATUSNAME
FROM MEMSTATUS
WHERE MEMSTATUS.MEMSTATUSID =
COVEREDMEM.STATUSID)
AS STATUSNAME

,(SELECT NAME
FROM UNIONS
WHERE UNIONS.UNIONID = PERSON.UNIONID)
AS UNIONNAME

,(SELECT GROUPNAME
FROM GROUPS
WHERE GROUPS.GROUPID = PERSON.GROUPID)
AS GROUP_NAME

FROM COVEREDMEM

JOIN PERSON
ON (PERSON.PERSONID = COVEREDMEM.PERSONID)

WHERE (COVEREDMEM.MEMBERID = :MEMBERID)
AND (COVEREDMEM.FUNDID = :FUNDID)
AND (COVEREDMEM.OPTIONID = :OPTIONID)

The SP in the UpdateSQL of the TIB_Query:-
Execute Procedure Insert_CovMem( :CoveredMem.PersonId
, :Person.ID
, :Person.INITIALS
, :Person.FIRSTNAME
, :Person.SURNAME
, :Person.TITLEID
, :Person.HOMETEL
, :Person.WORKTEL
, :Person.EMAIL
, :Person.UNIONID
, :Person.GROUPID
, :Person.DOB
, :CoveredMem.MEMBERID
, :CoveredMem.PERSONID
, :CoveredMem.RELATIVETYPEID
, :CoveredMem.OPTIONID
, :CoveredMem.FUNDID
, :CoveredMem.STATUSID )

The Update works fine, I don't get the error at all. I have another
insert(exactly the same as above, conseptually that is), but with no date,
and it works.

>What EXACT data type is the database column to which the value is being

pushed?
DATE

>Do you have any monitor output you can show us?

Please see attached - sorry, this is the best method I know to get the
visuals to you without wasting your time.

Many Thanks,
Dion.







---
Outgoing mail is certified Virus Free.
Checked by AVG anti-virus system (http://www.grisoft.com).
Version: 6.0.314 / Virus Database: 175 - Release Date: 01/11/2002



[Non-text portions of this message have been removed]