in reply to Re^2: Pass the values to the sybase stored procedure using DBI-Sybase module and exexute the procedure.
in thread Pass the values to the sybase stored procedure using DBI-Sybase module and exexute the procedure.

What I meant to suggest was:

- numeric data not have quotes in the RHS

- string data should have quotes in RHS constant assignments

- but empty data needs a null treatment - such as the NULL keyword.

I avoided being specific because normally one needs to know more about the database design before suggesting what to do about nulls - it is common for some empty fields to be unnacceptable and whereas this can be controlled by a database constraint, it is now very popular to precontrol it at the data entry point rather than endure the overhead of submitting to the database.

-M

Free your mind

  • Comment on Re^3: Pass the values to the sybase stored procedure using DBI-Sybase module and exexute the procedure.

In Section Seekers of Perl Wisdom