11/26/2024 8:21:51 PM
|
| |
| slxdeveloper.com Community Forums |
|
| |
|
|
The Forums on slxdeveloper.com are now retired. The forum archive will remain available for the time being. Thank you for your participation on slxdeveloper.com!
Forum to discuss writing script in Architect plugins for SalesLogix & general SalesLogix customization topics (for Windows client only). View the code of conduct for posting guidelines.
|
|
|
|
Handling an uninitialized date value in a DataGrid?
Posted: 14 Nov 06 8:54 AM
|
fiogf49gjkf0d SLX 6.2.3.1092
I have added a Date column called ORDER_START_DATE to the Opportunity:Products DataGrid, populated from a custom table I added some time ago, and its all fine for new records.
However, all the old records have NULL in the column in the database, whiich displays in the SLX Client as '30/12/1899' (this is a vbShortDate in GB format)
I have tried testing for NULL in Opportunity:Products and setting the DataGrid field to blank, but this gets an error.
If I Execute this:
objPrdRS.Fields("ORDER_START_DATE").Value = ""
I get this:
An Error occurred executing active form script (Opportunity:Products).
Multiple-step operation generated errors. Check each status value. at line 160, char 21
How can I just display a blank field if there is a NULL value in the database?
|
|
|
|
You can
subscribe to receive a daily forum digest in your
user profile. View the site code
of conduct for posting guidelines.
 Forum RSS Feed - Subscribe to the forum RSS feed to keep on top of the latest forum activity!
|
|
|
|
|
|
|
|