Tweet
Is performance. The SELECT * may take longer to run - but you can test that to see if its enough for you to worry about. (But you are right, the Ext. DS makes it so much easier to code)
-
-
SQL & Externally Defined Data Structures
I have recently started using embedded SQL to perform searches and build subfiles. One of the things that has irked me is that the fields I used had to be in the select statement and the data structure - which can be a real pain when using a file with a lot of fields. I have now realized that I can use an externally defined data structure and change my select statement to select all of the fields. This then gives you all of the fields - just as if you had read the record with a read! This may be a common practice (forgive me for posting if it is!), but it made the use of embedded sql much more appealing to me. Does anyone know of any reason NOT to use this technique? Joe p.s. I have also learned to use DATFMT(*ISO) when compiling and this eliminates problems with default date values.
Comment