Re: Why is this throwing a primary key violation!!?!?
- From: "Guillem" <guillemvicens-nospam@xxxxxxxxxxxxxxxxxx>
- Date: 26 Sep 2005 08:09:08 -0700
Hi,
Josh Fraser wrote:
>
> dmShippingAssumptions.SaveAss(qryJobInfo.FieldByName('CustomerID').AsI
> nteger);
great method name <vbg>
>
> qryJobInfo.FieldByName('CustomerID').Value :=
> dmCustomer.qryGetCustomer.FieldByName('CustomerID').value;
>
I suspect the problem could lie here. To check it, supposing your
CustomerID is an integer, try following:
qryJobInfo.FieldByName('CustomerID').asInteger :=
dmCustomer.qryGetCustomer.FieldByName('CustomerID').asInteger;
if it's another type then use the corresponding AsXxxx method
--
Best regards :)
Guillem Vicens
Dep. Informática Green Service S.A.
www.clubgreenoasis.com
--
in order to contact me remove the -nospam
.
- Follow-Ups:
- Re: Why is this throwing a primary key violation!!?!?
- From: Josh Fraser
- Re: Why is this throwing a primary key violation!!?!?
- References:
- Why is this throwing a primary key violation!!?!?
- From: Josh Fraser
- Why is this throwing a primary key violation!!?!?
- Prev by Date: Re: How format float in TDBText using ADO??
- Next by Date: Re: ADO failing on XP - untangling MDAC and Jet DLLs
- Previous by thread: Why is this throwing a primary key violation!!?!?
- Next by thread: Re: Why is this throwing a primary key violation!!?!?
- Index(es):
Relevant Pages
|
