RE: [development-axapta] Varchar?

2005-01-18 Thread Matt Benic
So how would one use a varchar in Axapta? Is this possible? 'May be less than 2,147,483,647 bytes' seems a bit wasteful.. Regards, Matt Benic Axapta Developer UTi Sun Couriers Division "The universal aptitude for ineptitude makes any human accomplishment an incredible miracle." - Col. John

[development-axapta] can not change class' run on property

2005-01-18 Thread Agus Riyadi
Hi All, I have a class that I created in a development environment (having morphx and x++ license),and then export/import it into our client's environment that do not have x++ license (only morhpx). I wonder why do the class' run on property that I have set to 'Server' was changed to '

[development-axapta] Direct SQL Queries

2005-01-18 Thread Raal Goff
Hi, Is there any way to make a QueryRun object move through a direct SQL query? Rather than creating QueryBuildRanges and such, can I just specify 'select * from whatever...' and have the QueryRun.next() move through the results? Alternatively, is there a way to move through a table one rec

Re: [development-axapta] New tables can not assosiate in filter

2005-01-18 Thread arief . darmawan
Hi Ustun, AFAIk, In order to enable relation on your query, you have to explicitly specify relation between your table and another table you want to use CMIIW, Rgds, Arief Darmawan > > > Hi, > I have created a new temprory table and Some of it's fields have extended > data types too. >

RE: [development-axapta] New tables can not assosiate in filter

2005-01-18 Thread Harry Deshpande
Hi I think you will have to run a cross-reference update (cant think of any short-cut) Regards harry Harry Deshpande Senior Consultant CGNZ Middle Market Solutions Website: www.cgnz.com/middlemarketsolutions Ph +64 29 277 5133 Fax +64 9 358 1018 CGNZ Limited and its predecessor o

[development-axapta] New tables can not assosiate in filter

2005-01-18 Thread Üstün Uçtum
Hi, I have created a new temprory table and Some of it's fields have extended data types too. I use this as the data source of a new form that I generated, but when I cliked on the filter icon and then right click on the table; 1-n and n-1 relations are empty? How can I associate this table with

RE: [development-axapta] Varchar?

2005-01-18 Thread Rudi Hansen
No in MS SQL there is a data type called text Variable-length non-Unicode data in the code page of the server and with a maximum length of 231-1 (2,147,483,647) characters. When the server code page uses double-byte characters, the storage is still 2,147,483,647 bytes. Depending on the charac

SV: [development-axapta] Varchar?

2005-01-18 Thread Carsten F. Frandsen
On Oracle it will be a LOB I have not checked how MS SQL Server is handling a (memo) type ... Regards Carsten F. Frandsen Fra: Matt Benic [mailto:[EMAIL PROTECTED] Sendt: ti 18-01-2005 15:10 Til: Axapta Dev Emne: [development-axapta] Varchar? Hi

[development-axapta] Varchar?

2005-01-18 Thread Matt Benic
Hi all, This may seem like a stupid question, but are 'Memo' string fields the same as SQL varchars? 'Memo' seems to be the only length specification available other than exact values. Regards, Matt Benic Axapta Developer UTi Sun Couriers Division "The universal aptitude for ineptitude mak

[development-axapta] Axapta - AS400 (DB2)

2005-01-18 Thread klara232000
hi, we need to connect axapta with a warehouse system on as400. are there any experiences with odbc on db2? is this even a possibility since the 2 systems are in different cities (latency?) any opinions? thx Hubert Yahoo! Groups Links To visit your group on the web, go to

[development-axapta] Company Accounts using the same Number Sequence

2005-01-18 Thread Jens Strandberg
Hello there, I have 4 company accounts (A,B,C,D) that will be sharing the same CustTable; through a Table Collection and a virtual company account. I have several other company accounts that will operate "normally". Is there any way to setup a number sequence for CustTable; only to be used b

[development-axapta] Re: Lookup table for EDT ?

2005-01-18 Thread arief . darmawan
Hi Anton, AFAIK, Under your EDT node on AOT, there is a relation node which you can specify a relation between your EDT and specific field on an Axapta table, you can also add a fixed relation for another field on same table. By setup this relation , automatically wherever you use your EDT,

AW: [development-axapta] Lookup table for EDT ?

2005-01-18 Thread Matthias Schuster
Hi Anton, you have to add a relation on your EDT relating to the table containing the values to choose from. If you add a control to your form with the type edt, Axapta automatically creates a lookup to this table. On modified of the new control you have to modify the range value of the fo

[development-axapta] Lookup table for EDT ?

2005-01-18 Thread anton_tjiptadi
Hi, I want to add lookup table in my EDT which is relate to some table, ex : PurchTable. I want to filter the data to show only some record, for ex : data with Dimension(4) = "TNG" nb : this EDT, I'm gonna use it in Dialog so user can lookup table first to insert the value in that Dialo