473,545 Members | 2,469 Online
Bytes | Software Development & Data Engineering Community
+ Post

Home Posts Topics Members FAQ

Give me expected query name after executed

1 New Member
Expand|Select|Wrap|Line Numbers
  1. access.Open("Provider = Microsoft.Jet.OLEDB.4.0;" &
  2.                  "Data Source = '" & Application.StartupPath & "\test.mdb'"
  3.                  )
  4.         value = TextBox2.Text
  5.         query.CommandText = "insert"
  6.         query.CommandType = ADODB.CommandTypeEnum.adCmdStoredProc
  7.         query.Parameters.Append(query.CreateParameter("RID", ADODB.DataTypeEnum.adInteger, ADODB.ParameterDirectionEnum.adParamInput, value))
  8.         query.ActiveConnection = access
  9.         query.Prepared = True
  10.         record.Open(query,, ADODB.CursorTypeEnum.adOpenDynamic, ADODB.LockTypeEnum.adLockOptimistic)
I have no idea where my code wrong @@
Sep 17 '15 #1
0 998

Sign in to post your reply or Sign up for a free account.

Similar topics

1
1680
by: sofakingfree | last post by:
I could have sworn that Access 95/97 printed the query name as the header when you print out queries. It doesn't do that with version 2003. Is there some option I'm missing? Any help would be appreciated.
4
2306
by: Zachary Hilbun | last post by:
I need to write an ASP that requires a user to give a User Name and Password to run it. Whenever I've used this on the Web it displays a standard dialog and then offers to save the User Name and Password on my computer so that I don't have to enter it again. How is it that this standard dialog is displayed? Does the ASP (in my case C#) do...
19
17261
by: bubzilla | last post by:
Hi, i´ve got about 10 headerfiles with implemented classes. Now when i try to compile them i get the following message: In file included from Proxy/ServerCnx.hh:36, from Proxy/Payload.hh:30, ...
2
8396
by: bubzilla | last post by:
Hi, i´ve got about 10 headerfiles with implemented classes. Now when i try to compile them i get the following message: In file included from Proxy/ServerCnx.hh:36, from Proxy/Payload.hh:30, ... from main.cc:28 Proxy/Interface.hh:83: error: expected class-name before '{'
1
1424
by: katieking | last post by:
I would like a field in a query to contain the name of the query that is producing the data, in order to maintain transparency of data flows when the data is copied into Excel. Is there any way of returning the query name in a field expression? The query is being run manually rather than through code. Thanks
5
15304
by: gyre | last post by:
Hi! I've got a little problem I've been dealing with for several days :(( Code is written in Qt. I'll try to explain it: I created an abstract class "VcaNode" with 4 virtual methods and 3 other members...it is in special header: //ABSTRACT CLASS MEMBER: #ifndef _VCA_NODE #define _VCA_NODE
10
29123
by: famat | last post by:
Hi all, I have C++ source code that compiles on windows-MS VS2005 without any problem. I am trying to compile it in Linux gcc version 4.1.2 (Ubuntu 4.1.2-0ubuntu4) and I ran into the following compiler error: error: expected template-name before ‘<’ token error: expected `{' before ‘<’ token error: expected unqualified-id before ‘<’ token ...
12
26390
by: Fab | last post by:
Hi, I try to compile a 2 years old project (successfully compiled with g++ 3.3, if I correctly remember ). But get problems now with g++ -gcc 4.2.3 : #include <list> #include <hash_map>
7
3203
by: tabla | last post by:
what happens when a sql query get executed containing joins in it.explain in details
0
7425
by: Hystou | last post by:
Most computers default to English, but sometimes we require a different language, especially when relocating. Forgot to request a specific language before your computer shipped? No problem! You can effortlessly switch the default language on Windows 10 without reinstalling. I'll walk you through it. First, let's disable language...
0
7682
Oralloy
by: Oralloy | last post by:
Hello folks, I am unable to find appropriate documentation on the type promotion of bit-fields when using the generalised comparison operator "<=>". The problem is that using the GNU compilers, it seems that the internal comparison operator "<=>" tries to promote arguments from unsigned to signed. This is as boiled down as I can make it. ...
0
7935
jinu1996
by: jinu1996 | last post by:
In today's digital age, having a compelling online presence is paramount for businesses aiming to thrive in a competitive landscape. At the heart of this digital strategy lies an intricately woven tapestry of website design and digital marketing. It's not merely about having a website; it's about crafting an immersive digital experience that...
1
5351
isladogs
by: isladogs | last post by:
The next Access Europe User Group meeting will be on Wednesday 1 May 2024 starting at 18:00 UK time (6PM UTC+1) and finishing by 19:30 (7.30PM). In this session, we are pleased to welcome a new presenter, Adolph Dupré who will be discussing some powerful techniques for using class modules. He will explain when you may want to use classes...
0
5069
by: conductexam | last post by:
I have .net C# application in which I am extracting data from word file and save it in database particularly. To store word all data as it is I am converting the whole word file firstly in HTML and then checking html paragraph one by one. At the time of converting from word file to html my equations which are in the word document file was convert...
0
3479
by: TSSRALBI | last post by:
Hello I'm a network technician in training and I need your help. I am currently learning how to create and manage the different types of VPNs and I have a question about LAN-to-LAN VPNs. The last exercise I practiced was to create a LAN-to-LAN VPN between two Pfsense firewalls, by using IPSEC protocols. I succeeded, with both firewalls in...
0
3465
by: adsilva | last post by:
A Windows Forms form does not have the event Unload, like VB6. What one acts like?
1
1911
by: 6302768590 | last post by:
Hai team i want code for transfer the data from one system to another through IP address by using C# our system has to for every 5mins then we have to update the data what the data is updated we have to send another system
1
1037
muto222
by: muto222 | last post by:
How can i add a mobile payment intergratation into php mysql website.

By using Bytes.com and it's services, you agree to our Privacy Policy and Terms of Use.

To disable or enable advertisements and analytics tracking please visit the manage ads & tracking page.