in reply to DBI insert statement

Generate a small test script using perhaps DBD::SQLite that demonstrates your issue. With no idea of the content or configuration of the databases and no error logs there's not a lot can do. See I know what I mean. Why don't you? for hints about how to create your test script.

Premature optimization is the root of all job security

Replies are listed 'Best First'.
Re^2: DBI insert statement
by cbtshare (Monk) on Nov 22, 2016 at 01:42 UTC
    thank you, I am not sure what the test script would do or prove, everything works, and I can get data back, but my insert is the issue.
      everything works

      Really? Then what are you asking? If the insert is the issue, write a small self contained script that demonstrates the issue with the insert.

      Actually, there are two possibilities, either the insert is failing or you are failing to validate that the insert succeeded. We can't tell anything about either of those options based on the information we have so far.

      Premature optimization is the root of all job security

      thank you, I am not sure what the test script would do or prove, everything works, and I can get data back, but my insert is the issue.

      Hi,

      Imagine you're talking to an auto mechanic on the telephone

      You say car works , gas/battery/keys all work, car wont start ... you text a picture of the car ...

      Mechanic says bring the car into the shop

      Reproducing the problem in 20 lines is the equivalent of showing the mechanic the car, the least frustrating way to solve impossible problems

        I understand what you are saying, but that would be useful if the script was huge lines of code, the script is just 40 lines, and the only part not working(means it runs, no errors, but there is no data in the tables of the destination DB) is the insert .so I guess I will try inserting from the command line