• Heh... Join the crowd... everyone always has some gripe when they have to make a change in what they're using. 😉 You being an ol' FoxPro user makes it even more difficult because it was a great product that they discontinued. I'm still griping because they took away the functionality that used to lie under the {f4} key and because they took away sp_MakeWebtask.

    Anyway, using the built in Windows functionality of an {alt]{click}{drag} to copy one set next to another, I was able to quickly verify that you're correct... they do, indeed, match line for line.

    <asp:Parameter Name="nProductID" Type="Int32" /> @nProductID int,

    <asp:Parameter Name="cProductTitle" Type="String" /> @cProductTitle varchar(75),

    <asp:Parameter Name="nCategory3D" Type="Byte" /> @nCategory3D tinyint,

    <asp:Parameter Name="nSecondaryCat" Type="Byte" /> @nSecondaryCat tinyint,

    <asp:Parameter Name="cReadMe" Type="String" /> @cReadMe text,

    <asp:Parameter Name="nNumberOfFiles" Type="Byte" /> @nNumberOfFiles tinyint,

    <asp:Parameter Name="cLongDesc" Type="String" /> @cLongDesc varchar(2000),

    <asp:Parameter Name="nPrice" Type="Decimal" /> @nPrice decimal,

    <asp:Parameter Name="nSalePrice" Type="Decimal" /> @nSalePrice decimal,

    <asp:Parameter Name="nPercentOff" Type="Int32" /> @nPercentOff int,

    <asp:Parameter Name="lOnSale" Type="Boolean" /> @lOnSale bit,

    <asp:Parameter Name="lFreebie" Type="Boolean" /> @lFreebie bit,

    <asp:Parameter DbType="Datetime" Name="dSaleStart" /> @dSaleStart datetime,

    <asp:Parameter DbType="Datetime" Name="dSaleEnd" /> @dSaleEnd datetime,

    <asp:Parameter Name="cFeatures" Type="String" /> @cFeatures text,

    <asp:Parameter Name="cRequirements" Type="String" /> @cRequirements text,

    <asp:Parameter Name="nSoftwareRequirements" Type="Byte" /> @nSoftwareRequirements tinyint,

    <asp:Parameter Name="nDAZversion" Type="Byte" /> @nDAZversion tinyint,

    <asp:Parameter Name="nPoserVersion" Type="Byte" /> @nPoserVersion tinyint,

    <asp:Parameter Name="nBryceVersion" Type="Byte" /> @nBryceVersion tinyint,

    <asp:Parameter Name="nCarraraVersion" Type="Byte" /> @nCarraraVersion tinyint,

    <asp:Parameter Name="cOtherVersions" Type="String" /> @cOtherVersions varchar(500),

    <asp:Parameter Name="lShadersOnly" Type="Boolean" /> @lShadersOnly bit,

    <asp:Parameter Name="cMarketingCredits" Type="String" /> @cMarketingCredits varchar(1000),

    <asp:Parameter Name="nModelRequired" Type="Byte" /> @nModelRequired tinyint,

    <asp:Parameter Name="cOtherModel" Type="String" /> @cOtherModel varchar(50),

    <asp:Parameter Name="lUpdated" Type="Boolean" /> @lUpdated bit,

    <asp:Parameter DbType="Datetime" Name="dUpdateDate" /> @dUpdateDate datetime

    I don't even know how to spell "ASP" but I did notice that some of the lines of ASP code have the Name and DBType attributes reversed and don't know if that would be the cause of the problem or not, but thought it might be worth mentioning just in case it is.

    --Jeff Moden


    RBAR is pronounced "ree-bar" and is a "Modenism" for Row-By-Agonizing-Row.
    First step towards the paradigm shift of writing Set Based code:
    ________Stop thinking about what you want to do to a ROW... think, instead, of what you want to do to a COLUMN.

    Change is inevitable... Change for the better is not.


    Helpful Links:
    How to post code problems
    How to Post Performance Problems
    Create a Tally Function (fnTally)