Plateforme Level Extreme
Abonnement
Profil corporatif
Produits & Services
Support
Légal
English
SQL server date field showing as datetime on data entry
Message
De
24/11/2004 09:37:38
Cetin Basoz
Engineerica Inc.
Izmir, Turquie
 
 
À
24/11/2004 09:13:41
Stephen Hunt
Admit Computer Services Inc.
Farmingdale, New York, États-Unis
Information générale
Forum:
Visual FoxPro
Catégorie:
Visual FoxPro Beta
Divers
Thread ID:
00940852
Message ID:
00964268
Vues:
17
>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
Précédent
Suivant
Répondre
Fil
Voir

Click here to load this message in the networking platform