Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
SQL Server - String data, right truncation error?
Message
From
03/05/2005 09:53:48
 
 
To
All
General information
Forum:
Visual FoxPro
Category:
Client/server
Title:
SQL Server - String data, right truncation error?
Environment versions
Database:
MS SQL Server
Miscellaneous
Thread ID:
01010449
Message ID:
01010449
Views:
73
Textbox valid:
If Not Isnull(This.Value) And This.Value <= Date()
   If Empty(Dtos(This.Value))
	Update CarsMemo SET Initials = Thisform.cUser
	This.Value = NULL
	DoDefault()
   Else
	Return 0
   Endif
Else
   Update CarsMemo SET Initials = Thisform.cUser
   DoDefault()
Endif
When saving I get the String data, right truncation error from the server.

So, why can't I set a datefield to null?

TIA
Peter Pirker


Whosoever shall not fall by the sword or by famine, shall fall by pestilence, so why bother shaving?

(Woody Allen)
Next
Reply
Map
View

Click here to load this message in the networking platform