Re: Parameter value
- From: "Paul Scott" <paul.scott@xxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxx>
- Date: Thu, 07 Feb 2008 10:59:22 -0000
On Wed, 06 Feb 2008 23:59:17 -0000, Alan T <alanNOSPAMpltse@xxxxxxxxxxxx> wrote:
What would happen if I don't supply value to some of the parameters of a
query?
......
SQL.Add('INSERT INTO employee (ID, Member, Phone ) ' +
'VALUES :ID, :Member, :Phone');
The field 'Phone' is not a required field (Access2003).
Or how do I assigned the parameter value as null?
Although I don't use ParamByName myself, since TParameter.Value is a variant I would guess that the answer is there in your question!
... how do I assigned the parameter value as null?
Parameters.ParamByName('Phone').Value := null ;
--
Paul Scott
Information Management Systems
Macclesfield, UK.
.
- References:
- Parameter value
- From: Alan T
- Parameter value
- Prev by Date: Re: MS Access driver
- Next by Date: Get View statement from database
- Previous by thread: Parameter value
- Next by thread: Get View statement from database
- Index(es):
Relevant Pages
|
