Hi all,
i need to store and the x++ query(select custtable) in the database and retrieve and run the same. Any one give the code sample
thiya[H]
Hi all,
i need to store and the x++ query(select custtable) in the database and retrieve and run the same. Any one give the code sample
thiya[H]
This is pretty easy.
The query will be identical to the one you created previously.
Hello,
I would recommend the option of stored procedure. Calling stored proc is fairly easy. Here is a code snippet for calling a stored proc with two input parameters -
…
conn = new UserConnection();
stmt = conn.createStatement();
cdDate = today();
cdDateStr = date2str(cdDate,213,2,3,2,3,4);
sqlStat = strfmt("%1 %2, %3, %4", “”, curext(), “’”, cdDateStr, “’”);
stmt.executeUpdate(sqlStat);
…
Hope this helps,