Code:
OleDbCommand CMD = new OleDbCommand("SELECT * INTO " + _newName + " FROM
cbbibleboy
Last Activity: Aug 9 '07, 12:51 AM
Joined: Apr 19 '07
Location:
-
C#-APP- Renaming an Access table
Hey! I posted this first on the MS Access forum, but as I have not gotten any results, I wonder if it would fit better on the C# forums (overlaps between the two). I'm trying to rename a table in Access through C#, and I've tried using the “SELECT * INTO new_table_name FROM old_table_name” method, but I'm afraid it is not working. My exact code is:
... -
C# / Access 2002 - Problem renaming table
Hey! I'm trying to rename a table in Access through C#, and I've tried using the “SELECT * INTO new_table_name FROM old_table_name” method, but I'm afraid it is not working. My exact code is:
Yet an exception is thrown every time:Code:OleDbCommand CMD = new OleDbCommand("SELECT * INTO " + _newName + " FROM " + _oldName + ")", clsDatabase.Connection); CMD.ExecuteNonQuery();
... -
Simple Line Input question
Howdy!
I'm importing a large file (213 MB) and parsing it. My question is: does the VB6 Line Input read the whole file, then select out each line, or actually only read that line. I thought it was the second case, but when I'm reading this file, it stalls like no other. A similar smaller file works, but I'm not sure that it should make any difference. (And STD_PROCESSES.G en_Rec.Record_T ype is just a fixed length string*1000)
... -
The longest natural word in the English language (aside from esoteric medical terminology) is floccinaucinihi lipilification. Though there are other longer words, Webster does not really count these, as they were simply created to try and create "the longest word". This example, however was created by natural language and also has the most i+consonant repetitions in a row.
Another long word : pneumonoultrami croscopicsilica volcanoconiosis ,... -
No, I know about the windows and such--I'm very experienced with low level window control (Win32, no MFC). I know I would need the child window, and again, that would be no problem.
I've seen it (getting selected text) done before though, so I know it's possible.
I just need to know how...Leave a comment:
-
Get Selected Text from other application
Howdy!
I need a bit of direction...
I am in need (as the title suggests) of a way to get the selected text from any application. Of course, I understand I will need to get the application's handle, but that's no problem. I'm just not sure how I would go about getting the text after that. Is there an API that would help? This should work for all selected text in nearly all applications (Word, Works, Excel, IE, etc.).
... -
Yeah, for the sake of simplicity I left out the error-checking, but it's there. There are no errors. It's just not doing anything...Leave a comment:
-
I'm afraid my post may not have been noticed so, per forum rules, I am posting this message. I'm working on a large project, but will unfortunately be completely unable to progress until this issue has been solved.
Thanks in advance! :)Leave a comment:
-
I'm not exactly sure what you are asking. It seems like your talking about function parameters, but I'm not sure. Please clarify...Leave a comment:
-
Though you have a constructor (good) you're not doing anything with it. Your constructor should have code in it that will use those values. Also, the string variables should be passed inside quotes.
P.S. I believe --though I'm not sure-- common practice is to use "char* myString", not "char myString[]", though I think both will work.Leave a comment:
-
It's a VB program that runs hidden in the background with a timer. Good question, though.Leave a comment:
-
I'm not sure what you're asking. Could you clarify?Leave a comment:
-
Yeah, that was just the simplest fix. And the '//' was an accident. I write in C most of the time so it was just a habit.Leave a comment:
-
Should your code really be in two functions? It does not appear so to me.
Notice the difference between your first code and when I reformatted it. Notice how it's not all lined up against the left side. That's what I meant by tabbing-in. By tabbing lines in, code is much easier to read and debug.Leave a comment:
-
Oops, didn't read them. You're right though, but how do I delete it?...Leave a comment:
-
In a timer, you could have it check for any window with a title "Microsoft Excel", then do whatever. Your code could look something like this:
...Code:Private Declare Function FindWindow Lib "user32" Alias "FindWindowA" (ByVal lpClassName As String, ByVal lpWindowName As String) As Long Private Declare Function SetForegroundWindow Lib "user32" (ByVal hwnd As Long) As Long Dim hwndFound
Leave a comment:
-
Sadly, I'm not sure that it's actually possible using the same way as you specified. However, you could always write your own .ocx file and load that the same way as you did the other. :)Leave a comment:
-
Another simpler (and perhaps better) way of doing it is simply:
This is the simplest way, but leaves out a lot of error-catching.Code:FileCopy "c:\a.txt", "c:\test\a.txt" // Copies file Kill "c:\a.txt" // Deletes original file
Leave a comment:
-
Here's a pretty simple/good example. Unfortunately, SMTP doesn't have easy support for attachments.
ExampleLeave a comment:
-
There is no "mid()" function in SQL, what you want is "SUBSTRING( )".
Here's a helpful link: http://www.1keydata.com/sql/sql-substring.htmlLeave a comment:
No activity results to display
Leave a comment: