Board index » VB & Database

All times are UTC



 Insufficient base table information for updating or refreshing. 
Author Message
Luis Feli
#1 / 6
 Insufficient base table information for updating or refreshing.

Hello All,

I keep getting this error message:
"Insufficient base table information for updating or refreshing."

Im trying to add a new record to the table, none of the values are required.
There is a primary key on a 5th field which is AutoIncr so i dont update
manually.

im using the Dataenvironment
Properties on cmdSaleData  Batch Optimistic, adStatic, Client-Side
Using VB6+SP5.

Can anyone help?

Here is my code:

Public Sub UpdateSaleDetails()
Dim x As Integer

    DataEnvironment1.rscmdSaleData.Open

    For x = 0 To CS.Count - 1

    DataEnvironment1.rscmdSaleData.AddNew

    With DataEnvironment1.rscmdSaleData

        .Fields(0).Value = CS.Number
        .Fields(1).Value = CS.Items(x).itemId
        .Fields(2).Value = CS.Items(x).Qty
        .Fields(3).Value = CS.Items(x).Price

    End With

    Next

     DataEnvironment1.rscmdSaleData.UpdateBatch adAffectAll
     DataEnvironment1.rscmdSaleData.Close

End Sub

thanks in advance,
Luis Feliz



Thu, 01 Sep 2005 12:07:46 GMT  
Glenn Robbin
#2 / 6
 Insufficient base table information for updating or refreshing.
Luis:

What is your backend and provider?  If Sybase, you will get this error when
trying to update using  stored procedures even with existing records.  For
new records, Sybase does not support retrieving identity info, you have to
requery the recordset after the update and I am not sure how you would
handle in a batch situation with identities.

If SQL Server backend, your code should work with stored procedures, dynamic
SQL or hitting a table.  What is you command text, are you hitting more than
one table with rscmdSaleData?

Best,
Glenn


Quote:
> Hello All,

> I keep getting this error message:
> "Insufficient base table information for updating or refreshing."

> Im trying to add a new record to the table, none of the values are
required.
> There is a primary key on a 5th field which is AutoIncr so i dont update
> manually.

> im using the Dataenvironment
> Properties on cmdSaleData  Batch Optimistic, adStatic, Client-Side
> Using VB6+SP5.

> Can anyone help?

> Here is my code:

> Public Sub UpdateSaleDetails()
> Dim x As Integer

>     DataEnvironment1.rscmdSaleData.Open

>     For x = 0 To CS.Count - 1

>     DataEnvironment1.rscmdSaleData.AddNew

>     With DataEnvironment1.rscmdSaleData

>         .Fields(0).Value = CS.Number
>         .Fields(1).Value = CS.Items(x).itemId
>         .Fields(2).Value = CS.Items(x).Qty
>         .Fields(3).Value = CS.Items(x).Price

>     End With

>     Next

>      DataEnvironment1.rscmdSaleData.UpdateBatch adAffectAll
>      DataEnvironment1.rscmdSaleData.Close

> End Sub

> thanks in advance,
> Luis Feliz



Fri, 02 Sep 2005 00:11:12 GMT  
Val Mazu
#3 / 6
 Insufficient base table information for updating or refreshing.
Luis,

Do you have joined SELECT statement or not?

--
Val Mazur
Microsoft MVP


Quote:
> Hello All,

> I keep getting this error message:
> "Insufficient base table information for updating or refreshing."

> Im trying to add a new record to the table, none of the values are
required.
> There is a primary key on a 5th field which is AutoIncr so i dont update
> manually.

> im using the Dataenvironment
> Properties on cmdSaleData  Batch Optimistic, adStatic, Client-Side
> Using VB6+SP5.

> Can anyone help?

> Here is my code:

> Public Sub UpdateSaleDetails()
> Dim x As Integer

>     DataEnvironment1.rscmdSaleData.Open

>     For x = 0 To CS.Count - 1

>     DataEnvironment1.rscmdSaleData.AddNew

>     With DataEnvironment1.rscmdSaleData

>         .Fields(0).Value = CS.Number
>         .Fields(1).Value = CS.Items(x).itemId
>         .Fields(2).Value = CS.Items(x).Qty
>         .Fields(3).Value = CS.Items(x).Price

>     End With

>     Next

