Is it possible to code the SELECT statement in the code routine? The help documentation is very limited in this area.
Thanks
Server Routine - Custom Build
Moderators: chulett, rschirm, roy
-
- Participant
- Posts: 3337
- Joined: Mon Jan 17, 2005 4:49 am
- Location: United Kingdom
Do you mean a "SELECT" to a remoted database (ODBC, or direct DB connect) or to a Hash file?
Since routines tend to get called often, quite frequently once per row of data, doing any type of a SELECT will be extremely slow - considering the enormous overhead involved in connecting and opening up a DB connection.
Since routines tend to get called often, quite frequently once per row of data, doing any type of a SELECT will be extremely slow - considering the enormous overhead involved in connecting and opening up a DB connection.