In the begining of the function I have opened a SQL table with no problems.
I have read one line at a time into arrays no problem.
I later open another sql table to update and or insert the values from the arrays into the table.
If I view the results, the result always show tha fields from the orginal SQL table. I have tried testing this in the interactive window by running just the sql code from the second table even after closing the function and I still get the fields form the first table. Yet, I am able to do an insert into the second table. Is this a defect of Alpha 5?
Code:
dim conn as sql::connection dim sqlCommand as c dim args as SQL::Arguments dim rs as SQL::ResultSet dim ct as n ct=0 args.add("whattrans",33) flag1 =conn.open("::name::Inventory") sqlCommand = "SELECT Transactions.Transaction_no, Transactions.Site, Transactions.SubSite, TransactionParts.Location, TransactionParts.Part_number, TransactionParts.Condition, TransactionParts.AutoInc, TransactionParts.Quantity, Transactions.UserName, Transactions.TransDate, TransactionParts.Processed FROM Transactions Transactions INNER JOIN TransactionParts TransactionParts ON Transactions.Transaction_no = TransactionParts.Transaction_no WHERE Transactions.Transaction_no = :whattrans" flag2 = conn.execute(sqlCommand,args) rs= conn.ResultSet recexist=rs.NextRow()
I later open another sql table to update and or insert the values from the arrays into the table.
Code:
sqlCommand = "SELECT Site, SubSite, Location, Part_ID, Condition, Qty, UserName, Updated FROM NInventory WHERE Site = :site AND SubSite = :subsite AND Part_ID = :partno" flag4 = conn.execute(sqlCommand,args) sql_ResultSet_preview(rs)
Comment