[U2] Date conversion..
Hi experts.. I have one problem in creatin a spreadsheet report with date format. One of the column in the spreadsheet is a date and it is displaying as numbers. Please help me in printing it as a date. BTW I'm using OCONV to write the value to the column. TIA, Sathya V. ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users
Re: [U2] Date conversion..
Hi What oconv are you using, and have you an example of how it is being displayed ? Rgds Symeon. -Original Message- From: u2-users-boun...@listserver.u2ug.org [mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of Sathya Sent: 22 March 2013 07:30 To: u2-users@listserver.u2ug.org Subject: [U2] Date conversion.. Hi experts.. I have one problem in creatin a spreadsheet report with date format. One of the column in the spreadsheet is a date and it is displaying as numbers. Please help me in printing it as a date. BTW I'm using OCONV to write the value to the column. TIA, Sathya V. ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users - No virus found in this message. Checked by AVG - www.avg.com Version: 2012.0.2240 / Virus Database: 2641/5694 - Release Date: 03/21/13 ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users
Re: [U2] Date conversion..
I always use : OCONV(DATE(),'DDMY,A,Z4') In data that is going to a spreadsheet, it means Excel knows it is a date and stops Excel changing the format to American (we are based in the U.K.). -Original Message- From: u2-users-boun...@listserver.u2ug.org [mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of Sathya Sent: 22 March 2013 7:30 am To: u2-users@listserver.u2ug.org Subject: [U2] Date conversion.. Hi experts.. I have one problem in creatin a spreadsheet report with date format. One of the column in the spreadsheet is a date and it is displaying as numbers. Please help me in printing it as a date. BTW I'm using OCONV to write the value to the column. TIA, Sathya V. ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users Blairs Windows Limited is a company registered in Scotland. Company No: SC393935. Registered office: 9 Baker Street, Greenock, PA15 4TU. V.A.T. registration No: 108729111 ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users
Re: [U2] Date conversion..
Hi, Try OCONV(DATE(),'DDMY[,A,Z4]') Martin Phillips Ladybridge Systems Ltd 17b Coldstream Lane, Hardingstone, Northampton NN4 6DB, England +44 (0)1604-709200 -Original Message- From: u2-users-boun...@listserver.u2ug.org [mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of Jonathan Leckie Sent: 22 March 2013 10:15 To: 'U2 Users List' Subject: Re: [U2] Date conversion.. I always use : OCONV(DATE(),'DDMY,A,Z4') In data that is going to a spreadsheet, it means Excel knows it is a date and stops Excel changing the format to American (we are based in the U.K.). -Original Message- From: u2-users-boun...@listserver.u2ug.org [mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of Sathya Sent: 22 March 2013 7:30 am To: u2-users@listserver.u2ug.org Subject: [U2] Date conversion.. Hi experts.. I have one problem in creatin a spreadsheet report with date format. One of the column in the spreadsheet is a date and it is displaying as numbers. Please help me in printing it as a date. BTW I'm using OCONV to write the value to the column. TIA, Sathya V. ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users Blairs Windows Limited is a company registered in Scotland. Company No: SC393935. Registered office: 9 Baker Street, Greenock, PA15 4TU. V.A.T. registration No: 108729111 ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users
Re: [U2] Date conversion..
I use OCONV(DATE(),'D') and that works just fine because it displays today as 22 Mar 2013. On 22/03/2013 11:19, Martin Phillips wrote: Hi, Try OCONV(DATE(),'DDMY[,A,Z4]') M ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users
Re: [U2] Date conversion..
Which of course on UniVerse (for mixed case month) is OConv(Date(),DL) For Excel I find the ISO date format (-mm-dd) is the safest. Then it's just down to the Excel options as to how it formats that column. Brian -Original Message- From: u2-users-boun...@listserver.u2ug.org [mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of Mecki Foerthmann Sent: 22 March 2013 14:11 To: u2-users@listserver.u2ug.org Subject: Re: [U2] Date conversion.. I use OCONV(DATE(),'D') and that works just fine because it displays today as 22 Mar 2013. On 22/03/2013 11:19, Martin Phillips wrote: Hi, Try OCONV(DATE(),'DDMY[,A,Z4]') M ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users
Re: [U2] History..
On 20/03/13 18:11, Israel, John R. wrote: Type: .L To list the past commands. .Xn To re-execute the nth command. .? For help Also .Rn to pull the nth command back into first (default) place. That's useful if you've got the COMMAND.EDITOR switched on. By the way, n defaults to 1, so .Rn .X will have the same effect as .Xn Cheers, Wol ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users
Re: [U2] Date conversion..
From: Sathya Hi experts.. I have one problem in creatin a spreadsheet report with date format. One of the column in the spreadsheet is a date and it is displaying as numbers. Please help me in printing it as a date. BTW I'm using OCONV to write the value to the column. The problem isn't with MV. When you say spreadsheet people here imply Excel, and I'm guessing that's what you mean too. What most people do is they generate a CSV file with no formatting and then expect Excel to format it in specific ways. The simple answer is, if you just want text in Excel, put a single quote before the value: 123, abc, '3/22/2013 You can also force it to text like this using a formula: =3/22 The immediate response might be but I want a Date column. OK, but you're not doing anything to tell Excel that the column itself should use date formatting. [AD] This is exactly the reason why I created NebulaXLite. It gives you any kind of real Excel formatting of your choice for any cell, column, or row. With nothing but BASIC, you can: - use set fonts, colors, text rotation, and borders, - set column widths and row heights - merge cells, use hyperlinks, add comments to cells - set document properties, add multiple worksheets in a workbook - and documents open in Google Docs and OpenOffice Compare all of that (and yes, much more) to plain old delimited text. Lots of companies here use NebulaXLite. It's free for developers and only a one-time purchase price of $200 for production end-user systems. Support and enhancements are free. http://Nebula-RnD.com/products/xlite.htm [/AD] HTH Tony Gravagno Nebula Research and Development TG@ remove.pleaseNebula-RnD.com http://Nebula-RnD.com/blog Visit http://PickWiki.com! Contribute! http://Twitter.com/TonyGravagno http://groups.google.com/group/mvdbms ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users
Re: [U2] Date conversion..
I would suggest tab-delimited instead of csv, then give the file an xls extension. This usually pulls up the fat with much fewer mouse clicks. John Israel Sent from my iPhone On Mar 22, 2013, at 12:17 PM, Tony Gravagno 3xk547...@sneakemail.com wrote: From: Sathya Hi experts.. I have one problem in creatin a spreadsheet report with date format. One of the column in the spreadsheet is a date and it is displaying as numbers. Please help me in printing it as a date. BTW I'm using OCONV to write the value to the column. The problem isn't with MV. When you say spreadsheet people here imply Excel, and I'm guessing that's what you mean too. What most people do is they generate a CSV file with no formatting and then expect Excel to format it in specific ways. The simple answer is, if you just want text in Excel, put a single quote before the value: 123, abc, '3/22/2013 You can also force it to text like this using a formula: =3/22 The immediate response might be but I want a Date column. OK, but you're not doing anything to tell Excel that the column itself should use date formatting. [AD] This is exactly the reason why I created NebulaXLite. It gives you any kind of real Excel formatting of your choice for any cell, column, or row. With nothing but BASIC, you can: - use set fonts, colors, text rotation, and borders, - set column widths and row heights - merge cells, use hyperlinks, add comments to cells - set document properties, add multiple worksheets in a workbook - and documents open in Google Docs and OpenOffice Compare all of that (and yes, much more) to plain old delimited text. Lots of companies here use NebulaXLite. It's free for developers and only a one-time purchase price of $200 for production end-user systems. Support and enhancements are free. http://webdefence.global.blackspider.com/urlwrap/?q=AXicY3VmeNXLwHC-n4GhKKfSyDBdr7ioTC83MTMnOT-vpCg_Ry85P5ehyMjX3T3f09HAyNzI0oIhs7goMTWryCElsbIkP6-4tCC1KDO_CKwyo6SkwEpf3y81qTQnUTcozwUkql9QlJ9SmlxSrF-Rk1mSqpdRkssAAQDL-yocZ [/AD] HTH Tony Gravagno Nebula Research and Development TG@ remove.pleaseNebula-RnD.com http://webdefence.global.blackspider.com/urlwrap/?q=AXicY3VmeNXLwHC-n4GhKKfSyDBdr7ioTC83MTMnOT-vpCg_Ry85P5ehyMjX3T3f09HAyNzI0oIhs7goMTWryCElsbIkP6-4tCC1KDO_CKwyo6SkwEpf3y81qTQnUTcozwUkqp-Uk5_OAAEAelMkgAZ Visit http://PickWiki.com! Contribute! http://Twitter.com/TonyGravagno http://groups.google.com/group/mvdbms ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users
Re: [U2] Date conversion..
Hi Tony, It looks like development on NebulaXLite only goes to 2009. Does it work with Jbase 3.4 on XP (32 bit)? I looked on your site and in the FAQ, but it didn't really tell me. Thanks, Charlie On 03-22-2013 11:15 AM, Tony Gravagno wrote: From: Sathya Hi experts.. I have one problem in creatin a spreadsheet report with date format. One of the column in the spreadsheet is a date and it is displaying as numbers. Please help me in printing it as a date. BTW I'm using OCONV to write the value to the column. The problem isn't with MV. When you say spreadsheet people here imply Excel, and I'm guessing that's what you mean too. What most people do is they generate a CSV file with no formatting and then expect Excel to format it in specific ways. The simple answer is, if you just want text in Excel, put a single quote before the value: 123, abc, '3/22/2013 You can also force it to text like this using a formula: =3/22 The immediate response might be but I want a Date column. OK, but you're not doing anything to tell Excel that the column itself should use date formatting. [AD] This is exactly the reason why I created NebulaXLite. It gives you any kind of real Excel formatting of your choice for any cell, column, or row. With nothing but BASIC, you can: - use set fonts, colors, text rotation, and borders, - set column widths and row heights - merge cells, use hyperlinks, add comments to cells - set document properties, add multiple worksheets in a workbook - and documents open in Google Docs and OpenOffice Compare all of that (and yes, much more) to plain old delimited text. Lots of companies here use NebulaXLite. It's free for developers and only a one-time purchase price of $200 for production end-user systems. Support and enhancements are free. http://Nebula-RnD.com/products/xlite.htm [/AD] HTH Tony Gravagno Nebula Research and Development TG@ remove.pleaseNebula-RnD.com http://Nebula-RnD.com/blog Visit http://PickWiki.com! Contribute! http://Twitter.com/TonyGravagno http://groups.google.com/group/mvdbms ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users
Re: [U2] Date conversion..
Also with less problems with double quotes. Charlie On 03-22-2013 11:26 AM, Israel, John R. wrote: I would suggest tab-delimited instead of csv, then give the file an xls extension. This usually pulls up the fat with much fewer mouse clicks. John Israel Sent from my iPhone On Mar 22, 2013, at 12:17 PM, Tony Gravagno 3xk547...@sneakemail.com wrote: From: Sathya Hi experts.. I have one problem in creatin a spreadsheet report with date format. One of the column in the spreadsheet is a date and it is displaying as numbers. Please help me in printing it as a date. BTW I'm using OCONV to write the value to the column. The problem isn't with MV. When you say spreadsheet people here imply Excel, and I'm guessing that's what you mean too. What most people do is they generate a CSV file with no formatting and then expect Excel to format it in specific ways. The simple answer is, if you just want text in Excel, put a single quote before the value: 123, abc, '3/22/2013 You can also force it to text like this using a formula: =3/22 The immediate response might be but I want a Date column. OK, but you're not doing anything to tell Excel that the column itself should use date formatting. [AD] This is exactly the reason why I created NebulaXLite. It gives you any kind of real Excel formatting of your choice for any cell, column, or row. With nothing but BASIC, you can: - use set fonts, colors, text rotation, and borders, - set column widths and row heights - merge cells, use hyperlinks, add comments to cells - set document properties, add multiple worksheets in a workbook - and documents open in Google Docs and OpenOffice Compare all of that (and yes, much more) to plain old delimited text. Lots of companies here use NebulaXLite. It's free for developers and only a one-time purchase price of $200 for production end-user systems. Support and enhancements are free. http://webdefence.global.blackspider.com/urlwrap/?q=AXicY3VmeNXLwHC-n4GhKKfSyDBdr7ioTC83MTMnOT-vpCg_Ry85P5ehyMjX3T3f09HAyNzI0oIhs7goMTWryCElsbIkP6-4tCC1KDO_CKwyo6SkwEpf3y81qTQnUTcozwUkql9QlJ9SmlxSrF-Rk1mSqpdRkssAAQDL-yocZ [/AD] HTH Tony Gravagno Nebula Research and Development TG@ remove.pleaseNebula-RnD.com http://webdefence.global.blackspider.com/urlwrap/?q=AXicY3VmeNXLwHC-n4GhKKfSyDBdr7ioTC83MTMnOT-vpCg_Ry85P5ehyMjX3T3f09HAyNzI0oIhs7goMTWryCElsbIkP6-4tCC1KDO_CKwyo6SkwEpf3y81qTQnUTcozwUkqp-Uk5_OAAEAelMkgAZ Visit http://PickWiki.com! Contribute! http://Twitter.com/TonyGravagno http://groups.google.com/group/mvdbms ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users
[U2] REDBACK Fatal UniBasic errors
I'm accessing UniData via .NET and Redback. But if there is a fatal UniBasic error, like trying to access an unopened file, I get the following: dagLink.DOAdoExecute - ADO Record Set Execute - Connection to Application Server lost Responder Error: (errno=32 The process cannot access the file because it is being used by another process.) Responder Error: (errno=32 The process cannot access the file because it is being used by another process.) Responder Error: Server Err: SpGetLen error, rc=-109 Output Log: none. Error Log: none. * It then goes on to tell me that we have a Responder Error. The rgw.log has this: 102340,RESP,spdr.c,1219,SpGetLen error, rc=-109 (ErrorCode=109 The pipe has been ended.) 102340,RESP,ntbackend.c,720,Resp1 killing pid=122680 102340,RESP,ntbackend.c,701,WriteFile (ErrorCode=232 The pipe is being closed.) 102340,RESP,ntbackend.c,769,Sent 0 stop failed. (ErrorCode=232 The pipe is being closed.) 102340,RESP,ntbackend.c,626,try SafeTerminateProcess (ErrorCode=232 The pipe is being closed.) 102340,RESP,ntbackend.c,630,Did not respond to SafeTerminateProcess: try TerminateProcess (gag) (ErrorCode=232 The pipe is being closed.) 102340,RESP,ntbackend.c,633,TerminateProcess (ErrorCode=5 Access is denied.) 102340,RESP,ntbackend.c,790,Resp1 kill of pid=0 complete, rc=1. 102340,SCHD,ntresp.c,368,2.child slot=6 thandle=-1 102340,SCHD,ntresp.c,370,child died aidx=3 102340,RESP,respcmn.c,428,Responder terminating now. Is there a way to capture a better error message? David A. Green (480) 813-1725 DAG Consulting ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users
Re: [U2] REDBACK Fatal UniBasic errors
David: Have you turned on UniObjects error logging? If not, create the following item in the UDTHOME directory: serverdebug 001 udcs 10 E:\U2\ud\log\udcs\udcs.log My UDTHOME is located at E:\U2\ud so your path should replace mine from above. Also, I've created a udcs subdirectory under the UDTHOME log subdirectory. You can actually just name (and place) this log file whatever and wherever you like. After each UO connection there's a bunch of stuff in it that most often helps me. HTH, Bill Untitled Page - - - */Fav Icon Advantos Systems, Inc./* ☎ Tel: 760-944-5570 x7002 | ☏ Fax: 760-655-1583 The Property Management Advantage. - Original Message - *From:* dgr...@dagconsulting.com *To:* 'U2 Users List' u2-users@listserver.u2ug.org *Date:* 3/22/2013 1:43 PM *Subject:* [U2] REDBACK Fatal UniBasic errors I'm accessing UniData via .NET and Redback. But if there is a fatal UniBasic error, like trying to access an unopened file, I get the following: dagLink.DOAdoExecute - ADO Record Set Execute - Connection to Application Server lost Responder Error: (errno=32 The process cannot access the file because it is being used by another process.) Responder Error: (errno=32 The process cannot access the file because it is being used by another process.) Responder Error: Server Err: SpGetLen error, rc=-109 Output Log: none. Error Log: none. * It then goes on to tell me that we have a Responder Error. The rgw.log has this: 102340,RESP,spdr.c,1219,SpGetLen error, rc=-109 (ErrorCode=109 The pipe has been ended.) 102340,RESP,ntbackend.c,720,Resp1 killing pid=122680 102340,RESP,ntbackend.c,701,WriteFile (ErrorCode=232 The pipe is being closed.) 102340,RESP,ntbackend.c,769,Sent 0 stop failed. (ErrorCode=232 The pipe is being closed.) 102340,RESP,ntbackend.c,626,try SafeTerminateProcess (ErrorCode=232 The pipe is being closed.) 102340,RESP,ntbackend.c,630,Did not respond to SafeTerminateProcess: try TerminateProcess (gag) (ErrorCode=232 The pipe is being closed.) 102340,RESP,ntbackend.c,633,TerminateProcess (ErrorCode=5 Access is denied.) 102340,RESP,ntbackend.c,790,Resp1 kill of pid=0 complete, rc=1. 102340,SCHD,ntresp.c,368,2.child slot=6 thandle=-1 102340,SCHD,ntresp.c,370,child died aidx=3 102340,RESP,respcmn.c,428,Responder terminating now. Is there a way to capture a better error message? David A. Green (480) 813-1725 DAG Consulting ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users
