I want to write arrays into an InterBase table. Why doesn't the following code work?
Fast, flexible and high-performance component library for Delphi, C++ Builder and Kylix intended for work with InterBase and Firebird using Direct InterBase API.
Question: I want to write arrays into an InterBase table. Why doesn't the following code work?
pFIBQuery1->>SQL->Add("INSERT INTO T(A) VALUES(:A)");
pFIBQuery1->>pFIBQuery1->PrepareArrayFields();
pFIBQuery1->>ParamByName("A")->SetArrayValue( A );
Answer: You should use the PrepareArraySqlVar instead of PrepareArrayFields. PrepareArrayFields works with the array fields, and you do not have any array fields in your code. The PrepareArraySqlVar method works with parameters and informs the library which table and field your parameter refers to. So the correct code should be:
pFIBQuery1->>SQL->Add("INSERT INTO T(A) VALUES(:A)");
pFIBQuery1->>pFIBQuery1->PrepareArrayFields();
pFIBQuery1->>PrepareArraySqlVar(pFIBQuery1->ParamByName("A"),"T","A",False);
pFIBQuery1->>ParamByName("A")->SetArrayValue( A );
Preview text:
Navigation
We have been using FIBPlus for one of our product lines for nearly a year now; we are impressed by its speed,versatility, and innovation. Also support has been great, all support questions are adequately and swiftly answered.
My special thanks to Marina and Sergey and the rest from the FIBPlus Team for their great product and support. >>
Mario van Zeist Technical Director Euphoria Software
