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
 To: Binod Binani
  Where is Binod Binani?
 Kolkata
 India
 Binod Binani
 Tags
Subject: RE: Unable to open cursor
Thread ID: 345103 Message ID: 345104 # Views: 34 # Ratings: 0
Version: Visual FoxPro 9 SP2 Category: Databases, Tables and SQL Server
Date: Friday, May 18, 2012 10:43:08 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*

I wud be much obliged if some1 help me vai teamviewr since i m now in
serious position as my project had over delayed.

Please.


*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