I have never used Paradox before, but it could be that it is expecting
a value for sheet number. Remove that condition and see if it helps.
You may want this there though, but just to see if that is causing the
error you can remove it and add it back if it is not the cause.
On Mon, 28 Mar 2005 11:56:29 -0600, Stephen Russell
<[EMAIL PROTECTED]> wrote:
>
> I have the BDE installed.
>
> My connection string to the data is:
> "Provider=Microsoft.Jet.OLEDB.4.0;Data Source=c:\edcat\data;Extended
> Properties=Paradox 4.x;"
>
> My statement passed is:
> "Update CHECTLOG set [REVISION NUMBER] = 'D' where [DRAWING NUMBER] =
> '1-P-162' and [SHEET NUMBER] =' ' and [REVISION NUMBER]= 'B' " );
>
> Code that is run:
> objCommand.Connection.Open();
> objCommand.ExecuteNonQuery(); // problem here
> !!!!
> objCommand.Connection.Close();
>
> Error is.
> No value given for one or more required parameters.
>
> Any ideas on a param that I'm not passing?
>
> Stephen Russell
> S.R. & Associates
> Memphis, TN 38115
>
> 901.246-0159
>
>
> Yahoo! Groups Links
>
>
>
>
>
Yahoo! Groups Links
<*> To visit your group on the web, go to:
http://groups.yahoo.com/group/Microsofts_C_Sharp/
<*> To unsubscribe from this group, send an email to:
[EMAIL PROTECTED]
<*> Your use of Yahoo! Groups is subject to:
http://docs.yahoo.com/info/terms/
