Tobias,

I dare say hndItemId is a stringEdit field on the form.  So instead of using hndItemId.text() Gary has decided to use hndItemId.toString().



Barry.



-----Original Message-----
From: [email protected] [mailto:[EMAIL PROTECTED] On Behalf Of Andrae, Tobias
Sent: Tuesday, 24 January 2006 6:00 PM
To: [email protected]
Subject: AW: [development-axapta] Development IV

oops - didn't notice thet the strItemID was used as SalesID.....
so of course it should be somthing like

    SalesID strSalesID;
    ;
    ret = super();

    strSalesID= hndItemId.toString();   
    select firstonly SalesTable where SalesTable.SalesId == strSalesID;

...but still wonder what "hndItemId"should be then...

Tobias

________________________________

Von: [email protected] im Auftrag von Bayliss, Barry
Gesendet: Mo 23.01.2006 23:29
An: [email protected]
Betreff: RE: [development-axapta] Development IV





In Axapta 3 sp2, the extended data type of salesTable.SalesId is SalesIdBase.

The definitions of the extended data types in sp2 are:
        ItemId                  str 20
        SalesIdBase                     str 22.

If you use ItemId in the definition, you may have problems if your salesId ever exceeds 20 characters.

I would recommend examining the definition of the salesTable.salesID field on your application and using that extended data type in the declaration.



Barry.


-----Original Message-----
From: [email protected] [mailto:[EMAIL PROTECTED] On Behalf Of Jens Strandberg
Sent: Monday, 23 January 2006 5:21 PM
To: [email protected]
Subject: SV: [development-axapta] Development IV


Change to

    ItemId     strItemId;
    ;
    ret = super();

    strItemId = hndItemId.toString();
    select firstonly SalesTable where SalesTable.SalesId == strItemId;

/Jens
-----Oprindelig meddelelse-----
Fra: [email protected]
[mailto:[EMAIL PROTECTED] vegne af jetjockey.geo
Sendt: 22. januar 2006 04:05
Til: [email protected]
Emne: [development-axapta] Development IV



Hi guys,

I'm working towards the development cerification. My company has given
me the MBS Axapta 3.0 training manuals and I'm trying to create the
POS application in ch 1. If anyone can point me to a copy of
ax30_enit_deviv_02.xpo, which I haven't received, that would be ideal.
Failing that, I'm tring to retrieve a record from a table when the
Sales ID is entered, with the following code in the Leave() function
of the StringEdit control:

    str     strItemId;
    ;
    ret = super();

    strItemId = hndItemId.toString();
    select firstonly SalesTable where SalesTable.SalesId == strItemId;

which generates an error:

Container and unbounded string (text) fields are not allowed in a
WHERE _expression_.

I've tried various other methods, too but can't make anything work.
Any suggestions about how to do this would be appreciated.

Thanks,

   Gary.








Yahoo! Groups Links













Yahoo! Groups Links











Yahoo! Groups Links










[Non-text portions of this message have been removed]






Yahoo! Groups Links









SPONSORED LINKS
Computer part Programming languages Microsoft axapta
Support exchange


YAHOO! GROUPS LINKS




Reply via email to