General information
Category:
Coding, syntax & commands
I am using SPT to insert data into as AS400 database. All works fine until I try and add another field of the record to insert. What I think is happening is my insert string is getting too long. How can I use variables to make the string shorter?
My Code:
testthissd = "INSERT INTO drawmstrp (dm_drawing_number,dm_drawing_title,dm_pending_change,dm_date_issued,dm_requester_name1,dm_requester_name2, ;
dm_job_order,dm_project,dm_customer) Values(&nfn,&nf2,&nf3,&nf4,&nf5,&nf6,&nf7,&nf8,&nf9)"
*? testthissd
= SQLSETPROP(gnHandle1n, 'Transactions', 2)
= SQLEXEC(gnHandle1n, testthissd)
Next
Reply
View the map of this thread
View the map of this thread starting from this message only
View all messages of this thread
View all messages of this thread starting from this message only