You're checking for the wrong exception...
Pieter
-Original Message-
From: development-axapta@yahoogroups.com [mailto:[EMAIL PROTECTED] On Behalf Of Stefan Osterburg
Sent: 25. oktober 2005 17:42
To: development-axapta@yahoogroups.com
Subject: Re: SV: [development-axapta] Catching DB
Try truncate from SQL
TRUNCATE TABLE SYSDATABASELOG
_
From: development-axapta@yahoogroups.com
[mailto:[EMAIL PROTECTED] On Behalf Of Cenk Ince
Sent: 27. juli 2005 08:06
To: development-axapta@yahoogroups.com
Subject: [development-axapta] [Urgnet] SysDataBaseLog drop from Sql
Hi all
more Question.
After truncate database size is still same on harddisk. How can i make it real size?
Thanks.
Kimden: development-axapta@yahoogroups.com bu kiþinin yerine: Pieter Wijnen
Gönderilmiþ: Çar 27.07.2005 11:02
Kime: development-axapta@yahoogroups.com
check out wininet at http://msdn.microsoft.com
_
From: development-axapta@yahoogroups.com
[mailto:[EMAIL PROTECTED] On Behalf Of Jesper Kehlet
Sent: 12. juni 2005 04:53
To: development-axapta@yahoogroups.com
Subject: RE: [development-axapta] Sending files via FTP
If you read the post
-Original Message-
From: Pieter Wijnen [mailto:[EMAIL PROTECTED]
Sent: 11 April 2005 02:37 PM
To: development-axapta@yahoogroups.com
Subject: RE: [development-axapta] Windows user and terminal server
you can lock it down pretty good by settings in gpedit.msc
removing start menu items from default
Yes, It is Not Good Programming technique though...
Create a Global Variable (NoYes) set it to NoYes::No as default
Set it to NoYes::Yes when you click the button
Add a Check Against the Variable in your while Loop
You Probably also need to implement DoEvents functionallity to yield
://www.smallfrymobile.com
-Original Message-
From: Pieter Wijnen [mailto:[EMAIL PROTECTED]
Sent: 06 April 2005 03:56 PM
To: development-axapta@yahoogroups.com
Subject: RE: [development-axapta] Windows user and terminal server
One common installation for all users.
Also use one config file
Personally I would use a standard (common) install separate Windows
Users (due to profie settings etc)
Pieter
_
From: Matt Benic [mailto:[EMAIL PROTECTED]
Sent: 6. april 2005 11:36
To: Axapta Dev
Cc: Hennie Potgieter
Subject: [development-axapta] Windows user and terminal server
Might be a Network related problem - Check Network
Cards/Cabling/Switches etc
Make sure that SQL Server only Accepts TCP/IP
HTH
Pieter
-Original Message-
From: Stefan Osterburg [mailto:[EMAIL PROTECTED]
Sent: 6. april 2005 14:14
To: development-axapta@yahoogroups.com
Subject:
: Pieter Wijnen [mailto:[EMAIL PROTECTED]
Sent: 06 April 2005 11:53 AM
To: development-axapta@yahoogroups.com
Subject: RE: [development-axapta] Windows user and terminal server
Personally I would use a standard (common) install separate Windows
Users (due to profie settings etc)
Pieter
You can also use the Microsoft Web Browser Control if you want to
Display the page inside Axapta control navigation et al
Pieter
_
From: thestorm1974 [mailto:[EMAIL PROTECTED]
Sent: 30. mars 2005 10:23
To: development-axapta@yahoogroups.com
Subject: [development-axapta]
The difference for Oracle is that it doesn't use ODBC at all, but speaks directly to the OCI (Oracle call interface) thus saving a few communication layers.
The hope is that future releases will communicate through ADO for SQLServer which is also much closer to the kernel than ODBC
Pieter
check this knowledge base article
http://support.microsoft.com/default.aspx?scid=kb;en-us;Q314546
hth
Pieter
-Original Message-
From: hilda cabrejos [mailto:[EMAIL PROTECTED]
Sent: 5. januar 2005 14:24
To: development-axapta@yahoogroups.com
Subject: [development-axapta] restore
you need 2 folders under appl 1 for companyA 1 for companyB (you can
elect to use standard for one of the apps)
Pieter
_
From: anton_tjiptadi [mailto:[EMAIL PROTECTED]
Sent: 21. desember 2004 10:12
To: development-axapta@yahoogroups.com
Subject: [development-axapta] 2 different
there are several riched ocx'es around. Microsoft has one so does for
instance fms (www.fmsinc.com http://www.fmsinc.com/ )
Pieter
_
From: mca_prog [mailto:[EMAIL PROTECTED]
Sent: 15. desember 2004 08:48
To: [EMAIL PROTECTED]
Subject: [development-axapta] ActiveX - text
Visual basic code sample to generate GUID:
Private Type GUID_
Data1 As Long
Data2 As Integer
Data3 As Integer
Data4(7) As Byte
End Type
Private Declare Function CoCreateGuid Lib ole32.dll (guid As GUID_) As
Long
Private Declare Function StringFromGUID2 Lib ole32.dll (guid As
to check (specifically)
network directories, or isn't there?
Thanks
/b
--- In [EMAIL PROTECTED], Pieter Wijnen
[EMAIL PROTECTED] wrote:
if your example is real life it will fail as you try to make a
share on
the server - not a directory
you can only create a new directory under a share
I think you have to use a (user)connection object to achieve that as you can't even alias a column.
otherwise something like
select myfield, count(myfield) as cnt from mytable group by myfield
would achieve it...
Pieter
_
From: Ibrahim Kilicarslan [mailto:[EMAIL PROTECTED]
Sent:
you probably have to use a temporary table and aggregate manually into
that to achieve your goal in X++
it will however be much slower (on a big table) to do so.
It is not so difficult to write connection statements for mssql oracle
to retrieve the data regardless of back-end; you will
yes,
you're right. You *can* ommit companies from sharing tables - which is
pretty neat if you have companies that differ totally from your main
ones
no need to worry, just remember to assign all companies to the group
pieter
_
From: Jens Strandberg [mailto:[EMAIL PROTECTED]
Sent:
if your example is real life it will fail as you try to make a share on
the server - not a directory
you can only create a new directory under a share (and must have
permissions on the share to do so)
ie
pad = MyServer\\MyShare\\Temp;
Pieter
_
From: byteway_so
I would check out the dundas (free) mailer program to achieve your goal
Pieter
_
From: Paulius Cerniauskas [mailto:[EMAIL PROTECTED]
Sent: 25. november 2004 15:35
To: [EMAIL PROTECTED]
Subject: [development-axapta] send email from EP
Hi,
I need to send an email from
SELECT MONTH(THEDATE), SUM(FIELD) FROM TABLE
WHERE YEAR(THEDATE) = 2004
GROUP BY MONTH(THEDATE)
Works in msSQL at least
Pieter
_
From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]
Sent: 24. november 2004 15:39
To: [EMAIL PROTECTED]
Subject: [development-axapta] Select
I'll see wether I can dig it up (I have the neccesary API calls laying
about somewhere)
Pieter
_
From: Matt Benic [mailto:[EMAIL PROTECTED]
Sent: 25. oktober 2004 11:34
To: Axapta Dev
Subject: [development-axapta] logging to windows application log
We would like more
Be careful though as axapta always appends the dataareaid (if applicable ) of the table
Pieter
-Opprinnelig melding-
Fra: Claudia Göries [mailto:[EMAIL PROTECTED]
Sendt: 6. oktober 2004 17:42
Til: [EMAIL PROTECTED]
Emne: [development-axapta] Re: Select Construct
Hi
... but you do get the full benefit of ANSI sql wathever extras Microsoft and/or Oracle throw in...
;-) Pieter
-Opprinnelig melding-
Fra: Claudia Göries [mailto:[EMAIL PROTECTED]
Sendt: 6. oktober 2004 17:42
Til: [EMAIL PROTECTED]
Emne: [development-axapta] Re: Select
.. and as always this is *fully* documented in the help files
Pieter
-Opprinnelig melding-
Fra: Holger K. Pedersen [mailto:[EMAIL PROTECTED]
Sendt: 6. oktober 2004 16:56
Til: [EMAIL PROTECTED]
Emne: RE: [development-axapta] Reflection on methods of a class
Hi Manfred,
Translation to SQL problem (me thinks), Microsoft aka navision aka
damgaard (in this context), never sought a solution to the NULL problem
(in my opinion) - instead they've chosen to ignore it (using chr(2)
for empty strings, 0 for empty numerals 1-jan-1900 for empty
dates- however, in this
They are sequential to their layer
I don't have the sequenques handy right now, so I can't elaborate, but
it does make life hell when you want to move objects (read tables) to a
different layer..
Pieter
-Opprinnelig melding-
Fra: dgaethofs [mailto:[EMAIL PROTECTED]
Sendt: 6.
Wouldn't it be nice to finally get rid of the dot-matrix reporting
thinking (where you had a fixed character width height) issue a
simple page-feed at the right moment - not forgetting page section
headers/footers mind you
Pieter
-Opprinnelig melding-
Fra:
Nope
Pieter
-Opprinnelig melding-
Fra: Matt Benic [mailto:[EMAIL PROTECTED]
Sendt: 6. oktober 2004 10:37
Til: Axapta Dev
Emne: [development-axapta] Ports revisited
Hi all,
I posted a while ago that a port check had revealed an open SMTP port on
one
of our axapta servers.
Yepp, check out the UserConnection Class
Pieter
_
From: Matt Benic [mailto:[EMAIL PROTECTED]
Sent: 16. september 2004 15:55
To: Axapta Dev
Subject: [development-axapta] External databases
Hi all,
Is it possible to read and write data in a DB outside of Axapta from
within
No, but setting up IIS will install it, if you don't specify otherwise
...
Pieter
_
From: Matt Benic [mailto:[EMAIL PROTECTED]
Sent: 16. september 2004 14:31
To: Axapta Dev
Subject: [development-axapta] Does Axapta require an SMTP server?
Hi all,
Our network admin has just
You need to use a labelcontrol use the symbol font for it (character
code 0x044) D
_
From: hm_oboe [mailto:[EMAIL PROTECTED]
Sent: 16. september 2004 16:04
To: [EMAIL PROTECTED]
Subject: [development-axapta] Special characters in reports
Hi,
one of our customers wants to
That works like a charm
Pieter
_
From: Steeve Gilbert [mailto:[EMAIL PROTECTED]
Sent: 30. juni 2004 15:57
To: [EMAIL PROTECTED]
Subject: RE : [development-axapta] 2 clients SP1 SP3
About network shared client : We can't really used shared config file since some user needs
Start menu\Programs\Administrative Tools\Event Viewer
Usually the problem is that the User Lock file gets corrupted (AOS
believes another session is running)
Pieter
_
From: Torben Bech [mailto:[EMAIL PROTECTED]
Sent: 7. juli 2004 07:47
To: '[EMAIL PROTECTED]'
Subject: SV:
Torgeir da...
http://technet.navision.com/
Pieter
-Original Message-
From: Torgeir Toms
Sent: 11. juni 2004 11:47
To: [EMAIL PROTECTED]
Subject: [development-axapta] Technet.navition.com gone
Hi
Anybody who know where and how to use Technet.
Med vennlig hilsen
Torgeir Toms
It's stored as number of seconds since midnight
ie
hours=Trunc(TimeField/3600)
mins=Trunc(TimeField/60) -Hours*60
HTH
Pieter
-Original Message-
From: Rio M. Pintor [mailto:[EMAIL PROTECTED]
Sent: 10. juni 2004 08:36
To: [EMAIL PROTECTED]
Subject: [development-axapta] Using Time
My
guess is that order by sum... is the culprit
try
using the alias instead
HTH
Pieter
-Original Message-From: Don Price
[mailto:[EMAIL PROTECTED]Sent: 22. april 2004
17:50To: [EMAIL PROTECTED]Subject: RE:
[development-axapta] Query with ORDER BY and GROUP BY
One
Have
you tried to use an SQL - tool to look at the data in the tables? (Query
Analyzer , SQL*Plus , MS Access...)
Pieter
-Original Message-From: Theissen, Annette
[mailto:[EMAIL PROTECTED]Sent: 14. april 2004
13:49To: '[EMAIL PROTECTED]'Subject:
[development-axapta]
Please
use a subject when posting to news-groups so people will know wether to read it
or not
Pieter
-Original Message-From: Malcolm Burtt
[mailto:[EMAIL PROTECTED]Sent: 15. april 2004
13:17To: Axapta E-Group (E-mail)Subject:
[development-axapta] Hi AllI'm having some
Im afraid you have to create the
cubes outside of Axapta to do that
(Correct me if Im wrong)
Pieter
-Opprinnelig melding-
Fra: modelin68
[mailto:[EMAIL PROTECTED]
Sendt: 2. april 2004 09:31
Til:
[EMAIL PROTECTED]
Emne: [development-axapta] OLAP
Cubes
Hi,
has anyone
Title: Message
If you have vb available try your code
with that , else try with vbscript
My guess is that something is wrong with
the registration of the fax server
It might however be that you should just
add a few commas between 0 the actual number as you connect through a
You can add multiple
schedules (advanced tab)
Pieter
From:
vozadali [mailto:[EMAIL PROTECTED]
Sent: 24. mars 2004 21:30
To:
[EMAIL PROTECTED]
Subject: [development-axapta] Re:
Bjørn Gudbrand, Windows service instead of batch jobs
Thank you Bjorn,
I have found a
Probably
You might use ADO instead as ADO has a close method
Pieter
-Opprinnelig melding-
Fra: Darren Khoo
[mailto:[EMAIL PROTECTED]
Sendt: 8. mars 2004 06:32
Til:
[EMAIL PROTECTED]
Emne: [development-axapta] Logoff
OCI properly
Hi guys,
I m having an issue on using
In SQL Server
Create the field with the
IDENTITY attribute
i.e
INT ID IDENTITY(1,1)
In Oracle
Create a Sequence
CREATE SEQUENCE SEQID;
Add a trigger (before insert)
Select the sequences NextVal into the ID Field
CREATE OR REPLACE TRIGGER
TRG_MYTABLE BEFORE INSERT ON MYTABLE
Title: Message
No, as
it is storedusing the undocumented (suprise!) system class bindata, using
this class you can however save it to a file thereby use it in other
apps...
Pieter
-Original Message-From: pbercher
[mailto:[EMAIL PROTECTED] Sent: 26. februar 2004
Title: Message
H_KEYLOCAL_MACHINE\SYSTEM\Controlset001\Services\Axapta Object
Server\Applications
As it
is a service...
Pieter
-Original Message-From: abinsam
[mailto:[EMAIL PROTECTED] Sent: 25. februar 2004
06:27To: [EMAIL PROTECTED]Subject: RE:
Title: Message
Sorry
too quick
H_KEYLOCAL_MACHINE\SYSTEM\CurrentControlset\Services\Axapta Object
Server\Applications
is the one to fiddle
with
Pieter
-Original Message-From: Pieter Wijnen
Sent: 25. februar 2004 10:45To:
[EMAIL PROTECTED]Subject: RE: [development
Title: Message
also
use while select ...
Pieter
-Original Message-From: Jesper Stovby
Damgaard (JSD.DK) [mailto:[EMAIL PROTECTED] Sent: 21. februar
2004 12:06To: [EMAIL PROTECTED]Subject:
SV: [development-axapta] select forupdate doesn't work for a group of
record?
you
can probably find some vb code at:
http://www.mvps.org/
regards
Pieter
-Original Message-From: pbercher
[mailto:[EMAIL PROTECTED]Sent: 19. februar 2004
13:20To: [EMAIL PROTECTED]Subject:
[development-axapta] Blobs / Grafics in Axapta SQL
DBHello,we are storing
Title: Message
Not
all Keys are automatically generated in the Registry
-Original Message-From: Aksnes Eva
[mailto:[EMAIL PROTECTED] Sent: 14. januar 2004 09:29To:
'[EMAIL PROTECTED]'Subject: RE:
[development-axapta] File open failed
Cannot find EnableOplocks in
Title: Message
[Pieter]
Try with -hint=0 as a
axapta startup parameter, this will disable axapta generated hints, and might
point to bad index hint usage
also check the "special
first row fix for oracle" as the firstfast hint tends to use the "wrong index"
they never
53 matches
Mail list logo