Column update  
Author Message
Nevets





PostPosted: Wed Feb 11 14:20:58 CST 2004 Top

SQL Server Developer >> Column update

Hi,

I have a strange issue with Sql server 6.5. I have an
applicaiton running in VB updates the tables. Recently I
have dropped and re-created few tables with column
changes. Now I am able to update the table through ISQL
but not through the VB app.

Can someone please shed light on this issue.

I would appreicate.

Ravi

SQL Server182  
 
 
Aaron





PostPosted: Wed Feb 11 14:20:58 CST 2004 Top

SQL Server Developer >> Column update What does "able" mean? Do you get an error message? If so, what is it?
What does your UPDATE query look like? Is it *identical* in both ISQL and
the VB app?

--
Aaron Bertrand
SQL Server MVP
http://www.aspfaq.com/






> Hi,
>
> I have a strange issue with Sql server 6.5. I have an
> applicaiton running in VB updates the tables. Recently I
> have dropped and re-created few tables with column
> changes. Now I am able to update the table through ISQL
> but not through the VB app.
>
> Can someone please shed light on this issue.
>
> I would appreicate.
>
> Ravi


 
 
Tim





PostPosted: Wed Feb 11 17:41:48 CST 2004 Top

SQL Server Developer >> Column update Verify that the VB login has the required permissions.
update/insert/select etc.

Tim S



> Hi,
>
> I have a strange issue with Sql server 6.5. I have an
> applicaiton running in VB updates the tables. Recently I
> have dropped and re-created few tables with column
> changes. Now I am able to update the table through ISQL
> but not through the VB app.
>
> Can someone please shed light on this issue.
>
> I would appreicate.
>
> Ravi