you need to download the installer sdk.
http://www.microsoft.com/msdownload/platformsdk/sdkupdate/
then run the orca.msi to install it. then open it with orca.
Theres a doc that describes what needs doing..
http://support.installshield.com/kb/view.asp?articleid=Q106852
Nasty ain't it?
dilettante, thanks, I think this is the kind of thing I've been searching for.
"a custom client that interacts with a server using SOAP."
thats exactly what I've been trying to do :)
I've just found the INet control (microsoft internet controls) that looks like it might be capable...
I've also been looking into this. It seems to be a big chunk thats missing from the internet API's.
The only answer seems to be to use third party com/activeX solutions. There are some on component source and I'm trying one from Dart Communications as we speak. The down side of this is that...
Thats the sort of thing I'm after only I get:
Line 1: Incorrect syntax near '='.
from:
SELECT IIF(DET_TYPE ='INV', DET_GROSS, DET_GROSS) AS VALUE FROM SL_PL_NL_DETAIL
I've only seen examples where ISNULL(..) is used in the iif.
I feel like I'm being really stupid here. My SQL knowledge is...
As databases and recordsets are objects you need to use 'set'. Off the top of my head:
set rs = db.openrecordset(.....
you probably need to create them as new objects too.
ie.
Dim db As New Database
But this is more of a VB issue than SQL. You should really be using ADO objects for these...
I'm trying to create an SQL statement to pull in some values from an accounts package. The problem is that values are all stored as positive values but need to be negative for certain transaction types.
eg.
when [TRANTYPE] = "CRN", value = [GROSS] * -1
when [TRANTYPE] =...
This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
By continuing to use this site, you are consenting to our use of cookies.