This happens when the table name is very long. In that case Ax will
append the table Id to the name in the database to ensure uniqueness
of the name.
Andrew Jones
a1x limited
--- In development-axapta@yahoogroups.com, shaakera_b
[EMAIL PROTECTED] wrote:
Hi there,
I have noticed
Hi Mike
Check this out, and hopefully you'll find out what you need:
http://www.axaptapedia.com/index.php/LedgerPeriodCode_table
Cheers
Andrew Jones
--- In development-axapta@yahoogroups.com, Mike Savage [EMAIL PROTECTED]
wrote:
I want to use Date Intervals in 'normal' system reports
in to
the interpretation of the query ranges.
Hope that helps a bit more than my last answer :)
Andrew Jones
--- In development-axapta@yahoogroups.com, ozzage [EMAIL PROTECTED]
wrote:
Hi Mike
Check this out, and hopefully you'll find out what you need:
http://www.axaptapedia.com/index.php
structure? Why not use
While
Select ProdTable
Where (ProdTable.dimension[1] == 'Admin' ||
ProdTable.dimension[2] ==
'fina')
{
.
}
Barry.
-Original Message-
From: development-axapta@yahoogroups.com
[mailto:[EMAIL PROTECTED] On Behalf Of ozzage
Sent: Tuesday, 7
Hi Agus
I have never seen a solution to your problem. As far as I know, it's
simply not possible to reference array fields when utilising the
extended query syntax.
I live in hope that somebody will correct me :)
Regards
Andrew Jones
--- In development-axapta@yahoogroups.com, Agus Riyadi
Yep it's another great advertisement for Axapta-run websites ;)
Perfect Programming's version control tool is worth a look. We are
using it on a large development project at the moment, modified to be
integrated with an in-house task/issue management module as well. The
build functionality is
Hi Sri Ram
There are two types of caching in Axapta - object caching and data
caching.
Object caching refers to the client machine keeping a local copy of
the Axapta objects (classes, forms etc) in an .aoc file. This is done
so that it does not have to request the objects from the AOS every
Hi Barry
Unfortunately it's not possible to use wildcards when using the
extended range syntax.
See this page for more details on this concept:
http://www.axaptapedia.com/index.php/Expressions_in_query_ranges
Regards
Andrew Jones
--- In development-axapta@yahoogroups.com, Bayliss, Barry
Hi Mike
If you google regex valid email address you'll find a lot of hits
for sites with exactly what you are after.
Here is one:
http://www.codeproject.com/aspnet/Valid_Email_Addresses.asp
It shows a regular _expression_ used to validate an email address.
The regular _expression_ checker
hi
I have never tried the other way but may be because addlink criteria
is fieldnum parent table - field num child table ?
regards
harry
Exactly. In the addLink() method the parent field should be the first
parameter, the child the second. You have them the wrong way around.
--- In development-axapta@yahoogroups.com, Anton Tjiptadi
[EMAIL PROTECTED] wrote:
Hi,
I want to join 3 tables with QueryBuildDataSource (QBDS), the
statement is like this :
snip
...the goal is, I want join table InventJournalTrans to InventDim
with key InventDimId and join table
Jesper is correct.
You can use 'like' with wildcards ('*' for zero or more characters,
and '?' for a single character).
So in this case the criteria will be:
where ledgerTrans.Voucher like 'F111*'
Hope that helps
Andrew Jones
--- In development-axapta@yahoogroups.com, Girish Bhatkal
A better place to put your code is in the validate() field.
You can return either true or false from validate() depending on the
user's selection in the box, and this will tell Axapta whether or not
to make the modification. It's easier, plus it's the Axapta way.
Also, if your grid date
I think it depends on what order you shut things down - ie 2T clients
and the AOS.
I'm not sure if what I'm describing below is exactly your problem,
but maybe it will help.
Both the AOS and the 2T clients cache the labels and only commit them
to the label data file when you shut them
Hi
You should probably use .validateWrite() on the form datasource to
check if the values on the relevant field(s) are entered (and valid).
It's a nice idea, setting .mandatory() on the datasource. That's
great as it gives you the red wavy line so the user has some visual
cues. Shame
Also...
Check out lookupField() and lookupValue() on args() (I think that's
the names... I'm going from memory here). If you fill these with the
fieldId and value that you want to search for, then the form will
open with all records shown, and the one matching those criteria
selected.
this a few times.
Try something like:
xppCompiler compiler = new xppCompiler();
str sql = 'void sql{select .}'
if(compiler.compile)
runbuf(sql);
Regards,
Morten
-Original Message-
From: ozzage [mailto:[EMAIL PROTECTED]
Sent: 21. desember 2004 20:23
To: development
You certainly can, you just need to figure out the differences
between X++ SQL and normal SQL.
Please check out the Developers Guide inside Axapta, and look through
some of the standard application code for examples.
For your two specific problems, try:
1. select count(RecId) from
There's no way of dynamically changing an X++ select, but there is a
trick which can achieve the same effect, as long as you know in
advance what your possibilities are.
For instance, using your example below:
Declare a boolean for each possibility
boolean filterDim5;
boolean
Hi
An exception will always throw to the first catch OUTSIDE all current
transactions.
If there is no catch, then it will be caught by the standard Axapta
exception handling - ie it will show the error, roll everything back,
and stop execution. That's why you don't see anything at all in
20 matches
Mail list logo
