Can f90SQL-Lite library be applied to insert data into a database?

[tom_c_lin]

Hi all, We are currently using f90SQL-Lite library to read data fromSQL database. Now we would like to apply it to insert data into a database. It seems to me that functions such as f90SQLPutData, f90SQLBulkOperations.. are not available in the Lite version. Can f90SQL-Lite be applied to insert data? If yes, what function or subroutine should be used? Canany of you kind enough to share your experience. Thanks.

Tom Lin

[Nick2]

The pro version has a function f90SQLExecDirect, the free version has a similar equivalent function. What you want to do is compose an SQL statement such as 'INSERT INTO TABLE whatever .........' and call the function after doing f90SQLAllocHandle. Steve posted an example that does exactly this. Good luck!

[tom_c_lin]

Thanks for the e-mail which has confirmed what I was thinking. I have got my 'INSERT' subroutines working now. Have a super day.

Tom Lin