-
March 27th, 2011, 06:48 AM
#1
insert Issue
-
March 27th, 2011, 08:50 AM
#2
Re: insert Issue
Your date needs to be in single quotes.
-
March 27th, 2011, 09:29 AM
#3
Re: insert Issue
Your date needs to be in single quotes.
Still the same .i got the same error
Server: Msg 170, Level 15, State 1, Line 1
Line 1: Incorrect syntax near '00'.
-
March 27th, 2011, 10:53 AM
#4
Re: insert Issue
The time AND THE DATE need quotes
-
March 28th, 2011, 12:52 PM
#5
Re: insert Issue
Originally Posted by dglienna
The time AND THE DATE need quotes
this ^^
Always use [code][/code] tags when posting code.
-
March 28th, 2011, 03:27 PM
#6
Re: insert Issue
Spoon Feeding now......
David's given you the answer ...
try this code.....
Code:
insert into cnk_stores values (3609,029,'Monslpst023','Monsoon Salam plaza','2011-03-26 00:00:00')
Articles VB6 : Break the 2G limit - Animation 1, 2 VB.NET : 2005/8 : Moving Images , Animation 1 , 2 , 3 , User Controls
WPF Articles : 3D Animation 1 , 2 , 3
Code snips: VB6 Hex Edit, IP Chat, Copy Prot., Crop, Zoom : .NET IP Chat (V4), Adv. ContextMenus, click Hotspot, Scroll Controls
Find me in ASP.NET., VB6., VB.NET , Writing Articles, My Genealogy, Forum
All VS.NET: posts refer to VS.NET 2008 (Pro) unless otherwise stated.
-
March 29th, 2011, 09:34 AM
#7
Re: insert Issue
why i am getting the following error ???.item cannot be found in the collection .
Code:
con.Execute "Insert into dbo.CNK_dailysales(Storeid,Saleserial,saleinternaldate,dumpdate,nettotal) values('" & rs!storeid & "','" & rs!saleserial & "','" & Format(rs!saleinternaldate, "YYYY-MM-DD") & "','" & Format(Now(), "YYYY-MM-DD HH:MM:SS") & "','" & rs!nettotal & "')"
-
March 29th, 2011, 10:40 AM
#8
Re: insert Issue
Well, Now, somewhere above in your code you are selecting data (rs). Since I don't have the code I would have to assume that "nettotal" is not in your select statement.
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
|