Re: 'Parameters' question
anonymous_at_discussions.microsoft.com
Date: 02/23/04
- Next message: Ray Higdon: "Re: Help needed with IIF syntax"
- Previous message: Anith Sen: "Re: Make change on record"
- In reply to: Ray Higdon: "Re: 'Parameters' question"
- Next in thread: Ray Higdon: "Re: 'Parameters' question"
- Reply: Ray Higdon: "Re: 'Parameters' question"
- Messages sorted by: [ date ] [ thread ]
Date: Sun, 22 Feb 2004 20:25:56 -0800
This parm value for ptransid appears to be created/set
from a Form ...
>-----Original Message-----
>What value do you want the param to have?
>
>--
>Ray Higdon MCSE, MCDBA, CCNA
>---
><anonymous@discussions.microsoft.com> wrote in message
>news:149cb01c3f9bd$f6082550$a001280a@phx.gbl...
>> Also... I changed the query to the following. Query
>> Analyzer parsed it ok..but the execute gave an error of
>> 'invalid column name ptransid' on line 4
>>
>> DECLARE @pTransId nvarchar(50)
>> SET @ptransid = ptransid
>> DELETE FROM tblApTransInvoiceTax
>> WHERE tblApTransInvoiceTax.TransId= @pTransid;
>> >-----Original Message-----
>> >Hi...This is another problem that is eluding me.
>> >Suggestions on how this should be coded in Sql 2000?
I
>> >receive 'incorrect syntax' for 'text' on line 1
>> >and 'tblApTransInvoiceTax' on line 4.
>> >
>> >PARAMETERS pTransId Text ( 255 );
>> >DELETE DISTINCTROW tblApTransInvoiceTax.*,
>> >tblApTransInvoiceTax.TransId
>> >FROM tblApTransInvoiceTax
>> >WHERE (((tblApTransInvoiceTax.TransId)=[pTransId]));
>> >
>> >This is new to me...learning as I go !
>> >
>> >Thanks for the help.
>> >.
>> >
>
>
>.
>
- Next message: Ray Higdon: "Re: Help needed with IIF syntax"
- Previous message: Anith Sen: "Re: Make change on record"
- In reply to: Ray Higdon: "Re: 'Parameters' question"
- Next in thread: Ray Higdon: "Re: 'Parameters' question"
- Reply: Ray Higdon: "Re: 'Parameters' question"
- Messages sorted by: [ date ] [ thread ]
Relevant Pages
|
