RE: Witango-Talk: Simple question
Title: Message You can usually use the normal insert/update action with NULL as the content, just be sure to remove quoting. -Original Message- From: Ted Wolfley [mailto:[EMAIL PROTECTED] Sent: Wednesday, April 21, 2004 3:11 PM To: '[EMAIL PROTECTED]' Subject: RE: Witango-Talk: Simple question I figured it out. I used the Direct DBMS action, big duh on my part ;-) -Original Message- From: Roland Dumas [mailto:[EMAIL PROTECTED] Sent: Wednesday, April 21, 2004 2:55 PM To: [EMAIL PROTECTED] Subject: Re: Witango-Talk: Simple question caution: I think "" is different than NULL On Apr 21, 2004, at 11:56 AM, Alan Wolfe wrote: Hi Ted, We use R:base and can do this: update table set column='' and that sets it to null. have you tried that? - Original Message - From: Ted Wolfley To: [EMAIL PROTECTED] Sent: Wednesday, April 21, 2004 11:50 AM Subject: Witango-Talk: Simple question Hi, I would like to put a NULL in a database field with an update action into a SQL Server database but can't figure out how. Is there a metatag to use? Ted Wolfley Database/Internet Programmer The Ogden Group of Rochester phone: (585) 321 1060 x23 fax: (585) 321 0043 [EMAIL PROTECTED] www.ogdengroup.com TO UNSUBSCRIBE: Go to http://www.witango.com/developer/maillist.taf TO UNSUBSCRIBE: Go to http://www.witango.com/developer/maillist.taf TO UNSUBSCRIBE: Go to http://www.witango.com/developer/maillist.taf TO UNSUBSCRIBE: Go to http://www.witango.com/developer/maillist.taf
RE: Witango-Talk: Simple question
Title: Message I figured it out. I used the Direct DBMS action, big duh on my part ;-) -Original Message-From: Roland Dumas [mailto:[EMAIL PROTECTED] Sent: Wednesday, April 21, 2004 2:55 PMTo: [EMAIL PROTECTED]Subject: Re: Witango-Talk: Simple question caution: I think "" is different than NULL On Apr 21, 2004, at 11:56 AM, Alan Wolfe wrote: Hi Ted, We use R:base and can do this: update table set column='' and that sets it to null. have you tried that? - Original Message - From: Ted Wolfley To: [EMAIL PROTECTED] Sent: Wednesday, April 21, 2004 11:50 AM Subject: Witango-Talk: Simple question Hi, I would like to put a NULL in a database field with an update action into a SQL Server database but can't figure out how. Is there a metatag to use? Ted Wolfley Database/Internet Programmer The Ogden Group of Rochester phone: (585) 321 1060 x23 fax: (585) 321 0043 [EMAIL PROTECTED] www.ogdengroup.com TO UNSUBSCRIBE: Go to http://www.witango.com/developer/maillist.taf TO UNSUBSCRIBE: Go to http://www.witango.com/developer/maillist.taf TO UNSUBSCRIBE: Go to http://www.witango.com/developer/maillist.taf
Re: Witango-Talk: Simple question
in our db it's not, but not sure about other db's it also lets us do this: update table set column=null you might try either of these things in a DBMS and if they work try and translate them into an update action if thats what you want to use (: - Original Message - From: Roland Dumas To: [EMAIL PROTECTED] Sent: Wednesday, April 21, 2004 11:55 AM Subject: Re: Witango-Talk: Simple question caution:I think "" is different than NULLOn Apr 21, 2004, at 11:56 AM, Alan Wolfe wrote: Hi Ted, We use R:base and can do this: update table set column='' and that sets it to null. have you tried that?- Original Message -From: Ted Wolfley To: [EMAIL PROTECTED] Sent: Wednesday, April 21, 2004 11:50 AMSubject: Witango-Talk: Simple questionHi, I would like to put a NULL in a database field with an update action into a SQL Server database but can't figure out how. Is there a metatag to use? Ted Wolfley Database/Internet Programmer The Ogden Group of Rochester phone: (585) 321 1060 x23 fax: (585) 321 0043 [EMAIL PROTECTED] www.ogdengroup.com TO UNSUBSCRIBE: Go to http://www.witango.com/developer/maillist.tafTO UNSUBSCRIBE: Go to http://www.witango.com/developer/maillist.taf TO UNSUBSCRIBE: Go to http://www.witango.com/developer/maillist.taf
Re: Witango-Talk: Simple question
caution: I think "" is different than NULL On Apr 21, 2004, at 11:56 AM, Alan Wolfe wrote: Hi Ted, We use R:base and can do this: update table set column='' and that sets it to null. have you tried that? - Original Message - From: Ted Wolfley To: [EMAIL PROTECTED] Sent: Wednesday, April 21, 2004 11:50 AM Subject: Witango-Talk: Simple question Hi, I would like to put a NULL in a database field with an update action into a SQL Server database but can't figure out how. Is there a metatag to use? Ted Wolfley Database/Internet Programmer The Ogden Group of Rochester phone: (585) 321 1060 x23 fax: (585) 321 0043 [EMAIL PROTECTED] www.ogdengroup.com TO UNSUBSCRIBE: Go to http://www.witango.com/developer/maillist.taf TO UNSUBSCRIBE: Go to http://www.witango.com/developer/maillist.taf
Re: Witango-Talk: Simple question
Title: Message Hi Ted, We use R:base and can do this: update table set column='' and that sets it to null. have you tried that? - Original Message - From: Ted Wolfley To: [EMAIL PROTECTED] Sent: Wednesday, April 21, 2004 11:50 AM Subject: Witango-Talk: Simple question Hi, I would like to put a NULL in a database field with an update action into a SQL Server database but can't figure out how. Is there a metatag to use? Ted Wolfley Database/Internet Programmer The Ogden Group of Rochester phone: (585) 321 1060 x23 fax: (585) 321 0043 [EMAIL PROTECTED] www.ogdengroup.com TO UNSUBSCRIBE: Go to http://www.witango.com/developer/maillist.taf TO UNSUBSCRIBE: Go to http://www.witango.com/developer/maillist.taf
Witango-Talk: Simple question
Title: Message Hi, I would like to put a NULL in a database field with an update action into a SQL Server database but can't figure out how. Is there a metatag to use? Ted Wolfley Database/Internet Programmer The Ogden Group of Rochester phone: (585) 321 1060 x23 fax: (585) 321 0043 [EMAIL PROTECTED] www.ogdengroup.com TO UNSUBSCRIBE: Go to http://www.witango.com/developer/maillist.taf
Re: Witango-Talk: Contact with Australia
Hey Gene, I am also an "Old Timer" (Never thought I would actually want to proudly admit that). I've been with Tango since 1997 as well. I know what you were feeling though, us WiTango developers are left with disappointment from Everyware and chips on our shoulders from Pervasive. I'll bet next time they'll have an auto-responder like: Gone on vacation. Didn't bring LapTop. We still love WiTango, just not enough to bring it on vacation! Phil & Sophie. I would also like to know the progress of the java runtime library, and compiler to J2EE. Rick Sanders - Original Message - From: Wolf, Gene To: [EMAIL PROTECTED] Sent: Wednesday, April 21, 2004 7:23 AM Subject: RE: Witango-Talk: Contact with Australia God response Rick. However, all of us "old timers" with Tango were probably feeling a little deja vu the last few days. It was like, "haven't I been through this before, twice???" I know I was feeling some angst as well but was hoping for the best. Phil and Sophie do need a break now and then and I'm glad Phil has the smarts to take an "old fashioned" vacation. Certainly will recharge the batteries. I have to say though that I am anxious to get the keys that can be upgraded. I'm dying to try out the new java technology to see if there's any speed increase. Has anyone exercised this yet? Any reports on what might be expected in terms of reduced CPU load or speed increases. Yes, yes, I know, it depends on many factors, database access, query length, etc., but there has to be some effect that can be measured when moving tafs to java and I'd like to know if anyone has any experience. Welcome back Sophie and Phil!! -Original Message-From: Rick Sanders [mailto:[EMAIL PROTECTED]Sent: Tuesday, April 20, 2004 6:59 PMTo: [EMAIL PROTECTED]Subject: Re: Witango-Talk: Contact with Australia Hello, And it was a shame that Everyware sold to Pervasive. Well, if it wasn't for Pervasive, Tango turning out XML files wouldn't be a reality today. Everyware may have done a great job in support, but the top executives didn't know how to run the company to turn a profit. Neither did Pervasive, hence why they sold it. Both companies couldn't make money with the product. The shame was that Pervasive raped their customers, and left them out in the cold. I paid Pervasive $24,000 and some change for an Enterprise license. Yes, it was a hefty bill for the software. I also paid large amounts for Tango product. However, I look at the money I've spent, and made, and it was worth it. All I get for that today is With telling me that they won't support Tango, but I can't sell my license without their permission. Okay, so I won't sell my license... but I will give it away to anyone and everyone that asks. Well, unfortunately that's With Enterprises' rules. The reason why they don't want you selling it is because they don't need the headaches of another client asking why they can't upgrade to WiTango 5.5 from Tango 2000. With Enterprise also owns the Tango 2000 technology, and they call the shots with old product too. The only technology With didn't buy was the Tango 3 technology. As far as giving it away, that's not legal either. You don't own the software, you have a license to use it. I believe that you need With's written permission to transfer the license to someone else, but I'm not a corporate lawyer. As far as not being able to contact Phil or Sophie, it is possible they may have taken a much needed break. Their entire lives have been consumed by WiTango for the past 3 years. I certainly hope nothing bad has happened to them, or anyone within their organization. It would be nice to just know if they're OK. Remember one thing ladies & gents: Phil & Sophie love the product as much as you do. And, they want to keep it going and going as much as the rest of us. So, stop thinking the worst and have a little faith! Rick Sanders -Original Message-From: Steve Smith [mailto:[EMAIL PROTECTED]Sent: Tuesday, April 20, 2004 10:26 AMTo: [EMAIL PROTECTED]Subject: Re: Witango-Talk: Contact with AustraliaHey! As a former EveryWare employee I must take offense at that remark. We did our best to respond to users within 24 business hours and those that were paying customers (as apposed to evaluation users) were given priority. However any organization will have it's good days and bad ones. I just purchased a new Palm and have been trying to get the Mac 4.1 d
Re: Witango-Talk: Contact with Australia
I know I am LONG overdue... And good for you Phil. There probably does need to be a way for the issues people mentioned like bad license key to be resolved even if you are not there but people do need to take a breather. Maybe some people on the list are long overdue for vacation themselves. Dan on 4/20/04 19:12, Phil Wade at [EMAIL PROTECTED] wrote: I have literally just arrived back in Australia this morning. John McGowan is the winner of the "Guess what Phil is doing" contest. It was a vacation. A couple of days in beautiful Thailand. It is a wonderful place to visit - especially with your family. I have had a few issues that have been passed to me I will attend to them ASAP. For the pessimists amongst you, there is no need to worry. I take my kids on holiday, not my laptop - old fashioned but true. ;) Phil On 20/4/04 10:13 AM, "Customer Support" <[EMAIL PROTECTED]> wrote: Begin forwarded message: From: John McGowan <[EMAIL PROTECTED]> Date: 20 April 2004 1:17:24 AM To: "[EMAIL PROTECTED]" <[EMAIL PROTECTED]> Subject: Witango-Talk: Contact with Australia Reply-To: [EMAIL PROTECTED] Has anybody had any contact with Australia lately I'm having the hardest time trying to buy a product. Trying to figure out if Phil and Sophie are on Vacation or something... /John ___ _ TO UNSUBSCRIBE: Go to http://www.witango.com/developer/maillist.taf TO UNSUBSCRIBE: Go to http://www.witango.com/developer/maillist.taf -- Dan Stein Digital Software Solutions 799 Evergreen Circle Telford PA 18969 Land: 215-799-0192 Mobile: 610-256-2843 Fax 413-410-9682 FMP, WiTango, EDI,SQL 2000 [EMAIL PROTECTED] www.dss-db.com "When you are born, you cry and those who love you rejoice. And if you live your life as you should, when you die, you rejoice and those who love you cry." TO UNSUBSCRIBE: Go to http://www.witango.com/developer/maillist.taf -- TO UNSUBSCRIBE: Go to http://www.witango.com/developer/maillist.taf
RE: Witango-Talk: Contact with Australia
God response Rick. However, all of us "old timers" with Tango were probably feeling a little deja vu the last few days. It was like, "haven't I been through this before, twice???" I know I was feeling some angst as well but was hoping for the best. Phil and Sophie do need a break now and then and I'm glad Phil has the smarts to take an "old fashioned" vacation. Certainly will recharge the batteries. I have to say though that I am anxious to get the keys that can be upgraded. I'm dying to try out the new java technology to see if there's any speed increase. Has anyone exercised this yet? Any reports on what might be expected in terms of reduced CPU load or speed increases. Yes, yes, I know, it depends on many factors, database access, query length, etc., but there has to be some effect that can be measured when moving tafs to java and I'd like to know if anyone has any experience. Welcome back Sophie and Phil!! -Original Message-From: Rick Sanders [mailto:[EMAIL PROTECTED]Sent: Tuesday, April 20, 2004 6:59 PMTo: [EMAIL PROTECTED]Subject: Re: Witango-Talk: Contact with Australia Hello, And it was a shame that Everyware sold to Pervasive. Well, if it wasn't for Pervasive, Tango turning out XML files wouldn't be a reality today. Everyware may have done a great job in support, but the top executives didn't know how to run the company to turn a profit. Neither did Pervasive, hence why they sold it. Both companies couldn't make money with the product. The shame was that Pervasive raped their customers, and left them out in the cold. I paid Pervasive $24,000 and some change for an Enterprise license. Yes, it was a hefty bill for the software. I also paid large amounts for Tango product. However, I look at the money I've spent, and made, and it was worth it. All I get for that today is With telling me that they won't support Tango, but I can't sell my license without their permission. Okay, so I won't sell my license... but I will give it away to anyone and everyone that asks. Well, unfortunately that's With Enterprises' rules. The reason why they don't want you selling it is because they don't need the headaches of another client asking why they can't upgrade to WiTango 5.5 from Tango 2000. With Enterprise also owns the Tango 2000 technology, and they call the shots with old product too. The only technology With didn't buy was the Tango 3 technology. As far as giving it away, that's not legal either. You don't own the software, you have a license to use it. I believe that you need With's written permission to transfer the license to someone else, but I'm not a corporate lawyer. As far as not being able to contact Phil or Sophie, it is possible they may have taken a much needed break. Their entire lives have been consumed by WiTango for the past 3 years. I certainly hope nothing bad has happened to them, or anyone within their organization. It would be nice to just know if they're OK. Remember one thing ladies & gents: Phil & Sophie love the product as much as you do. And, they want to keep it going and going as much as the rest of us. So, stop thinking the worst and have a little faith! Rick Sanders -Original Message-From: Steve Smith [mailto:[EMAIL PROTECTED]Sent: Tuesday, April 20, 2004 10:26 AMTo: [EMAIL PROTECTED]Subject: Re: Witango-Talk: Contact with AustraliaHey! As a former EveryWare employee I must take offense at that remark. We did our best to respond to users within 24 business hours and those that were paying customers (as apposed to evaluation users) were given priority. However any organization will have it's good days and bad ones. I just purchased a new Palm and have been trying to get the Mac 4.1 desktop for two days now, finally got it late last night. And there have been other companies that I've dealt with in recent months where I don't receive any response at all. Makes me wonder if they even received my email or not.I do recall seeing a post a few weeks ago stating that Phil and Sophie were doing a month long tour of North America. But I didn't think that they were taking everyone with them.Hope this helps,Steve SmithOakbridge Information SolutionsOffice: (519) 624-4388GTA: (416) 606-3885Fax: (519) 624-3353Cell: (416) 606-3885Email: [EMAIL PROTECTED]Web: http://www.oakbridge.caOn Tuesday, April 20, 2004, at 09:40 AM, Tom Ferguson wrote: Everywhere... Pervasive... With...damn shame -Original Message-From: Wolf, Gene [mailto:[EMAIL PROTECTED]Sent: Tuesday, April 20, 2004 9:17 AMTo: [EMAIL PROTEC