Hi All,
I am getting an error saying that now() is not a reconized function in my datediff function would any one know why it is not being reconized?
Thanks for the help
-------------------------------------------------------------------------------------------------------------
USE Master
EXEC xp_startmail 'outlook', 'drive8'
Use inv_tracking
Declare @MyRecipients...
cptcanada
Last Activity: Jun 6 '08, 03:46 PM
Joined: May 28 '08
Location:
-
DateDiff function in SQl written in VB
-
I am uisng SQL server 2005, and for some reason it donts like any date format i am trying to use i get an error saying that the current_date is incorrect syntax -
i am using the current_dateLeave a comment:
-
and now when i use
mStringSQL1 = "DELETE * FROM Driver_daily_lo gs WHERE CURRENT_TIMESTA MP > date_destroyed"
it is giving me an erro on the * saying that it is incorrect syntax near '*'Leave a comment:
-
sorry the date is in dd/mm/yyyyLeave a comment:
-
ya date_destroyed is in that formatLeave a comment:
-
Now even with adding in the comma that was missing I am still getiign an erro message saying incorrect syntax near ' , '
mStringSQL = "DELETE Driver_daily_lo gs.emp_id, Driver_daily_lo gs.date_recieve d, " _
& "Driver_daily_l ogs.violation, Driver_daily_lo gs.form_manner, Driver_daily_lo gs.log_status, " _
& "Driver_daily_l ogs.status_date , Driver_daily_lo gs.date_destroy ed, "...Leave a comment:
-
Thanks for the help, I am just getting used to doing SQL in VBLeave a comment:
-
VB syntax error
HI, I am getting a sytax error saying that I have a comma that is not in a correct place. I have re-written this code many times over in idfferent forms and I am still getting the runtime syntax error,
Thanks for the help
mStringSQL = "DELETE Driver_daily_lo gs.emp_id, Driver_daily_lo gs.date_recieve d, " _
& "Driver_daily_l ogs.violation, Driver_daily_lo gs.form_manner, Driver_daily_lo gs.log_status,... -
Thanks that helped out alotLeave a comment:
-
Where clause + VB
Why does it say WHERE DATE()>date_des troyed is not a roconized function in VB?
Thanks for the help -
unterminated string error in Vb and SQL
here is the VB code, and i am using the &_ to connect all my lines into one sting, why am i still getting the error?
Thanks for the help
So this is my code now and I am still getting the unterminated error
ConnectionStrin g = "Provider=SQLOL EDB.1;server=ws us;Integrated Security=SSPI;P ersist Security Info=False;Init ial Catalog=inv_tra cking"...Leave a comment:
-
So this is my code now and I am still getting the unterminated error
ConnectionStrin g = "Provider=SQLOL EDB.1;server=ws us;Integrated Security=SSPI;P ersist Security Info=False;Init ial Catalog=inv_tra cking"
set cn = CreateObject("A DODB.Connection ")
cn.Open ConnectionStrin g
mStringSQL ="INSERT INTO driver_destroye d_log ( emp_id, date_recieved, violation, form_manner, log_status, status_date,...Leave a comment:
-
so right after the inerst statement line, select put an & in?Leave a comment:
-
That is correct, but there is a ; ending the SQL statementLeave a comment:
-
Ok so with the line of code I have I moved the quotations so that the where clause is appart of the sting, but when i did that it tells me the string is unterminated.Leave a comment:
-
Since I am developing in InfoPath there is no error number that is displayed when I get the two errorsLeave a comment:
-
Well the first error I get is a case error on the select stements. Then when I put the select statement in brackets it gives me an Expected Statement error.Leave a comment:
-
Help with VB + SQL code
I am trying to useSQL code inside VB code and I keep getting an Expected Case error on my first select statement, can any one help me with this??
Thanks
ConnectionStrin g = "Provider=SQLOL EDB.1;server=ws us;Integrated Security=SSPI;P ersist Security Info=False;Init ial Catalog=inv_tra cking"
set cn = CreateObject("A DODB.Connection ")
cn.Open ConnectionStrin g
mStringSQL ="INSERT...
No activity results to display
Leave a comment: