Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
SQL server date field showing as datetime on data entry
Message
From
24/11/2004 09:37:38
Cetin Basoz
Engineerica Inc.
Izmir, Turkey
 
 
To
24/11/2004 09:13:41
Stephen Hunt
Admit Computer Services Inc.
Farmingdale, New York, United States
General information
Forum:
Visual FoxPro
Category:
Visual FoxPro Beta
Miscellaneous
Thread ID:
00940852
Message ID:
00964268
Views:
18
>It is currently set to "D" in the cursorschema of the cursoradapter and it still shows as datetime type on my data entry screen ?
>
>Thanks Again !
oData = Createobject("NWData")
oData.CursorFill(.T.)
browse

Define Class NWData As CursorAdapter
  Alias="Orders"
  DataSourceType="ADO"

  CursorSchema = "CustomerID C(5), OrderDate D, OorderID I, RequiredDate D"
  SelectCmd = "select CustomerID, OrderDate, OrderID, RequiredDate from Orders"

  Procedure Init
	This.AddProperty('oConn',	NEWOBJECT("adodb.connection"))
	This.AddProperty('oRS',		NEWOBJECT("adodb.recordset"))
	This.oConn.ConnectionString = ;
		"Provider=SQLOLEDB;Integrated Security=SSPI;"+;
		"Persist Security Info=False;"+;
		"Initial Catalog=Northwind;Data Source=localhost"
	This.oConn.Open()
	This.oRS.ActiveConnection = This.oConn
    This.Datasource = This.oRS
  Endproc
Enddefine
Cetin
Çetin Basöz

The way to Go
Flutter - For mobile, web and desktop.
World's most advanced open source relational database.
.Net for foxheads - Blog (main)
FoxSharp - Blog (mirror)
Welcome to FoxyClasses

LinqPad - C#,VB,F#,SQL,eSQL ... scratchpad
Previous
Next
Reply
Map
View

Click here to load this message in the networking platform