Jump to content


Photo
- - - - -

"invalid cursor position"


5 replies to this topic

#1 lastenia_rojas

lastenia_rojas

    Member

  • Members
  • PipPip
  • 19 posts

Posted 20 January 2006 - 08:52 PM

We want to access a MS SQL table from ProIV. The MS SQL database is the default database. Unless we specify the SQL select statement ourselves, we get an 'Invalid cursor position' error as soon as we move into any of the table columns. The function is a paging screen. Scrolling up/down works fine. Moving into any of the columns is what is causing the grief. I was wondering if other people have experienced the same problem, and if so, any info with regards to the cause of the problem and how to resolve it are greatly appreciated. Thanks.

#2 Lewis Mccabe

Lewis Mccabe

    ProIV Guru

  • Members
  • PipPipPipPipPip
  • 455 posts
  • Gender:Male
  • Location:Sarasota, Florida

Posted 20 January 2006 - 10:33 PM

Never seen that before. Is this a new installation? Do other PRO-IV functions work fine?
What versions of PRO-IV and MSSQL are you on? We need more info to help you.

Lew

#3 Neil Hunter

Neil Hunter

    ProIV Guru

  • Members
  • PipPipPipPipPip
  • 414 posts
  • Gender:Male
  • Location:Johannesburg, South Africa

Posted 23 January 2006 - 01:22 PM

I have seen this before, but for the life of me can't remember too well how to fix it.

Is there an option on the database for implicit cursors or something like that ?

Have you tried using a simple file browser from ProIV side ?

#4 Joseph Bove

Joseph Bove

    ProIV Guru

  • Members
  • PipPipPipPipPip
  • 756 posts
  • Gender:Male
  • Location:Ramsey, United States

Posted 23 January 2006 - 04:09 PM

lastenia_rojas,

Compare your ProIV table defintion with the actual SQL table itself. If the ProIV definition has more columns than the actual table (or a column of greater length than the actual table), you can get an error like this.

hth,

Joseph

#5 lastenia_rojas

lastenia_rojas

    Member

  • Members
  • PipPip
  • 19 posts

Posted 23 January 2006 - 06:19 PM

Thanks for the pointers. We are using ProIV 5.5 312, and SQL Server 2000 with all available service packs. The OS
is Windows 2K. The same application runs ok in Oracle. The file definition seems to match the table definition -- there
are only two (alpha) columns in the table. Although we have experience with ProIV/Oracle the ProIV/MS-SQL combination
is new to us. We are in contact with ProIV support and we'll post the solution as soon as we know what is wrong.

#6 lastenia_rojas

lastenia_rojas

    Member

  • Members
  • PipPip
  • 19 posts

Posted 23 January 2006 - 08:43 PM

... no longer getting this error after upgrading to ProIV 5.5r5.1.8



Reply to this topic



  


0 user(s) are reading this topic

0 members, 0 guests, 0 anonymous users