Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Dates and Variables
I'm trying to hit a stored procedure in SQL but I'm getting an error when I'm
passing anything that needs the quotes " " for SQL. How do I pass the quotes in a variable? I'm sure it's amazingly simple but I'm lost. objCmd(1) = "10/25/2000" |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
Dates and Variables
did you try the double quote
objCmd(1) = ""10/25/2000"" or objCmd(1) = """&10/25/2000&""" "Michael$Lost" wrote: I'm trying to hit a stored procedure in SQL but I'm getting an error when I'm passing anything that needs the quotes " " for SQL. How do I pass the quotes in a variable? I'm sure it's amazingly simple but I'm lost. objCmd(1) = "10/25/2000" |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
Dates and Variables
Yeah it doesn't like the double qoutes
"gocush" wrote: did you try the double quote objCmd(1) = ""10/25/2000"" or objCmd(1) = """&10/25/2000&""" "Michael$Lost" wrote: I'm trying to hit a stored procedure in SQL but I'm getting an error when I'm passing anything that needs the quotes " " for SQL. How do I pass the quotes in a variable? I'm sure it's amazingly simple but I'm lost. objCmd(1) = "10/25/2000" |
#4
Posted to microsoft.public.excel.programming
|
|||
|
|||
Dates and Variables
Hi Michael, I believe you'll find that the previously supplied example is short a quotation mark, Try this example: Sub QuoteMe() Dim strParameter As String strParameter = "10/25/2000" MsgBox """" & strParameter & """" End Sub Note that the parameter value is surrounded by 4 (four) quote marks. Good Coding OfficeHacker Melbourne, Australia "Michael$Lost" wrote: I'm trying to hit a stored procedure in SQL but I'm getting an error when I'm passing anything that needs the quotes " " for SQL. How do I pass the quotes in a variable? I'm sure it's amazingly simple but I'm lost. objCmd(1) = "10/25/2000" |
#5
Posted to microsoft.public.excel.programming
|
|||
|
|||
Dates and Variables
Michael$Lost wrote: I'm trying to hit a stored procedure in SQL but I'm getting an error when I'm passing anything that needs the quotes " " for SQL. How do I pass the quotes in a variable? I'm sure it's amazingly simple but I'm lost. objCmd(1) = "10/25/2000" Instead of double quotes Chr$(34), try single quotes Chr$(39), which is ANSI standard syntax. BTW if your column is a temporal data type (e.g. DATETIME), try using an unambiguous date format e.g. objCmd(1) = Chr$(39) & "2000-10-25" & Chr$(39) Note your product may have a different 'date delimiter' e.g. MS Access uses the hash character Chr$(39). Jamie. -- |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Linking computer dates (time) to spreadsheet dates that have formu | Excel Worksheet Functions | |||
compare 2 tables of dates to find the preceding dates | Excel Worksheet Functions | |||
Not at all clear on use of variables and/or object variables | Excel Discussion (Misc queries) | |||
Identifying unique dates in a range of cells containing dates... | Excel Discussion (Misc queries) | |||
Identifying unique dates within a range of cells containing dates | Excel Discussion (Misc queries) |