RE: [?? Probable Spam] Re: Re: [U2] RE:french characters
Mat There is what I have in Protocol line: PROTOCOLLINE=0 BAUD=9600 DATA=8 STOP=1 NONE DISABLE -STRIP So, I believe it is fine. Thank you very much I know what to do, but it is much more work that I anticipated. Irina Lissok -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Mats Carlid Sent: Tuesday, August 26, 2008 7:00 AM To: u2-users@listserver.u2ug.org Subject: [?? Probable Spam] Re: Re: [U2] RE:french characters Irina, the problem I think You have is that the file has characters like char(233) for e-acute but Your terminal(emulator) or port strips the leading bit making it the 7bit character char(105) = i on the display. ( 105 = 233-128) (( the 233=i is for the iso-8859-1 we use - french may be different )) Thus check Your PTERM settings by >PTERM DISPLAY make sure it has DATA=8 and NONE and -STRIP on the protocol line. ( wich means 8bit characters, no check digit and dond' strip bit 0 ) If this doesn't help You'll have to To verify what the characters aren't destroyed in the file. In unix use od -cx | more in universe ED in up-arrow mode will show the decimal value of each character > 127. When You have identified the value of each character used use CHAR(nnn) in Your program when You build your search pattern. ( You may find the iso encoding schemes on the web too ... if You can weed out what they used... ) HTH -- mats --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/ --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/
RE: [!! SPAM] Re: [U2] RE:french characters
Hi Mat, I realize that readseq reads correctly. Then my question is how to read in in hex in order to read appropriate character and recognize it. For instance, in debug mode I can not see character H but H or I and program will not recognize it even though I specified in the code to search for this character. Thanks, Irina Lissok -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Mats Carlid Sent: Monday, August 25, 2008 9:53 AM To: u2-users@listserver.u2ug.org Subject: [!! SPAM] Re: [U2] RE:french characters Hi Irina, AFAIK readseq does not change any characters ( at least for universe ). But Your terminal(emulator) will - unless You specify the same character mapping as the original data. If on unix check that Your stty ( or PTERM if in uv ) settings speicify 8-bit. Also whatever You do You'll always have a problem with char(253) through char(255) that universe use as subvalue,value,field and item marks. If You don't know the encoding try ISO-8859-1. (( I have no experience with french data - only swedish wich have other but fewer accented and umlaut letters. )) HTH -- mats Irina Lissok skrev: > We have a problem with FRENCH characters. > > Using READSEQ to read the record from the file which contains FRENCH > characters. > > It reads in but French characters has been substituted with blanks or > with legitimate English characters. > > When we are trying to load this data into xml file with WRITEBLK it puts > initial French characters in it and xml file can not be opened. > > Our approach was to read data in and represent it in hex to be able to > recognize French characters, but it won't work because as a result from > READSEQ we've already had some kind of interpretation, not initial data. > > > > Is anyone have met the same problem and knows how to deal with it. > > > > Irina Lissok > --- > u2-users mailing list > u2-users@listserver.u2ug.org > To unsubscribe please visit http://listserver.u2ug.org/ --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/ --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/
[U2] RE:french characters
We have a problem with FRENCH characters. Using READSEQ to read the record from the file which contains FRENCH characters. It reads in but French characters has been substituted with blanks or with legitimate English characters. When we are trying to load this data into xml file with WRITEBLK it puts initial French characters in it and xml file can not be opened. Our approach was to read data in and represent it in hex to be able to recognize French characters, but it won't work because as a result from READSEQ we've already had some kind of interpretation, not initial data. Is anyone have met the same problem and knows how to deal with it. Irina Lissok --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/
RE: [U2] re:passing parameters to stored procedures
I did not solve this problem. Actually, parameter name is correct, but what I found out that it is SQL error related to datetime conversion in the table and I have not solved this problem yet. I also notice when I run Stored Procedure apart from calling code with provided date it runs perfectly, but as soon as I called it from code it is nightmare I could not solve and I suspect it is related to SQL driver settings or data type in the table. -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Dennis Bartlett Sent: Friday, July 11, 2008 9:21 AM To: u2-users@listserver.u2ug.org Subject: [?? Probable Spam] RE: [U2] re:passing parameters to stored procedures Did you solve this? What comes to mind is that SQL might be taking the @ sign as a delimiter or some such and stripping the variable before it gets to the proc.. -Original Message- Subject: [U2] re:passing parameters to stored procedures I have created stored procedure to run and I have to pass date parameter to it. I'm getting error message saying ERROR [42000] [Microsoft][ODBC SQL Server Driver][SQL Server]Procedure 'ProcedureName' expects parameter '@FirstDay', which was not supplied. I implicitly assign parameter value and type and checked the name to be identical and there is still an error --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/ --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/
[U2] re:passing parameters to stored procedures
I have created stored procedure to run and I have to pass date parameter to it. I'm getting error message saying ERROR [42000] [Microsoft][ODBC SQL Server Driver][SQL Server]Procedure 'ProcedureName' expects parameter '@FirstDay', which was not supplied. I implicitly assign parameter value and type and checked the name to be identical and there is still an error Is anybody know where can a problem? Irina Lissok --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/
[U2] re:form multiple spreadsheets excel file in universe
Hi everyone, We have the program which runs and creates separate excel files for relational data. We want to put all this data in one file but on separate work sheets. Does anyone know how we can implement it? Irina Lissok. --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/
RE: [?? Probable Spam] RE: [U2]ICONV(VAR,"DB")
David, It is possibly valid because it passed the compilation. If it will not pass the compilation we would know it is not valid and just do not consider this conversion. The point is that is probably legitimate conversion because it still works for other date conversion except the last day of February. Irina Lissok -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of David Murray Sent: Wednesday, May 07, 2008 3:24 PM To: u2-users@listserver.u2ug.org Subject: [?? Probable Spam] RE: [U2]ICONV(VAR,"DB") Irina, I do not think that a ICONV conversion code of 'DB' is actually valid. 'DMB', DWB' etc for short codes for month and day respectively are OK. Cheers, David Murray * Learn and do * Excel and share http://u2blog.org -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Irina Lissok Sent: Wednesday, May 07, 2008 2:21 PM To: u2-users@listserver.u2ug.org Subject: re:[U2]ICONV(VAR,"DB") Hey all, We are using ICONV(VAR,'DB') and it works perfectly except one case when the date is the last day of February any year. For instance for VAR=31-MAR-2007 INTERNAL.VAR=ICONV(VAR,'DB') INTERNAL.VAR=14335 For VAR=28-FEB-2007 INTERNAL.VAR=ICONV(VAR,'DB') INTERNAL.VAR='' In case VAR=29-FEB-2008 INTERNAL.VAR=ICONV(VAR,'DB') INTERNAL.VAR='' We tested it with STATUS() and in both cases it returns 0 which is considered as successful conversion. If we are using ICONV(VAR,'D') there is no problem in conversion to internal representation. Is anybody familiar with 'DB' conversion and what the difference between 'DB' and 'D' except the one we've already known it doesn't convert the last day of February? Irina Lissok. --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/ --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/ --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/
re:[U2]ICONV(VAR,"DB")
Hey all, We are using ICONV(VAR,'DB') and it works perfectly except one case when the date is the last day of February any year. For instance for VAR=31-MAR-2007 INTERNAL.VAR=ICONV(VAR,'DB') INTERNAL.VAR=14335 For VAR=28-FEB-2007 INTERNAL.VAR=ICONV(VAR,'DB') INTERNAL.VAR='' In case VAR=29-FEB-2008 INTERNAL.VAR=ICONV(VAR,'DB') INTERNAL.VAR='' We tested it with STATUS() and in both cases it returns 0 which is considered as successful conversion. If we are using ICONV(VAR,'D') there is no problem in conversion to internal representation. Is anybody familiar with 'DB' conversion and what the difference between 'DB' and 'D' except the one we've already known it doesn't convert the last day of February? Irina Lissok. --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/
[U2] re: set timeout for KEYIN()
--- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/