AW: [development-axapta] Length of field in table
Hello, try the DictField-Object DictField df; df = new DictField(tablenum(CustTable),fieldnum(CustTable,Name)); print df.strlen(); pause; bxe, Sebastian Draese -Ursprüngliche Nachricht- Von: development-axapta@yahoogroups.com [mailto:[EMAIL PROTECTED] Im Auftrag von putchbe Gesendet: Mittwoch, 22. März 2006 09:58 An: development-axapta@yahoogroups.com Betreff: [development-axapta] Length of field in table Hi, Is there a easy way to retreive the maximum length of a text field in a table. I found a way using the AOT to get the properties but that seems to be a long way around to get a simple peace of info. J Yahoo! Groups Links YAHOO! GROUPS LINKS Visit your group "development-axapta" on the web. To unsubscribe from this group, send an email to: [EMAIL PROTECTED] Your use of Yahoo! Groups is subject to the Yahoo! Terms of Service.
RE: [development-axapta] Lookup form closes immediately
Hello Helmut, that strange behaviour happens in my cases every time, when in the lookup-form any outputs occur, something like an info, an debugprint, or something like that. are there any changes at this form ?? or is it "standard" ? bxe, SebDra -Original Message- From: HEW (Helmut Wimmer) [mailto:[EMAIL PROTECTED] Sent: Monday, December 20, 2004 1:08 PM To: development-axapta@yahoogroups.com Subject: [development-axapta] Lookup form closes immediately Hi 1. The ItemId field has a "lookup" method that will open the FRM InventItemIdLookupSimple. When the user clicks on the lookup button, the form is opened and the user can select an item id. public void lookup() { Args args; Object formRun; FormRun caller; ; args = new Args(); args.name(formStr(InventItemIdLookupSimple)); args.caller(element); formRun = classFactory.formRunClass(args); formRun.init(); this.performFormLookup(formRun); } 2. The salesunit field has a "modified" method that should simply open the lookup form again for the item id. When the user changes the unit, the lookup form is opened and then closed immediately. public boolean modified() { boolean ret; ret = super(); SalesLine_ItemId.setFocus(); SalesLine_ItemId.lookup(); return ret; } What should happen? -> Of course the lookup form should stay available so the user can select something. There is only those 2 new methods compared to a standard Axapta. Please Note: depending on which exe version you are running, the above error occurs or not: Axapta 2.5 SP1: The error does NOT occur, the lookup form stays open. Axapta 2.5 SP4: The error occurs, lookup form closes immediately. Axapta 3.0 SP3: The error occurs, lookup form closes immediately. My question is: how can I open the lookup form of a specific field on a form when the lookup is called from a different field's modified method ??? Best regards Helmut Yahoo! Groups Sponsor ~--> Make a clean sweep of pop-up ads. Yahoo! Companion Toolbar. Now with Pop-Up Blocker. Get it for free! http://us.click.yahoo.com/L5YrjA/eSIIAA/yQLSAA/saFolB/TM ~-> Yahoo! Groups Links Yahoo! Groups Sponsor ADVERTISEMENT Yahoo! Groups Links To visit your group on the web, go to:http://groups.yahoo.com/group/development-axapta/ To unsubscribe from this group, send an email to:[EMAIL PROTECTED] Your use of Yahoo! Groups is subject to the Yahoo! Terms of Service.
[development-axapta] strange behaviour of a table in the AOT
Hello, i have some trouble with a table in the AOT. The Table is placed at the VAR-Layer, but the funktion tablename2id gives me an 50002-Id, but it wasn't imported with "ID", it was created in the AOT Sync and compile of the data dictionary works well. Also the "rebuild index" at the sql-administration-form. but when i select / click the table at the AOT, Axapta Crashes immediately ! i can't even delete the table ! when i use the sql-administration-form and use the menufunction search, i'll get the message: not enough rights for this table. but the user admin has full access on every sec-key exists at the aot ! what can i do ?? how can i remove / delete this table without delete the whole var-layer ? bxe, SebDra -- - Dipl.Ing. (BA) Sebastian Draese [EMAIL PROTECTED] [EMAIL PROTECTED] NEU +++ DSL Komplett von GMX +++ http://www.gmx.net/de/go/dsl GMX DSL-Netzanschluss + Tarif zum supergünstigen Komplett-Preis! Yahoo! Groups Sponsor ~--> Make a clean sweep of pop-up ads. Yahoo! Companion Toolbar. Now with Pop-Up Blocker. Get it for free! http://us.click.yahoo.com/L5YrjA/eSIIAA/yQLSAA/saFolB/TM ~-> Yahoo! Groups Links <*> To visit your group on the web, go to: http://groups.yahoo.com/group/development-axapta/ <*> To unsubscribe from this group, send an email to: [EMAIL PROTECTED] <*> Your use of Yahoo! Groups is subject to: http://docs.yahoo.com/info/terms/
RE: [development-axapta] LOOKUP with pictures
Hello, yes, it's possible, you'll have to create a lookup-form like a normal form, place a window-control at the grid in the lookup-form. you can define an imagelist for the window-control, and the selection for the image will done via a display-method. do you know how to design a lookup-form ? calling a lookup-form ? SebDra -Original Message- From: Wolfgang Puttinger [mailto:[EMAIL PROTECTED] Sent: Friday, December 10, 2004 5:39 PM To: [EMAIL PROTECTED] Subject: [development-axapta] LOOKUP with pictures Hi everybody, Are there any posibility to create a lookupFormControll with text and pictures? I need them in the product-builder. The Lookup should show: Picture red text red Picture blue text blue ... In one field. Is this possible??? Thanks mit freundlichen Grussen Wolfgang Puttinger Rauch Import GesmbH 5310 Mondsee [Non-text portions of this message have been removed] Yahoo! Groups Sponsor ~--> $4.98 domain names from Yahoo!. Register anything. http://us.click.yahoo.com/Q7_YsB/neXJAA/yQLSAA/saFolB/TM ~-> Yahoo! Groups Links Yahoo! Groups Sponsor ADVERTISEMENT Yahoo! Groups Links To visit your group on the web, go to:http://groups.yahoo.com/group/development-axapta/ To unsubscribe from this group, send an email to:[EMAIL PROTECTED] Your use of Yahoo! Groups is subject to the Yahoo! Terms of Service.
RE: [development-axapta] Date field and the import tools
Hello, Axapta will use the date-format dd/mm/ take a look at the developer-handbook: Date literals Dates can be written as literals in X++ using the syntax (EBNF): Date literal = day \ month \ year to transform an string to date -> str2date bxe, SebDra -Original Message- From: mbenic [mailto:[EMAIL PROTECTED] Sent: Friday, December 10, 2004 7:51 PM To: [EMAIL PROTECTED] Subject: [development-axapta] Date field and the import tools Hi all, We are setting up an import from file to add data from an external system do axapta. We have managed to set up the group and almost all the data is coming through, but we can't seem to get date fields imported. Is there a standard date format we should be using or some kind of special transform we should be doing? Regards, Matt Benic Yahoo! Groups Links Yahoo! Groups Sponsor ADVERTISEMENT Yahoo! Groups Links To visit your group on the web, go to:http://groups.yahoo.com/group/development-axapta/ To unsubscribe from this group, send an email to:[EMAIL PROTECTED] Your use of Yahoo! Groups is subject to the Yahoo! Terms of Service.
RE: [development-axapta] Form lookup for date result in error
Hello, try to insert your code in the validate-method or in the modified-method of the datasource-field. using a lookup doesn't fire the modified-event on the formcontrols ! bxe, SebDra -Original Message- From: Irving [mailto:[EMAIL PROTECTED] Sent: Tuesday, December 07, 2004 4:30 PM To: [EMAIL PROTECTED] Subject: [development-axapta] Form lookup for date result in error In SalesTable I have a date field 'Delivery Date'. Whenever the user changes the date, I have to update a new logtable If the user agrees to that. Modified på control 'SalesTable_DeliveryDate': public boolean modified() boolean ret; SalesLine salesLine; ; ret = super(); if (ret) { if (Box::okCancel("Skal leveringsdato rettes på alle linier", DialogButton::Ok) == DialogButton::Ok) { ttsbegin; while select forupdate salesline where salesline.SalesId == SalesTable.SalesId { salesLine.ConfirmedDlv = SalesTable.DeliveryDate; salesLine.update(); newLogTable::CreateLogRecord(); } ttscommit; } } return ret; Whenever I use the lookup control, it runs the method modified twice, and thereby generates two log records. If I enter a new date manually using my keyboard, it runs the method modified one time and thereby generates one log record. How do I solve this problem? I only want one log record no matter how I enter the new date. -- - Dipl.Ing. (BA) Sebastian Draese [EMAIL PROTECTED] [EMAIL PROTECTED] GMX ProMail mit bestem Virenschutz http://www.gmx.net/de/go/mail +++ Empfehlung der Redaktion +++ Internet Professionell 10/04 +++ Yahoo! Groups Sponsor Get unlimited calls to U.S./Canada Yahoo! Groups Links To visit your group on the web, go to:http://groups.yahoo.com/group/development-axapta/ To unsubscribe from this group, send an email to:[EMAIL PROTECTED] Your use of Yahoo! Groups is subject to the Yahoo! Terms of Service.
RE: [development-axapta] where clause
Hi, in X++ is no IN or BETWEEN statement, use this instead: select table where table.field >= value1 && table.field<= value2 select table where table.field like "te*" // * means 0,1 or more chars select table where table.field like "te??" // ? means exact 1 char bxe, Sebastian -Original Message- From: Alfonso Collados Arroyo [mailto:[EMAIL PROTECTED] Sent: Monday, November 08, 2004 9:08 AM To: 'Development-Axapta ([EMAIL PROTECTED]) Subject: [development-axapta] where clause Hi all, I want to make a select statement like this: Select Table where Table.Field IN (Value1,Value2); How can I do this in X++? I'm interested in IN clause. Regards, Alfonso [Non-text portions of this message have been removed] Yahoo! Groups Links Yahoo! Groups Sponsor ADVERTISEMENT Yahoo! Groups Links To visit your group on the web, go to:http://groups.yahoo.com/group/development-axapta/ To unsubscribe from this group, send an email to:[EMAIL PROTECTED] Your use of Yahoo! Groups is subject to the Yahoo! Terms of Service.
RE: [development-axapta] Using ComboBox
Hi. a combobox with autodeclaration "yes" and name: combobox place this code in the click-method of a button or in the init-method of your form after the super()-call to fill elements in the combobox: int i; for (i=0;i<10;i++) { combobox.add(int2str(i)); } to select an item via code: combobox.selection(5); bye, SebDra ___ Dipl.Ing.(BA) Sebastian Draese www.source-center.de -Original Message- From: smeagul2303 [mailto:[EMAIL PROTECTED] Sent: Thursday, November 11, 2004 1:15 PM To: [EMAIL PROTECTED] Subject: [development-axapta] Using ComboBox Hi, using a combo box for showing content of a table field is easy. You get a combo box if your table field is from type enum. But how do I fill a combo box with a list of elements and how do i select programmatically one item in the list ? How do i react on user interaction ? Does anyone has experiences wwith combo box control ? Regards Manfred Yahoo! Groups Links Yahoo! Groups Sponsor ADVERTISEMENT Yahoo! Groups Links To visit your group on the web, go to:http://groups.yahoo.com/group/development-axapta/ To unsubscribe from this group, send an email to:[EMAIL PROTECTED] Your use of Yahoo! Groups is subject to the Yahoo! Terms of Service.
RE: [development-axapta] Box and integer / text
Hi, a very powerfull function is the strfmt-command, it can convert every base-datatype into a str. for example: date d = systemdateget(); real r = 3.141592; str s; ; s = strfmt("text %1 and %2",d,r); so s will be "text 08.11.2004 and 3.14" the first variable will be placed at %1, the second variable will be placed at %2, etc... but there are not format-options like num2str, int2str, date2str, bxe, Sebastian -Original Message- From: Danang Ismu Suryonugroho [mailto:[EMAIL PROTECTED] Sent: Monday, November 08, 2004 4:32 AM To: [EMAIL PROTECTED] Subject: RE: [development-axapta] Box and integer / text You can use function - num2str(real number,int character,int decimal,int separator,int separator2) - int2str(int Integer) Hope it's help ~I can do everything through HIM who gives me strength~ -Original Message- From: affekatz [mailto:[EMAIL PROTECTED] Sent: Friday, November 05, 2004 5:43 PM To: [EMAIL PROTECTED] Subject: [development-axapta] Box and integer / text Im currently working on a class and need to display some variables values ( in product builder ), and then i found the box command ( working very fine ) but it can only show text so my question is are there any way to convert the integer to text or are there another box command that can show integer and real ? Yahoo! Groups Sponsor ~--> Make a clean sweep of pop-up ads. Yahoo! Companion Toolbar. Now with Pop-Up Blocker. Get it for free! http://us.click.yahoo.com/L5YrjA/eSIIAA/yQLSAA/saFolB/TM ~-> Yahoo! Groups Links Yahoo! Groups Links Yahoo! Groups Sponsor ADVERTISEMENT Yahoo! Groups Links To visit your group on the web, go to:http://groups.yahoo.com/group/development-axapta/ To unsubscribe from this group, send an email to:[EMAIL PROTECTED] Your use of Yahoo! Groups is subject to the Yahoo! Terms of Service.