Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations Mike Lewis on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Error 7341 Could not get the current row value of column

Status
Not open for further replies.

b3ge

Programmer
Jun 14, 2002
3
0
0
CA
Hi I am using a SQL statement in Microsoft Query Analyzer
It is retrieving data from a dBase III File.
SELECT *
FROM OPENROWSET ('MSDASQL','Driver=Microsoft Visual FoxPro Driver;
SourceDB=\\max\C\D\BetterBeef\DBF\;
SourceType=DBF','select * from VSHPITMS')

If I limit the row to "WHERE SHIPMUM = '12345' then it will return rows, otherwise it gives this error

Server: Msg 7341, Level 16, State 2, Line 1
Could not get the current row value of column '[MSDASQL].itm_num' from the OLE DB provider 'MSDASQL'. Conversion failed because the data value overflowed the data type used by the provider.
[OLE/DB provider returned message: Multiple-step OLE DB operation generated errors. Check each OLE DB status value, if available. No work was done.]

There are 2 columns that give this error
one thta has a datatype of Numeric(3,0) and one that has a datatype of Numeric(4,0)

The Numeric(3,0) field's max value is 999

Two other fields of type Numeric(7,0) and Numeric(10,3) do not produce the error.

Do you know of a workaround or what I am doing wrong. Thanks
 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top