> On 5/23/2005 Doug Henry [mailto:[EMAIL PROTECTED] wrote: > I have always used awka to convert awk scripts to C code, > allowing for a native execuatable to be built, seems to be > the most compatible solution. >
That's cool! Thanks for the info on http://awka.sourceforge.net/ I'd not seen that before. Solaris awk compatibility issues can often be resolved by using "nawk" (which is installed in the base OS along with awk). I've not tried using sqlite under Solaris so this is more of a general comment, the SUN awk is pretty basic. As Tiago pointed out gawk will behave as expected BUT you do need to go ahead and install it. Could a Solaris developer/user try using nawk? I just spent a few mins getting sqlite-3.2.1.tar.gz from http://sqlite.org/download.html and converted all the "awk" calls into "nawk" calls. % diff ORIG_Makefile.in HACKED_Makefile.in 225c225 < | awk '{print $$5,$$6}' >last_change --- > | nawk '{print $$5,$$6}' >last_change 326c326 < sort -n -b +2 opcodes.h | awk -f $(TOP)/mkopcodec.awk >opcodes.c --- > sort -n -b +2 opcodes.h | nawk -f $(TOP)/mkopcodec.awk >opcodes.c 329c329 < cat parse.h $(TOP)/src/vdbe.c | awk -f $(TOP)/mkopcodeh.awk >opcodes.h --- > cat parse.h $(TOP)/src/vdbe.c | nawk -f $(TOP)/mkopcodeh.awk >opcodes.h A quick "./configure ; make" on an old Solaris 2.6 box and I ended up with an sqlite3 binary that handled a simple create/insert/select piece of SQL; not conclusive but a good indicator. I don't have TCL so I wasn't able to run the test suite. Using nawk (for Solaris) would remove dependencies on extra tools (like gawk or perl). Chris