Welcome To The Home Of The Visual FoxPro Experts  
home. signup. forum. archives. search. google. articles. downloads. faq. members. weblogs. file info. rss.
 From: Cetin Basoz
  Where is Cetin Basoz?
 Izmir
 Turkey
 Cetin Basoz
 To: Binod Binani
  Where is Binod Binani?
 Kolkata
 India
 Binod Binani
 Tags
Subject: RE: Unable to open cursor
Thread ID: 345103 Message ID: 345109 # Views: 44 # Ratings: 0
Version: Visual FoxPro 9 SP2 Category: Databases, Tables and SQL Server
Date: Friday, May 18, 2012 11:22:39 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*

You have UseCursorSchema = .t. but I don't see the schema itself. Probably that is the problem and in schema the matching field type is invalid.
PS: Check your email.



Cetin Basoz

.Net has got better.Think about moving - check my blog:
My Blog
Blog (mirror) - sounds to be down


Support Wikipedia

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