Welcome To The Home Of The Visual FoxPro Experts  
home. signup. forum. archives. search. google. articles. downloads. faq. members. weblogs. file info. rss.
 From: Binod Binani
  Where is Binod Binani?
 Kolkata
 India
 Binod Binani
 Tags
Subject: Unable to open cursor
Thread ID: 345103 Message ID: 345103 # Views: 38 # Ratings: 0
Version: Visual FoxPro 9 SP2 Category: Databases, Tables and SQL Server
Date: Friday, May 18, 2012 10:40:34 AM         
   


Dear Expert

I m doing a new project in which i m using MS-SQL2005 as backend.
I had created cursor adoptor (CA) classes and created few forms which
is working fine.

In one form I m unable to open cursor (remote view table) . I m using following
codes in load event of the form:

**xx=DBSETPROP('crs_mst_led.nopenbal',"FIELD","DataType","n(12,2)") 
** CRS Opening From SQL 
WITH thisform.dataenvironment.crs_mst_led
  .datasource = gnsqlcon_handler
  .usecursorschema = .t.
  .lnodataonload = .f.
  .cselectcmd = m.lcCmdMstLEd
  IF NOT .cursorfill()
     AERROR(errmsg)
     Messagebox('MST Error in <MST_LED>DE: '+errmsg(2),16,'SQL ERROR')
     RETURN .f.
  ENDIF
ENDWITH    


When executing form i m getting error:

'.. Type conversion required by DataType property for Field 'NopenBal' is invalid'

In SQL-Database, dbo.MST_LED has 'NopenBal' Field Numeric (13,2).

since Last 3 Days I was in trouble I had searched in net but could not found
the way to getrid off this issue.

Please help.




*Exchange of $1 Create only $1, But Exchage of one Ideas Makes different two Ideas*

ENTIRE THREAD

Unable to open cursor Posted by Binod Binani @ 5/18/2012 10:40:34 AM
RE: Unable to open cursor Posted by Binod Binani @ 5/18/2012 10:43:08 AM
RE: Unable to open cursor Posted by Cetin Basoz @ 5/18/2012 11:22:39 AM
RE: Unable to open cursor Posted by Binod Binani @ 5/18/2012 11:40:33 AM
RE: Unable to open cursor Posted by Binod Binani @ 5/19/2012 7:12:46 AM