look at the axapta class statement (method executeUpdate). The help of the connection class can give you a hint how to use this class:
{
Connection Con = new Connection();
Statement Stmt = Con.createStatement();
ResultSet R = Stmt.executeQuery('SELECT VALUE FROM SQLSYSTEMVARIABLES');
while ( R.next() )
{
print R.getString(1);
}
}
With executeUpdate you can do something like "insert into table (field1, field2) values (1, 'test')", i guess.
regards
Andreas Gahr
-----Urspr�ngliche Nachricht-----
Von: Girish Bhatkal [mailto:[EMAIL PROTECTED]
Gesendet: Montag, 26. Juli 2004 11:40
An: Axapta developers
Betreff: [development-axapta] insert records SQL table outside axapta
Hi everyone,
whenever axapta needed to extract data from an SQL (on which axapta is not
running) then we can get the data using the process of
1. initialise the connection to the external database (connect using ODBC)
2. run the SQL statement and get the executed query data in the resultset
3. now by using result.next() we get the records and update in the axapta
table
similarly now if we want to run the opposite way i.e pickup the data
(multiple records) from an axapta table and then insert these records in a
table present in a database which is not running on axapta how to do this?
if anyone know how to achieve this please let me know.
thanks
Girish
Yahoo! Groups Links
| Yahoo! Groups Sponsor | |
|
|
Yahoo! Groups Links
- To visit your group on the web, go to:
http://groups.yahoo.com/group/development-axapta/
- To unsubscribe from this group, send an email to:
[EMAIL PROTECTED]
- Your use of Yahoo! Groups is subject to the Yahoo! Terms of Service.
