![]() ![]() Take a look at thi and if you have questions, fire away.In sqlite order by clause is used to sort columns in either ascending or example and sqlite order by column number sqlite order by multiple columns In SQLite by using Order By clause we can sort SQLite select statement result set either. * do something with the data now before it's overwritten!Įvalr strAccount = %editw(numAccount :editAcct) HOption(*NoDebugIO : *SrcStmt : *ShowCpy)Ĭ+ set option datfmt=*ISO, commit=*NONE, closqlcsr=*ENDMODĬ+ select eacust from aircustom/eag20p150 * Program objective: send email to sale reps for previously faxed ITS READING THE FIRST RECORD OF THE CUSTOMER MASTER OVER AND OVER. Thank you very much! RE: SIMPLE SQL EXAMPLE rstitzel (MIS) The program that I'm trying to create as a test is a simple Customer Address Listing.Ĭ+ SELECT CustNum, CustName, CustAddr, CustCity, CustState, CustZip from CUSTMAST If someone could please post a small complete RPG program using embedded SQL statements that would be great. I've read some of SQL posts in this forum but only see snippets of code and don't understand all of it. Can I do the select, dow not %eof(WMCUST), do some calcs, perform the select again, enddo ![]() ![]() Assuming the SELECT statement is like a READ (one record at a time) I would have to "wrap" the SELECT statement in a loop? Not sure how this would be coded. I have a lot of questions and an example probably would answer most. I've decided to start to try using SQL in my RPG programs as I'm reading that there are some advantages and I also want to broaden my skills. ![]()
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |