-
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
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
|