Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
How to get logical data from PostgreSQL
Message
From
23/01/2005 10:59:07
 
 
To
22/01/2005 21:28:48
General information
Forum:
Visual FoxPro
Category:
Client/server
Environment versions
Visual FoxPro:
VFP 9
Miscellaneous
Thread ID:
00979680
Message ID:
00979807
Views:
32
>Hello,
>
>you have missed to set the CursorSchema property.
>
>ca.CursorSchema = 'test L'
>ca.DataSourceType='ODBC'

Christian,

I changed CreateCursorAdapter to
PROCEDURE CreateCursorAdapter

PUBLIC ca AS cursoradapter
ca =CREATEOBJECT( 'cursoradapter' )

ca.CursorSchema = 'test L'
ca.DataSourceType='ODBC'
ca.DataSource = tnConnHnd 
ca.SelectCmd = "SELECT * FROM TEST"
IF !ca.cursorfill(.t.)
  AERROR(gaError)
  MESSAGEBOX(gaerror[1,2])
  RETURN
  ENDIF
ENDPROC
Now cursorfill() causes error:

Type conversion required by the DataType property for field 'Test' is invalid.
Andrus
Previous
Next
Reply
Map
View

Click here to load this message in the networking platform