 |  |  |  |  |  |  |  |
Is it possible to change the SQL Text of Command thr' code which is created in DataEn
Please support our Visual Basic 4 / 5 / 6 advertiser: Programming Forums - DaniWeb Sister Site
 |
Is it possible to change the SQL Text of Command thr' code which is created in DataEn
0
#1 Apr 4th, 2005
Hello,
I created command object in DataEnvironment. Now I wish to change to command object's Sql Text since table name gets changed depending upon year of working.
I created command object in DataEnvironment. Now I wish to change to command object's Sql Text since table name gets changed depending upon year of working.
•
•
Join Date: Dec 2004
Posts: 2,413
Reputation: 
Solved Threads: 211
Re: Is it possible to change the SQL Text of Command thr' code which is created in DataEn
0
#2 Apr 4th, 2005
Could you be a little more specific, and possibly attach the project and database?
•
•
Join Date: Jun 2007
Posts: 68
Reputation:
Solved Threads: 0
Junior Poster in Training
Re: Is it possible to change the SQL Text of Command thr' code which is created in DataEn
0
#3 Mar 18th, 2009
Let me try to help in this case, (Since i got the same doubt),
See, there is a DataEnvironment, it has a Connection object and both's required properties set at design time. There is also a Command1 which has a SQL string command which is set during design time.
Now,
At runtime I want to change the Command1's SQL string, but since its a constant value it give an error, how to solve it?
See, there is a DataEnvironment, it has a Connection object and both's required properties set at design time. There is also a Command1 which has a SQL string command which is set during design time.
Now,
At runtime I want to change the Command1's SQL string, but since its a constant value it give an error, how to solve it?
|
Similar Threads
- Recursive file rename (Legacy and Other Languages)
- WizardSteps-> SQL Insert -> Grab ID field (ASP.NET)
- Using x86 Assembly Language with Microsoft Visual C++ (C++)
Other Threads in the Visual Basic 4 / 5 / 6 Forum
- Previous Thread: source code for finding eigenvector
- Next Thread: DataControl giving Visual Studio JIT Debugger win32 exception !
Views: 1909 | Replies: 2
| Thread Tools | Search this Thread |
Latest Visual Basic 4 / 5 / 6 Posts
- Today's Posts
- Unanswered Threads
Related Forum Features
Tag cloud for Visual Basic 4 / 5 / 6
* 6 429 2007 access activex add age append application basic beginner birth bmp c++ calculator cd cells.find click client code college column component connection connectionproblemusingvb6usingoledb copy creat ctrl+f data database datareport date delete dissertations dissertationthesis dissertationtopic edit error excel excelmacro file filename form hardware header iamthwee image inboxinvb internetfiledownload keypress label listbox listview liveperson login looping machine microsoft movingranges objectinsert open oracle password prime program prompt range-objects readfile reading record refresh remotesqlserverdatabase report retrieve save search sendbyte sites sort sql sql2008 sqlserver struct subroutine table tags textbox timer urldownloadtofile vb vb6 vb6.0 vba visual visualbasic visualbasic6 web window windows
