General information
Category:
Coding, syntax & commands
Title:
What happened to my missing record: insert into from array
I have a SQL select statment that stores the data into an array. I then use the following to insert the data from the array into a view:
INSERT INTO helthins_view FROM ARRAY aHelth_tmp3
Debug shows the array being aHelth_tmp3[1301,22] but when I count the records inserted into helthins_view, I only come up with 1300.
Any ideas on why I'm not getting all 1301 records inserted?
Jeff
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