Software Applications Programming Errors and solutions.

We mostly post Purchase order in axapta by purchase order module or form using post button but some times we require to post Purchase order by code. You do not require to write big code to post purchase order just use purchformletter class . If you try with update method of same class then you will able to post purchase order. These link helpful to write code. to post purchase order in axapta 2009,4.0 etc. Purchase Order through Code Post Purchase order through code Enter purchase order receieved qty by code

If you have a table which has values like a,b,c and you want to get count like start from a,b or c columns value then you can use query following way. Select Left( name, 1) AS NameCaps, Count(name) as Name From Table_my GROUP BY Left( name, 1)  

 ad agency advertise advertise on google advertisement advertising companies advertising company advertising ideas advertising on google advertising online advertising techniques affiliate marketing bidvertiser brand agency cost per click digital advertising GENERAL google ads google advertising google pay google pay per click google ppc how to advertise internet advertising internet marketing agency internet marketing online local advertising online advertising online advertising agency online marketing agency pay per click pay per click advertising pay per click management pay per click marketing payperclick ppc ppc advertising ppc agency ppc company ppc management ppc marke...

This a Common way to clear all control on form using c sharp dot net code. In you common class you can write following code in method and you can call that method in any form using class object. foreach (Control C in CTRL.Controls) { if (C.GetType() == typeof(MaskedTextBox)) { C.Text = ""; } else if (C.GetType() == typeof(TextBox)) { C.Text = ""; } else if (C.GetType() == typeof(ComboBox)) { ComboBox cbox = (ComboBox)C; cbox.SelectedIndex = -1; } else if (C.GetType() == typeof(CheckBox)) { CheckBox chkbox = (CheckBox)C; chkbox.Checked = false; } else if (C.GetType() == typeof(ListBox)) { ListBox lstbox = (ListBox)C; lstbox.Items.Clear(); } else if (C.GetType() == typeof(DateTime...

These are list of categories which can be helpful to select for your blog. Electronics & Technology Camera Accessories Cameras - Digicams Computer Peripherals Fax, EPABX, Office Equipment Inverters, UPS & Generators IPods, MP3 Players Laptops - Desktops Mobile - Cell Phones Mobile Accessories Music Systems - Home Theatre Office Supplies Security Equipment - Products Tools - Machinery - Industrial TV - DVD - Multimedia Video Games - Consoles Everything Else Home & Lifestyle Air Conditioners & Coolers Antiques - Handicrafts Baby - Infant Products Bags - Luggage Barter - Exchange Books - Magazines Clothing - Garments Coins - Stamps Collectibles Discounted - Sale Items Fashion Accessories Gifts - Stationary Health - Beauty Products Home - Kitchen Appliances Home - Office Furniture Home Decor - Furnishings Household Jewellery Music - Movies Musical Instruments Paintings Sport - Fitness Equipment Toys - Games Watches Wholesale - B...

If you want use regexp_replace function with sql query then you can use following way. select regexp_replace('abcd434574@#$% [5224]efgh','[^[:aln um:]@,%,]') from dual; Output: abcd434574@%5224efgh

Below is the example of update statement with self subquery in SQL. UPDATE TB1 A SET A.IND = 'N', A.ENDDT = (Select Max(C.enqDT) -1 from TB1 C where A.Bus_KEY = C.BusKEY and C.IND ='Y' group by C.BusKEY) Where A.IND = 'Y' and A.EFFDT < (Select max(enqDT) From TB1 B Where B.col1 = A.col1 and B.bus_KEY = A.busKEY and B.IND = 'Y');