Hi Carsten,
You are missing the insert statement for the buffer. Just look into the below
code inside the while loop.
>Connection conn;
> Statement stmt;
> ResultSet resultset;
> myTable buffer;
> str spParm;
> int i;
> ;
>
> conn = new Connection() ;
> stmt = conn.createStatemen t();
> resultset = stmt.executeQuery( strfmt("exec sp_reportsform '%1'",
> curext()));
>
> while(resultset. next())
> {
> buffer.SalesId = resultset.getString (1);
> buffer.Insert;
> }
> myTable.data( buffer);
>
> many thanks..
>
Good luck!
Regards,
Kris
----- Original Message ----
From: Tri Budianto <[EMAIL PROTECTED]>
To: [email protected]
Sent: Friday, 15 February, 2008 6:24:03 PM
Subject: Re: [development-axapta] Temporary table
hi carsten..
i tried your advice, it still didnt work
any other idea?
btw, thx for your response..
On Fri, Feb 15, 2008 at 6:59 PM, Carsten F. Frandsen <[EMAIL PROTECTED] dk>
wrote:
> Hi!
>
> You should use myTable.setTmpData instead of myTable.data ...
>
> Best regards
> Carsten F. Frandsen
> a-solutions
>
> ____________ _________ _________ __
>
> From: development- [EMAIL PROTECTED] ps.com<development- axapta%40yahoogr
> oups.com> on behalf of Tri Budianto
> Sent: Fri 2/15/2008 9:57 AM
> To: development- [EMAIL PROTECTED] ps.com<development- axapta%40yahoogr
> oups.com>
> Subject: [development- axapta] Temporary table
>
>
> Hello,
>
> I have temporary table in a form. the plan is, i will fill this temporary
> table using storedprocedure.
> reading process from store procedure to a buffer is work (i've debug it)
> en from this buffer I move the data to temporary table.
> but when open the form
> i have message "The record has been deleted by another user"
> can someone help me..
>
> this is my code snippet
>
> Connection conn;
> Statement stmt;
> ResultSet resultset;
> myTable buffer;
> str spParm;
> int i;
> ;
>
> conn = new Connection() ;
> stmt = conn.createStatemen t();
> resultset = stmt.executeQuery( strfmt("exec sp_reportsform '%1'",
> curext()));
>
> while(resultset. next())
> {
> buffer.SalesId = resultset.getString (1);
> }
> myTable.data( buffer);
>
> many thanks..
>
> --
> Best Regards,
> Tri Budianto
>
> [Non-text portions of this message have been removed]
>
> [Non-text portions of this message have been removed]
>
>
>
--
Best Regards,
Tri Budianto
[Non-text portions of this message have been removed]
Now you can chat without downloading messenger. Go to
http://in.messenger.yahoo.com/webmessengerpromo.php
[Non-text portions of this message have been removed]
