[Search for users] [Overall Top Noters] [List of all Conferences] [Download this site]

Conference iosg::all-in-1_v30

Title:	OLD ALL-IN-1 (tm) Support Conference
Notice:	Closed - See Note 4331.l to move to IOSG::ALL-IN-1
Moderator:	IOSG::PYE

Created:	Thu Jan 30 1992
Last Modified:	Tue Jan 23 1996
Last Successful Update:	Fri Jun 06 1997
Number of topics:	4343
Total number of notes:	18308

3912.0. "Accessing binary dates in Datatrieve format" by BRUMMY::MARTIN::BELL (Martin Bell, NETCC, Birmingham UK) Tue Feb 22 1994 15:47

I am sure that this has cropped up before, but i can't find anything
either in here or the 2.4 and 2.3 conferences, so here goes ...

Has anyone written an ALL-IN-1 application that uses ENTRY forms to
map to an RMS data file containing DTR format date fields (USAGE DATE).

Could the /CONVERT_DATA field qualifier be used in some way, or is there
some other method?

I need to allow a user to manipulate these date fields using ALL-IN-1,
but existing reporting routines have to use binary date fields.

Any thoughts would be much appreciated,

cheers,

mb

T.R	Title	User	Personal Name	Date	Lines
3912.1	Answer: convince the customer to use YYYYMMDD	BRUMMY::MARTIN::BELL	Martin Bell, NETCC, Birmingham UK	`Tue Mar 01 1994 10:52`	14
	Oh well, judging by the lack of response it seems that reading Datatrieve dates can't be done! For the sake of our future generations who may be reading this file, i have managed to convince the customer to store dates as numeric strings in the format YYYYMMDD, which can easily be handled by ALL-IN-1. Gosh, it _is_ quiet these days, especially in the "work related" conferences. Maybe there is nobody left ;-) Cheers, mb
3912.2	I'm game...	IOSG::MARSHALL	When you've got a widget, you don't need gimmicks	`Tue Mar 01 1994 11:59`	12
	>> judging by the lack of response it seems that reading >> Datatrieve dates can't be done! Maybe no-one knows what Datatrieve dates are like! Tell me what format they have and I'll give it a go... >> it _is_ quiet these days, especially in the "work related" >> conferences. Maybe there is nobody left ;-) Maybe we're all too busy working... ;-) Scott
3912.3	/LANGUAGE=?	ROMEOS::LESLIE_DA	Greetings & Solutions	`Wed Mar 02 1994 00:37`	5
	Gee, I thought DATATRIEVE used "standard" 8-byte Digital date formats. This would mean using something like /language= on the specified field. I just can't remember what follows the equal ("="). Maybe you can find this in the documentation (which I don't have access to at the moment). Dan
3912.4	Probably not doable	IOSG::MARSHALL	A glitch in reality	`Wed Mar 02 1994 09:12`	11
	If Datatrieve dates are VMS quadword format then I'm afraid you're stuffed... The ALL-IN-1 symbol processing code would remove any non-printing characters (very likely to be some) from the start and end of the quadword before /LANGUAGE even sees it. Then assuming you could get round that, the ALL-IN-1 routines to convert quadword dates to NBS or other ASCII forms aren't available as API datasets that /LANGUAGE could use. Scott
3912.5	Back from Haggisland ...	BRUMMY::MARTIN::BELL	Martin Bell, NETCC, Birmingham UK	`Mon Mar 07 1994 09:19`	14
	Ouch! It's a good job that i managed to convince the customer to change from DTR format dates! I suppose that the only way around the problem would be to get Datatrieve to actually read the record, and pass the field values (converted where necessary) to ALL-IN-1. NBS dates are much easier, Cheers, mb