Hi Daniel
The following is taken
from the documentation of the Statement class (\System
Documentation\Classes\Statement)
Description
A Statement object is used for executing a static SQL statement and
obtaining the results it produces.
Only one ResultSet
per Statement can be open
hi Lennart,
it works for select statement, but not with delete statement. my example as follow inside job:
{
Connection Con = new Connection(); Statement Stmt = Con.createStatement(); ResultSet R = Stmt.executeQuery('delete FROM TableA
whereCustomerCode = \'AAI\'');}
thx.
daniel
Lennart
Hi Daniel
If you want to execute
DELETE/INSERT/UPDATE etc. you must use the executeUpdate() method instead.
Lennart Conrad
Microsoft Business
Solutions
This posting is
provided AS IS with no warranties, and confers no rights.
From:
daniel lim [mailto:[EMAIL
hi Lennart:
i get it. using executeUpdate.
thx very much for this. i really appreciate it.
danielLennart Conrad [EMAIL PROTECTED] wrote:
Hi Daniel
The following is taken from the documentation of the Statement class (\System Documentation\Classes\Statement)
Description
A Statement
hi Lennart,
how abt with param pass in?see below:
{
Connection Con = new Connection(); Statement Stmt = Con.createStatement();str _cust;
_cust = 'ACT';
Stmt.executeUpdate('Delete FROM CSM_FG_LotNumberHoldTST_STP where
CustomerCode = ' + _cust);
}
i test it and it didn't work.
rgds,
hi Lennart,
1 more problem. its not working with Temp table in Axapta. i need to execute sql string that deal with temp table in axapta as well.
any idea?
rgds,
danielLennart Conrad [EMAIL PROTECTED] wrote:
Hi Daniel
If you want to execute DELETE/INSERT/UPDATE etc. you must use the
Hi
First of all, let me
state that Im not a developer. I will try to explain why the two tables
are not accessible from the AOT. When you create a table in the AOT, Axapta
adds the not null columns recid to the table, which is an internal
Axapta column. This is basically the problem,
Hi,
Can anyone help me?I have problem when i'm trying to use form splitter,,See,
the lines tab doesn't want to go below the spliter. But if i maximized the
form,it does. Anyone has experienced on this?Am i missing something to set
in the properties?
Thank you,
Immanuel P
put columns property of your form to 1
greetings
Koen
--- In Axapta-Knowledge-Village@yahoogroups.com, Immanuel
[EMAIL PROTECTED] wrote:
Hi,
Can anyone help me?I have problem when i'm trying to use form
splitter,,See,
the lines tab doesn't want to go below the spliter. But if i
Please remember to filter by DATAAREAID when using the Statemant class.
VardenMorris
J. Wray Nephew Ltd. - Group I.S.
234 Spanish Town Road
Kingston 11, Jamaica, W.I.
Phone: (876) - 923 - 6141 Ext. 2226Fax: (876) - 923 -5372
Cell: (876) - 3833566Email: [EMAIL PROTECTED] [EMAIL
Hello Burak Yolcu,
, 16 2005 ., you wrote:
http://erp.lanit.ru - MBS Gold Partner
--
Best regards,
Max
http://belugin.newmail.ru
ICQ:9406811
Yahoo! Groups Sponsor ~--
In low income neighborhoods, 84% do not own
Hello Burak Yolcu,
, 16 2005 ., you wrote:
BY Hi All, I need to meet an ERP consutnat firm that serves for
BY Axapta in Kazakstan. Do you konow any partner which hass office in
BY KAzakstan or near KAzakstan. may be Moskow.
BY
BY Thanks in advance for your attenttion.
Sorry,
we have
ehhhmm temporary tables are not really tables - they only exist in Axapta
but not in SQL / Oracle. So you will never get any data from a temp table this
way...
Tobias
-Ursprngliche Nachricht-
Von: daniel lim [mailto:[EMAIL PROTECTED]
Gesendet: Mi
Try:
http://www.columbusit.com/
Rgds,
Hans.
-Original Message-
From: Max Belugin [mailto:[EMAIL PROTECTED]
Sent: Mircoles, 16 de Marzo de 2005 06:46 am
To: Burak Yolcu
Subject: Re: [Axapta-Knowledge-Village] Do you know any Axapta consultant firm
in Kazakstan or Russia
Hello,
Someone had´s more information aobut eletornic banking and payment step,
payment specification and bank fee?
Thanks in advance
Rodrigo Matiazo,
Cadia Consulting do Brasil
MBS Partner
Yahoo! Groups Sponsor ~--
Has someone you know
Hi all:
My production is diveded in 2 pools.
1) I have 5 differents subproducts, 1 of them I produce and the other
4 I buy them from different supliers.
These 5 subproducts are similar, meaning they are alternative items
for the final production.
These 5 subproducts have 5 different ledger
Note: forwarded message attached.
Do you Yahoo!?
Yahoo! Small Business - Try our new resources site!
Sharing the knowledge on Axapta.
Yahoo! Groups Sponsor
ADVERTISEMENT
Yahoo! Groups Links
To visit your group on the web, go
Hi,
What Database UserId and Password u r using to login to the SQL
Server? Is it Sa or standard BMSSA login? or U hv created a new DBO?
SMitra
On Wed, 16 Mar 2005 11:17:52 -0800, Craig Fidler [EMAIL PROTECTED] wrote:
Using sql backup restore functionality
Hi;
I have a huge problem at my customer.
Customer started to complete production order and after posting picking list
I have seen some inventory dimensions has negative stock.
I have found the bug but I do not know how to solve it...
Warehouse is ware_1
Item A has 2 konfigurations
Con_1
Hi
are populated by the Demand Planner integration business logic. The Demand Planner business logic is written as stored procedures in the Demand Planner database and obtaining the recid through SQL could cause problems that cant be foreseen beforehand.
** These problems can be taken care
hi
Exactly what error are you getting?
regards
harry
From: Murukesu abarana [mailto:[EMAIL PROTECTED] Sent: Wednesday, 16 March 2005 4:24 p.m.To: Axapta-Knowledge-Village@yahoogroups.comSubject: [Axapta-Knowledge-Village] (unknown)
Hi,I cannot post good quantity and error quantity
Try www.iteration2.com
- Original Message -
From: Max Belugin [EMAIL PROTECTED]
To: Burak Yolcu Axapta-Knowledge-Village@yahoogroups.com
Subject: Re: [Axapta-Knowledge-Village] Do you know any Axapta consultant firm
in Kazakstan or Russia
Date: Wed, 16 Mar 2005 15:45:47 +0300
Hi all,
Just wanted to know if any of you have
some information regarding Axapta used as a platform for any Hospital Management
System or Lifescience work! Any one made such product or is working on it pls
share. Is there any such work on run?
Regards
Priyanka
Sharing the knowledge
Hi,
Arelease from Microsoft specific to the Life Sciences industry will
be made in end Q2 2005.
Regards
-Bidyut
-Original Message-From: PR
[mailto:[EMAIL PROTECTED]Sent: Thursday, March 17, 2005
11:06 AMTo: Axapta-Knowledge-Village@yahoogroups.com;
Bidyut,
YesI m aware that Axapta 4.0
will have lifesciences.I wanted to know if there is any
implementationor any on going work in Axapta for this field
!
Thanx
Priyanka
- Original Message -
From:
Chowdhury B.K
To: Axapta-Knowledge-Village@yahoogroups.com
Sent:
Priyanka -
There
are partner solutions for the life sciences industry.
You
may avail a listing from the add-on solutions catalog available on
partnersource.
Alsosearch for case studies and implementation references from
partnersource/ partner sites.
Regards
-Bidyut
-Original
yes...
I have worked for that Indian
project so know well of it. Tell me about NAFA and Fresenius Medical care.
were they dealing with pharmacy only as Taksal or with Hospital Management as
well i mean administrative portion or clinical portion if it is case of HMS.
Any idea?
:) .. I very well know that you have worked on Taksal !
About NAFA .. Name Nafa is changed now .. But fyi .. Nafa uses Axapta for SD only (as far as I know).
Fresenius Medical care has a number of locations. Again I am sorry,i dont have enoughinfo on how much they are using Axapta !.
Check
hi all,
i have 2 enum type, 4 elements each, i wonder wat is the best way
for me to do
like this in axapta.
if (enum1::typeA enum2::typeW)
Do something1
else
if (enum1::typeA enum2::typeX)
Do something 2
else
if (enum1::typeA enum2::typeY)
do something
Yes Abin i know that u know
!!! ;-)
Ok thanx for the info u gave i will
check it.. without translation .
Bye Abin
- priyanka
- Original Message -
From:
Jim Jo
To: Axapta-Knowledge-Village@yahoogroups.com
Sent: Thursday, March 17, 2005 12:17
PM
Hello daniellim_yh,
÷åòâåðã, 17 ìàðòà 2005 ã., you wrote:
d i have 2 enum type, 4 elements each, i wonder wat is the best way
d for me to do
d like this in axapta.
- you can use macro with template like if(a==%1 a==%2) %3;
- you can declare action pair map like:
[[value1, value2, action],
31 matches
Mail list logo