Search results for query: *

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...

Thanks scriverb, but ... Your 1º suggestion, occured and error: "Type mismatch" Your 2º suggestion, the instruction seems to wrong because it's red. I know that the pc where the software works has the dateformat dd-mm-yyyy but i want that the field in the table yyyy-mm-dd. But...

Hi! I have a field (DTAIN) in a table(TF01) of type date/time and i want to obtain the system date of the pc and convert it to a date of yyyy-mm-dd TF01("DTAIN") = Year(Now()) * 10000 + Month(Now()) * 100 + Day(Now()) After executing this step, i got an error: Data type conversion...

Happy New Year, for you to Nicsin! Well, i think i have done the conection string in all ways possible including the one you say. Perhaps this problem it has to do with the kind of mashine (i dont't know). The only way i resolved this problem was puting an SQL after the conection (sql =...

Thank you, for your help! I got the idea and resolved in this way: UPDATE bibl/FGDVLD001 SET ESCRITORIO = (SELECT DISTINCT A0AREA FROM ACOGISD#E/APOL00 WHERE MOD=A0$RAM AND NAPO=A0NAPO and multi='N' ) WHERE exists (SELECT...

Sorry PHV, didn't work. An error message apeared: "Unknown option "//X" specified"