Service Connect: Using NULL in a Whereclause

Yahoo Archive
1
Thanks Rob. It worked. I first tried it with the WSTester.exe and it
timed--out so I thought it would not work in Service Connect. I gave it
a shot though and it kicked back A LOT faster than the WSTester.exe and
works fine.

________________________________

From: vantage@yahoogroups.com [mailto:vantage@yahoogroups.com] On Behalf
Of Rob Bucek
Sent: Thursday, May 14, 2009 8:38 AM
To: vantage@yahoogroups.com
Subject: RE: [Vantage] Service Connect: Using NULL in a Whereclause





Did you try empty quotes? ''

Rob Bucek

Manufacturing Engineer

PH: 715-284-5376 ext 311

FAX: 715-284-4084

<http://www.dsmfg.com/ <http://www.dsmfg.com/> >

(Click the logo to view our site)

________________________________

From: vantage@yahoogroups.com <mailto:vantage%40yahoogroups.com>
[mailto:vantage@yahoogroups.com <mailto:vantage%40yahoogroups.com> ] On
Behalf
Of dgodfrey_amc
Sent: Thursday, May 14, 2009 10:33 AM
To: vantage@yahoogroups.com <mailto:vantage%40yahoogroups.com>
Subject: [Vantage] Service Connect: Using NULL in a Whereclause

This is what I want to do on Part.GetRows Method:

//I want do get all Parts from the Part table that has the field
//ShortChar02 populated with something. this is my guess and it is not
working. Does anyone have a suggestion on how to use a NULL value in the
condition.
'Shortchar02 <> NULL'

[Non-text portions of this message have been removed]






[Non-text portions of this message have been removed]
2
This is what I want to do on Part.GetRows Method:

//I want do get all Parts from the Part table that has the field //ShortChar02 populated with something. this is my guess and it is not working. Does anyone have a suggestion on how to use a NULL value in the condition.
'Shortchar02 <> NULL'
3
Did you try empty quotes? ''



Rob Bucek

Manufacturing Engineer

PH: 715-284-5376 ext 311

FAX: 715-284-4084

<http://www.dsmfg.com/>

(Click the logo to view our site)



________________________________

From: vantage@yahoogroups.com [mailto:vantage@yahoogroups.com] On Behalf
Of dgodfrey_amc
Sent: Thursday, May 14, 2009 10:33 AM
To: vantage@yahoogroups.com
Subject: [Vantage] Service Connect: Using NULL in a Whereclause





This is what I want to do on Part.GetRows Method:

//I want do get all Parts from the Part table that has the field
//ShortChar02 populated with something. this is my guess and it is not
working. Does anyone have a suggestion on how to use a NULL value in the
condition.
'Shortchar02 <> NULL'





[Non-text portions of this message have been removed]