>      DataEnvironment1.rscmdSaleData.UpdateBatch adAffectAll
>      DataEnvironment1.rscmdSaleData.Close

> End Sub

> thanks in advance,
> Luis Feliz



Fri, 02 Sep 2005 00:32:58 GMT  
Ashok Gupt
#4 / 6
 Insufficient base table information for updating or refreshing.
I think the problem is with the Data Env properties :
Quote:
>  Properties on cmdSaleData  Batch Optimistic, adStatic, Client-Side

using 'adStatic' you can not update the recordset. this is causing the error
insuff info.

HTH
Ashok Gupta


Quote:
> Hello All,

> I keep getting this error message:
> "Insufficient base table information for updating or refreshing."

> Im trying to add a new record to the table, none of the values are
required.
> There is a primary key on a 5th field which is AutoIncr so i dont update
> manually.

> im using the Dataenvironment
> Properties on cmdSaleData  Batch Optimistic, adStatic, Client-Side
> Using VB6+SP5.

> Can anyone help?

> Here is my code:

> Public Sub UpdateSaleDetails()
> Dim x As Integer

>     DataEnvironment1.rscmdSaleData.Open

>     For x = 0 To CS.Count - 1

>     DataEnvironment1.rscmdSaleData.AddNew

>     With DataEnvironment1.rscmdSaleData

>         .Fields(0).Value = CS.Number
>         .Fields(1).Value = CS.Items(x).itemId
>         .Fields(2).Value = CS.Items(x).Qty
>         .Fields(3).Value = CS.Items(x).Price

>     End With

>     Next

>      DataEnvironment1.rscmdSaleData.UpdateBatch adAffectAll
>      DataEnvironment1.rscmdSaleData.Close

> End Sub

> thanks in advance,
> Luis Feliz



Fri, 02 Sep 2005 16:23:51 GMT  
Luis Fel
#5 / 6
 Insufficient base table information for updating or refreshing.
Hi..
I'm NOT using a joined SELECT statement.
and im running from a local access file on an xp system.

thanks your replies,
Luis

Quote:

> Hello All,

> I keep getting this error message:
> "Insufficient base table information for updating or refreshing."

> Im trying to add a new record to the table, none of the values are required.
> There is a primary key on a 5th field which is AutoIncr so i dont update
> manually.

> im using the Dataenvironment
> Properties on cmdSaleData  Batch Optimistic, adStatic, Client-Side
> Using VB6+SP5.

> Can anyone help?

> Here is my code:

> Public Sub UpdateSaleDetails()
> Dim x As Integer

>     DataEnvironment1.rscmdSaleData.Open

>     For x = 0 To CS.Count - 1

>     DataEnvironment1.rscmdSaleData.AddNew

>     With DataEnvironment1.rscmdSaleData

>         .Fields(0).Value = CS.Number
>         .Fields(1).Value = CS.Items(x).itemId
>         .Fields(2).Value = CS.Items(x).Qty
>         .Fields(3).Value = CS.Items(x).Price

>     End With

>     Next

>      DataEnvironment1.rscmdSaleData.UpdateBatch adAffectAll
>      DataEnvironment1.rscmdSaleData.Close

> End Sub

> thanks in advance,
> Luis Feliz



Mon, 05 Sep 2005 01:19:16 GMT  
L.M.
#6 / 6
 Insufficient base table information for updating or refreshing.
Does your table name has a dash ("-")? (like "table-1"), that will
generate this kind of error message.


Tue, 20 Sep 2005 06:32:10 GMT  
 
 Page 1 of 1
  [ 6 post ] 

 Relevant Pages 

1. Insufficient base table information for updating or refreshing.

2. Help .....insufficient base table information for updating or refreshing

3. Insufficient base table information for updating or refreshing

4. Error: Insufficient base table information for updating or refreshing

5. Insufficient base table information for updating or refreshing

6. Error 2147467259 Insufficient base table information for updating or refreshing

7. Insufficient base table information for updating or refreshing

8. XP installation : 2147467259 Insufficient base table information for updating or refreshing

9. Insufficient base table information for updating or refreshing

10. Insufficient base table information for updating or refreshing?

11. AdodcSave:-2147467259 - Insufficient base table information for updatig or refreshing

12. VB6 ADO Insufficient Base Table information for updating or refreshing error (Why?)

  

 
Powered by phpBB® Forum Software