Hello All,
What is the syntax for including a single quote or ' in my query? I know you have to wrap it in something, but I can't remember what it is.
Thanks in Advance
Horse
When I import a simple text file into a SQL database I am getting the following error:
"Not enough storage is available to complete this operation"
Does anyone know why this error comes up? I have imported two other larger tables into this DB without incident.
Thanks in advance
Horse
Hi Guys,
What do I need to do to read from more than one recordset within a single script? Do I need to close the Conn and RS first.
Any scripting samples would be great thanks.
Horse
Hey All,
I am executing the following query in a vbscript, it obviously pulls info from various tables:
strFilter ="SELECT A.PDDOCO, A.PDAN8, B.A6AN8, C.ABAN8, C.ABAN85, C.ABALPH, C.ABDC, B.A6TRAP FROM PRODDTA.F4311 A, PRODDTA.F0101 C, PRODDTA.F0401 B WHERE A.PDAN8 = C.ABAN8 AND C.ABAN85 =...
Hey All,
I have the below script on a field that is used to make a call using webservices and then pull back the result from that call and populate the field. The script on the field is thus:
On Error Resume Next
Dim oSOAP
Set oSOAP = CreateObject("MSSOAP.SoapClient30")...
Hey All,
I am trying to import a text file into a blank database, creating the table in the process. This is all done using DTS.
How can I avoid blank fields being represented as "Null"? I would like to to stay blank on import, but no amount of configuring in DTS can stop this from happening...
Hi All,
I am trying to execute the following script:
=====================================================
dim SOAPClient
set SOAPClient = createobject("MSSOAP.SOAPClient")
on error resume next
SOAPClient.mssoapinit("http://www.xmethods.net/sd/CurrencyExchangeService.wsdl")
if err then...
Hey All,
I was curious if anybody knew what application produces a MDF file extension? DF sounds like it stands for data file, but no regular programs such as Access, SQL or Ultra Edit can read it properly.
Any suggestions? Thanks in advance.
H
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.