Parameters for the ADO query!
From: Atmapuri (janez.makovsek_at_usa.net)
Date: 12/30/03
- Next message: Atmapuri: "Re: Parameters for the ADO query!"
- Previous message: Hansen: "Save TDateTimePicker.date and DBEdit with ADOTable"
- Next in thread: Atmapuri: "Re: Parameters for the ADO query!"
- Reply: Atmapuri: "Re: Parameters for the ADO query!"
- Messages sorted by: [ date ] [ thread ] [ subject ] [ author ]
Date: Tue, 30 Dec 2003 10:30:15 +0100
Hi!
I have defined the following query:
SELECT *
FROM Programs
WHERE ((LocationID=:LocationListingID) And (SectionID=:SectionListingID));
And two params have been added the Parameters list automatically
At run time I assign:
DataForm.ProgramsList.Parameters[0].Value :=
DataForm.LocationTable['ID'];
DataForm.ProgramsList.Parameters[1].Value :=
DataForm.SectionTable['ID'];
DataForm.ProgramsList.ExecSQL;
But the error returned is: No value given for one or more parameters,
Any ideas what could be missing?
Thanks!
Atmapuri.
- Next message: Atmapuri: "Re: Parameters for the ADO query!"
- Previous message: Hansen: "Save TDateTimePicker.date and DBEdit with ADOTable"
- Next in thread: Atmapuri: "Re: Parameters for the ADO query!"
- Reply: Atmapuri: "Re: Parameters for the ADO query!"
- Messages sorted by: [ date ] [ thread ] [ subject ] [ author ]