CAPI or SQL

unknown

What is the difference in CAPI and SQL packages? I have so far only used CAPI pacakage. Which package is recommended to use? Which one is faster? Is there any guidelines available on use of these packages? Regards,Mahesh

Martin_Gäckler

The CAPI Package is easy to use. With one singe CAPI call you can select any data from the database. On the other hand this simple interface returns the entire result set of your select statement. If the result set has a large number of rows and you do not need all rows in one RecArray you should use the SQL Package because this packages returns your result set row by row thus only one row is stored in memory at a time.Hope this helpsMartin