-
January 17th, 2013, 08:44 AM
#1
sql convert function
greetings
I used convert function in sql server with no problem, but when i try to use in in vb6 for my quiry it does not recognize the convert function
vdate=cdate("30/01/2011")
rst.open "Select * from mytable where docdate=" & convert(datetime,vDate, 102)
this suppose to filter the rst with docdate= vdate only
note that , docdate(datetime,null)
this gives an error :
compile error:
Sub or Function not Defined
I am not sure now if the CONVERT function of sql server is supported in VB6
rgds
cyrus
-
January 17th, 2013, 10:51 AM
#2
Re: sql convert function
If the function is part of your SQL string then it must be part of the sql string. Here you have placed it outside your quotes so VB is looking for a function named convert within your program rather than passing it on as part of the query.
Code:
rst.open "Select * from mytable where docdate= convert(datetime, " & vDate &", 102)"
Always use [code][/code] tags when posting code.
-
January 20th, 2013, 07:57 AM
#3
Re: sql convert function
its working fine now,,, thank you very much
Tags for this Thread
Posting Permissions
- You may not post new threads
- You may not post replies
- You may not post attachments
- You may not edit your posts
-
Forum Rules
|
Click Here to Expand Forum to Full Width
|