Recent content by UAMI

Openreport I have a form where i introduce the parameter's needed for the execution of a report. However when i do the openreport comand, a new window apear's to obtain the parameter's that i already introduced in my form. I saw in the help that it's possible to put openargs, but i cant's do...

I experimented the SNDDST, but it doesn't funtion. It gives a message like this: " It was specified an internet address but there is no guiding, to the SMTP linking station, defined in the SMTPRTE parameterof the CHGDSTA." This is the command i executed: ===> SNDDST TYPE(*LMSG)...

Hi again! I want to send a mail to outlook in rpgle. Is it possible? What must i do?

Sorry, iseriescodepoet, i expressed myself wrong. When i said i had doubts, i ment, i can't use it very well. One time i made a experience and i had to do a strange thing to put the program function. I mean, after the program run a time, an error message apeared, something like null values...

Well, i followed the advice from "flapeyre", and construct my own trntbl. wITH THE HELP OF A EBCDIC TABLE (code page 01148) CRTTBL TBL(TEST/XXX_TBL) SRCFILE(*PROMPT) For the caracter â (hex 42) i put (hex 81)= a and for all caracter's with accent i put the code with no accent. In this way...

AGÊNCIA IMPRENSA NOVOSTI AGGLOCORK-CORTIÇAS LDA ALÍPIO FRANCISCO MORAIS ALBANO FONSECA FRIAS AMÍLCAR SOUSA COELHO ASCENSO AMADEU ARAÚJO SILVA This is the output of the actual subfile, but it should be: AGÊNCIA IMPRENSA NOVOSTI AGGLOCORK-CORTIÇAS LDA...

The problem of the embended sql is that i have no key. The user will type some letters of the name, like, barba, and program must list all names beginning with barba. It has to apear barba barbara I could create a LF R RECORD1 PFILE(PF1) 00020A CHAR1 I TRNTBL(LIB1/TBL1) How do i define...

I have a subfile where the user can find register's by name. In the file (ordered by name) some names have accentuation. When the user pretend to find the names begining with AB i wnat to write in the subfile, first the: ABA and then the same but with the accentuation ABB and then the same but...

Thank's arrow483, your tip was very important. I had to to some changes: For the eval expression i had to work with a alfa variable (wdtain2, 26) and then move it to the timestamp field dtain, otherwise i could't compile the program. EVAL WDTAIN2=%SUBST(DTAIN:7:4) + '-' +%SUBST(DTAIN...

I realy need a timestanp fild, so i done it like you suggested but now i have problem's in compiling the program. I declared a timestamp variable and tain is my alfa field (26 positions). DWDTAIN S Z IF %subst(dtain:5:1) = '-' Eval...

Hi! I have a pf file with a alfa field: DTAIN 26 that was bad created, because it supouse to be a date field or a timestamp field, so that was possible to extract register by date. Because it it a alfa field, it isn't possible. This field was being field from a access...

I'm doing this statement in the query's of Microsoft Access. I think that i can's do it with string function CStr(number)

I want to do a select statement where i want to concatenate 4 fields, 3 are numbers and 1 text. year (number) month (number) sequence (number) flag (text) How can i transform a numbers into a character? In this file i can have many records with the same key (the 4 fields) but i want to...

IT is defined like a date/time field. Like you suggested, TF01("DTAIN") = Format("yyyy-mm-dd", Now()) TF01("DTAIN") returned null. Then i inverted the statemente, like this: TF01("DTAIN") = Format(now(), "yyyy-mm-dd") Now i have the error...

I understand what you explain, and TF01("DTAIN") = Now() works but, than i have in the save field, this values: 09-01-2004 17:18:27 09-01-2004 17:19:43 20-11-2003 16:34:56 2003-08-28-10.35.51 2003-08-28-10.12.10 05-11-2003 16:31:04 2003-10-13-11.53.20 2003-07-29-08.48.43...