Re: Witango-Talk: crashing witango 5 on OS X

[Roland Dumas]

I've changed from witango generated sql to a direct dbms. Also changed column from tinytext to varchar. I'll know if that resolved the issue the next time a batch of orders is processed. Thanks for all the ideas, folks. On Nov 18, 2005, at 11:18 AM, Robert Shubert wrote: I would definitely try a directdbms in that case, get away from the SQL generator. The NULL could be an issue. Personally I’m in the habit of making flags that contain a 0 or a 1 and block the NULL case. It’s entirely possible that there’s some glitch in dealing with the NULL column.   On other thing would be to trace the DB. You’d like to know if the SQL statement is getting to the SQL server or not.   Robert   From: Roland Dumas [mailto:[EMAIL PROTECTED]] Sent: Friday, November 18, 2005 2:04 PM To: witango-talk@witango.com Subject: Re: Witango-Talk: crashing witango 5 on OS X     On Nov 18, 2005, at 9:56 AM, Robert Shubert wrote: Well, focus on that action then and see if you can determine if the problem is Witango’s handling of the action, or the database or the connectivity driver. I have been through the ODBC dramas and know their signatures - which show up in the crash log. This has a different signature, and looks like it's wholly within witango, as all the threads say "witango" on them.     Again, I would start by either moving that search action to a TCF call to further isolate it or use a Direct DBMS to remove Witango’s SQL generator from the picture.   You may want to start logging the input that goes into your search criteria as before write a file, send an email, whatever, just record all the criteria that went into the statement. After you get a good response you can mark the criteria set as OK or delete it. When the crash happens, you’ll theoretically be left with the bad criteria to do further testing with. search criteria are UID = <@ARG UID>. It's looking up a transaction record for processing.  thing is that this worked without a hitch until I brought in one more field. The field contains a null or a Y. That's it.      Robert   ________________________________________________________________________ TO UNSUBSCRIBE: Go to http://www.witango.com/developer/maillist.taf