[Axapta-Knowledge-Village] Select statement

2007-12-13 Thread Syner P
Hi, I have problem with a report query. In fetch method, I used 'while select' statement with several criterion. But when the user passes blank criteria, I want to use this like '*' in queries. But it doesn't work. Ex: If (!_ItemId) _ItemId='*'; while select InventTable where

[Axapta-Knowledge-Village] Re: Select statement

2007-12-13 Thread markus_sendelbach
Hi, just try while select InventTable where ItemId like '*'; --- In Axapta-Knowledge-Village@yahoogroups.com, Syner P [EMAIL PROTECTED] wrote: Hi, I have problem with a report query. In fetch method, I used 'while select' statement with several criterion. But when the user passes

[Axapta-Knowledge-Village] Copy Record on Form

2007-12-13 Thread ricardodegouveia
Hi is there a way to copy a whole record in a form and paste it under it in the form? ie. I have SalesOrder line which is basically the same all the time except only one field changes each time. so want to copy previous one and paste and only have to change the one field?. Is this possible?

[Axapta-Knowledge-Village] Checking Values

2007-12-13 Thread ricardodegouveia
I have a problem currently i have a table filled with values, now i want to check 1 value against values in the table. ie. i have size value that will be checked against table.size to see if it falls into a certain range and then that specfic record so i can do validation on it. int size =

[Axapta-Knowledge-Village] migration of axapta 3.0 to axapta 4.0

2007-12-13 Thread mane.shankar10
can any body tell me the exact steps of code migration. because i have done data migration and ax 4.0 shows data of ax 3.0 but the changes we have made in ax 3.0 such as added one button in employee form is not reflected in data migrated ax 4.0 so please help me out