G
gus
Guest
you can even allow the user to enter the entire query string. with static queries, the entire query is bound to the database tables and local variables at the time the 4gl program is compiled. that information is then fixed and written into the r-code. with dynamic queries, part or all of the query can be bound at execution time when the query is prepared. this allows for a great deal of flexibility in exchange for some additional program complexity and work by the programmer. which one is better? that depends on your needs, how much you know when you write a program, and what you want the program user to be able to do.
Continue reading...
Continue reading...